Samir Roy

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 : Step 1 […]

What is MRP? So MRP (Managed Recovery Process) applies the information from the archived redo logs to the standby database

While turning on Flashback in the Oracle Database, sometimes we may encounter the error : ‘ORA-38706: Cannot turn on FLASHBACK

Today in this article, we will discuss about how to create and drop restore point in Oracle Database. Lets go

SRL stands for Standby Redo Log. Today in this article we will learn about how to resolve Insufficient SRLs reported

Today in this article, we will see how to check Hidden Parameter in Oracle. Let’s go through this: Query 1:

Today in this article, we will see how to find bind variables for a sql in Oracle database. Let’s go

In this article, we will discuss today how to check free space in ASM Disk Group. Let’s go through the

In this post, we’ll cover everything you need to know about how to disable archive log mode in Oracle RAC.