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…
Learn Oracle Administration best practices, configurations, and expert tips for smooth database management. Optimize performance and security today!
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…
How to find bind variables for a sql in Oracle: Easy steps
Today in this article, we will see how to find bind variables for a sql in Oracle database. Let's go through the steps. Bind variables in Oracle are used for…
How to check Free space in ASM Disk Group:2 Easy Steps:
In this article, we will discuss today how to check free space in ASM Disk Group. Let's go through the steps : Step 1: Check Free Space in ASM Disk…
Enable archive log mode in oracle RAC: Easy Guide
In this post, we'll cover everything you need to know about how to enable archive log mode in Oracle RAC. Let's open our 2-node Oracle RAC(node1 and node2) VirtualBox and…