How to Find Top SQL in Library Cache: Easy Guide
Optimizing Oracle SQL query performance is essential if you are in charge of maintaining Oracle databases. This article will demonstrate
How to Find Top SQL in Library Cache: Easy Guide Read More »
How To Generate AWR Report In RAC Environment : 2 Easy Steps
In our previous article, we have gone through how to generate AWR Report in Oracle. Today we will learn how
How To Generate AWR Report In RAC Environment : 2 Easy Steps Read More »
How to resolve RMAN-06085 in Oracle : Easy Step by step Guide
While restoring a database, we might often face RMAN-06085 as an Oracle DBA. Today we will discuss how to resolve
How to resolve RMAN-06085 in Oracle : Easy Step by step Guide Read More »
How to check default tablespace in Oracle Database : 2 Easy Steps
Today in this article, we will learn how to check default tablespace in Oracle database. Let’s go through the steps
How to check default tablespace in Oracle Database : 2 Easy Steps Read More »
How to Check Default Tablespace For User and Change it in Oracle: 3 Easy Steps
Today in this article, we will learn how to check default tablespace for user in Oracle and then how to
How to Check Default Tablespace For User and Change it in Oracle: 3 Easy Steps Read More »
How to check when a table is last updated in Oracle :
As a DBA, we might often get complaints from the Application Team. For this, sometimes we may need to check
How to check when a table is last updated in Oracle : Read More »
How to move ASM Disk from one disk group to another in Oracle :
If one disk group space is very low, then we need to move ASM disk from one disk group to
How to move ASM Disk from one disk group to another in Oracle : Read More »
How to resolve ORA-00261: log 10 of thread 1 is being archived or modified
Today in this article, we will learn how to resolve ORA-00261 error. Let’s go through this : Error : SQL>
How to resolve ORA-00261: log 10 of thread 1 is being archived or modified Read More »
How to drop standby redo logs in Oracle : 5 easy Steps
Today, we will learn how to drop standby redo logs in Oracle in this article. Let’s go through this step
How to drop standby redo logs in Oracle : 5 easy Steps Read More »