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 »
DB Link – ORA-12170: TNS:Connect timeout occurred: Easy Guide
Today we will learn how to resolve ORA-12170 Error while using DB Link. Let’s go through this in detail :
DB Link – ORA-12170: TNS:Connect timeout occurred: Easy Guide Read More »
How to Find DDL of DB_LINK in Oracle: A Step-by-Step Guide
In this article, we will learn how to find DDL of DB_LINK in Oracle. Let’s go through this. Query :
How to Find DDL of DB_LINK in Oracle: A Step-by-Step Guide Read More »
How to resolve ORA-46365 while starting up Oracle Database : Easy Guide
Sometimes while starting up the databases, we may get the error ORA-46365. Today we will discuss how to resolve this
How to resolve ORA-46365 while starting up Oracle Database : Easy Guide Read More »
How much size we can reduce a datafile in oracle: 1 simple script
Welcome to our guide on how to reduce a datafile in oracle database. Whether you’re a beginner or an expert,
How much size we can reduce a datafile in oracle: 1 simple script Read More »