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…
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 any linux kernel/ version upgrade. Let's go through this step…
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 go through this. Query to find bind variable values for…
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 will learn how to run SQL Tuning Advisor in Oracle.…
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 : Problem: ORA-12170 ErrorResolution :Step 1 : Check the db_link details…
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 : Find DDL of all the DB_LINK in Oracle: SELECT 'CREATE…
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 error. Let's go through this. Error :Resolution : Error :…
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, you'll find valuable insights here. Let's open VirtualBox. Script to…