Oracle Administration Archives - Page 5 Of 20

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 […]

Nohup is used to run a query in background. Suppose, if your query/task will be taking lot of time, even

Today in this article, we will learn how to relink binaries in Oracle. It is recommended after OS patching or

Today in this article, we will see how to find bind variable values for a given sql_id in Oracle. Let’s

SQL Tuning Advisor (STA) can provide some recommendations for a sql_id to improve its performance. Today in this article, we

Today we will learn how to resolve ORA-12170 Error while using DB Link. Let’s go through this in detail :

In this article, we will learn how to find DDL of DB_LINK in Oracle. Let’s go through this. Query :

Sometimes while starting up the databases, we may get the error ORA-46365. Today we will discuss how to resolve this

Welcome to our guide on how to reduce a datafile in oracle database. Whether you’re a beginner or an expert,