In Oracle databases, the DBA_HIST_SQLSTAT view stores historical SQL execution statistics, which can be useful for performance tuning and analysis. This guide provides a clean and optimized script to retrieve…
Sometimes we need to find sql queries from AWR as performance is slowed down by costly SQL queries that use a lot of database resources. In this post, we will…
Optimizing Oracle SQL query performance is essential if you are in charge of maintaining Oracle databases. This article will demonstrate how to use a script to find top SQL in…
In our previous article, we have gone through how to generate AWR Report in Oracle. Today we will learn how to generate AWR Report in RAC environment. Let's go through…
While restoring a database, we might often face RMAN-06085 as an Oracle DBA. Today we will discuss how to resolve RMAN-06085 in Oracle. Let's go through the steps : Step…
Today in this article, we will learn how to check default tablespace in Oracle database. Let's go through the steps : Step 1: Check default tablespace Step 2: Check default…
Today in this article, we will learn how to check default tablespace for user in Oracle and then how to change it. Let's go through the steps : Step 1:…
As a DBA, we might often get complaints from the Application Team. For this, sometimes we may need to check when a table is last updated in Oracle. Today we…
If one disk group space is very low, then we need to move ASM disk from one disk group to another. Today we will learn how to do this. Let's…
Today in this article, we will learn how to resolve ORA-00261 error. Let's go through this : Error :Solution : Error : SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 10;ALTER…