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 »
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
How to run scp in Background with nohup : Easy Guide Read More »
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
How to Relink Binaries in Oracle : Easy Guide in 7 Steps
Today in this article, we will learn how to relink binaries in Oracle. It is recommended after OS patching or
How to Relink Binaries in Oracle : Easy Guide in 7 Steps Read More »
How to find bind variable values for a given sql_id in Oracle: Easy Guide
Today in this article, we will see how to find bind variable values for a given sql_id in Oracle. Let’s
How to find bind variable values for a given sql_id in Oracle: Easy Guide Read More »
How to run SQL Tuning Advisor for a sql_id in Oracle : Easy Guide
SQL Tuning Advisor (STA) can provide some recommendations for a sql_id to improve its performance. Today in this article, we
How to run SQL Tuning Advisor for a sql_id in Oracle : Easy Guide Read More »