Redo logs are the most crucial part of the Oracle database. As a part of tuning, you must check the…
Kill the hung RMAN session if stuck in Oracle
It is very easy to monitor RMAN backup status and see the log file if you have redirected RMAN output…
Sometime SQL queries takes long time to complete. You can check long running sessions using v$session_longops script which will show…
Tuning slow running query in Oracle is one of the most challenging tasks for the DBA. When you run SQL…
Temporary tablespaces often referred as Temp tablespace in Oracle are used for sorting operations and can grow huge in size.…
In order to drill down database performance issue like top memory, I/O and CPU consumers, you need to check SID…
Over a period of time temporary tablespace grow in size and we must resize tempfile to overcome space issue. In…
In this article we will discuss about shrinking datafiles to reclaim unused space in an Oracle database. Below are the…
If you want to perform hot backup then your database must be in archivelog mode. Using below shell script you…