Master Your RMAN Backups: A Practical Guide to the RATE Parameter

Hello Friends , Introduction: The Backup Bandwidth Dilemma Have you ever started an Oracle RMAN backup only to see your production sy...

Read More

Oracle Managed Global Area (MGA): A Practical Guide

Hello Friend's  Welcome to the new post  Oracle MGA Explained: The Flexible Memory Area  If you've managed an Oracle database, you k...

Read More

Oracle Database 23c AI-Powered Tablespace Shrink: Storage Optimization Automating

Hello Friend's, Introduction Oracle Database 23c brings revolutionary AI features to optimize tablespace management, with AI-powered ...

Read More

Mastering Oracle Resource Manager: Implementing Service-Based Resource Allocation for Maximum Performance

Hello Friend's, Introduction In modern database environments that are complex and where several applications and users vie for limited...

Read More

Solution to error ORA-01035

Hello Friend's, The error "ORA-01035: ORACLE only available to users with RESTRICTED SESSION PRIMDBivilege" normally happens...

Read More

Implementing Oracle Resource Manager with Services

Hello Friend's, In this post we will discuss how to deploy Oracle Resource manager with Services In multi-tenant and multi-workload ...

Read More

New DBA Features in Oracle Database 23AI

Hello Friend's, In this post we will discuss about new AI features and its usage in oracle database 23AI. Oracle Database 23AI bring...

Read More

Solution to error ORA-12547: TNS:lost contact

Hello Friend's, What is the ORA-12547 Error? The ORA-12547 error represents a TNS that relates to a Transparent Network Substrate. It...

Read More

How to set and check the max size of PLUGGABLE DATABASE STORAGE

Hello Friend's, In This Post we will discuss about How to set and check the max size of PLUGGABLE DATABASE STORAGE So let's get ...

Read More

Oracle Datafile movement for ASM and Non ASM

Hello Friends, This post will go over online datafile movement, which was introduced in 12c and later. The following actions can now...

Read More

How to solve error while loading shared libraries: libnsl.so.1

Hello Friend's, In this post we will discuss about the solution to error while invoking the installer of 12cR2 on Linux 8.5 So let...

Read More

Add Disk to ASM diskgroup

Hello Friend's, This post will help you to add new disk to exisiting diskgroup (Oracle ASM) So let's get started. 1. Create...

Read More

How To Start and Stop Exadata Cell Services

Hello Friend's Here we are with another post . In this post we will see commands that are used in start & stop of cell service on...

Read More

How to Gather stats & Export import stats in Oracle

Hello Friend's, In this post we will see some example for stats gather in oracle database. So Let's get started To gather...

Read More

How To Relink Oracle Binaries 19c

  Hello Friend's, In this post we will discuss , How to relink an oracle Home . This method is much used for oracle installation , if we...

Read More