How to check index size in Oracle: Easy Guide
In this article, I will provide a detailed guide on how to check index size in Oracle. We'll walk you through each step of the process with proper screenshots. Let's…
How to check table size in Oracle: Easy Guide
In this article, I will provide a detailed guide on how to check table size in Oracle. We'll walk you through each step of the process with proper screenshots. Let's…
How to check CDB size & PDB size in Oracle database: Easy Guide
Welcome to our guide on how to check CDB size & PDB size in the Oracle database. Let's open VirtualBox and get started! 1. Find only CDB size2. Find CDB…
How to find Oracle database size: Easy Guide
Welcome to our guide on how to find Oracle database size. Whether you're a beginner or an expert, you'll find valuable insights here. 1. Check allocated space2. Check the occupied…
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT : Easy Guide
Today in this article, we will discuss how to resolve ORA-04036. Let's go through this in detail : Steps to Troubleshoot ORA-04036:Step 1 : Check PGA_AGGREGATE_LIMITStep 2 : Check PGA…
How to Start and Stop MRP Process in Oracle Dataguard :
What is MRP? So MRP (Managed Recovery Process) applies the information from the archived redo logs to the standby database in Oracle. Today in this article, we will go through…
ORA-38706: Cannot turn on FLASHBACK DATABASE logging: Easy Guide
While turning on Flashback in the Oracle Database, sometimes we may encounter the error : 'ORA-38706: Cannot turn on FLASHBACK DATABASE logging'. Today we will discuss how to resolve this.…
How to create and drop Restore Point in Oracle: 3 Easy Steps
Today in this article, we will discuss about how to create and drop restore point in Oracle Database. Lets go through it in detail. First of all, we need to…
Insufficient SRLs reported by DGMGRL: Easy Guide :
SRL stands for Standby Redo Log. Today in this article we will learn about how to resolve Insufficient SRLs reported by DGMGRL. If you are having different number of SRLs…
How to check Hidden Parameter in Oracle: Easy Guide :
Today in this article, we will see how to check Hidden Parameter in Oracle. Let's go through this: Query 1: Issue the below command to find all the hidden parameters…