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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »