Understanding Oracle database schema size is crucial for performance tuning, capacity planning, and effective resource management when managing Oracle databases. As an experienced Oracle DBA, I’ll guide you through various…
Query 1: Find Scheduler Job Details :Query 2: Find the scheduler job run Details:Query 3: Find the scheduler job log Details:Query 4: Find the currently running job details : Query…
Today in this article we will see how to find all the db_link details in Oracle Database. Let's go through this : Find all the DB_Link Details in Oracle :…
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…
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…
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…
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…
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…
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…
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.…