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 to generate AWR Report in RAC environment. Let's go through…
Learn Oracle Administration best practices, configurations, and expert tips for smooth database management. Optimize performance and security today!
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 RMAN-06085 in Oracle. Let's go through the steps : Step…
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 : Step 1: Check default tablespace Step 2: Check default…
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 change it. Let's go through the steps : Step 1:…
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 when a table is last updated in Oracle. Today we…
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 another. Today we will learn how to do this. Let's…
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 :Solution : Error : SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 10;ALTER…
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 by step: Steps to drop standby redo logs in Oracle…
How to run scp in Background with nohup : Easy Guide
As a Linux Admin or DBA, we may often face the issue of copying a larger file from one host to another using scp. Sometimes, our connection may be lost…
Nohup sqlplus command in Oracle : Easy Guide
Nohup is used to run a query in background. Suppose, if your query/task will be taking lot of time, even if it may take couple of days, then also we…