How to Find Active And Inactive User Sessions in Oracle

Hi, You should list all User sessions ( Active and inactive ) in the Oracle database in case of Performance

Read more

How to Move Tables and Indexes Another Tablespace in Oracle

Hi, Sometimes you need moving tables and indexes to the new tablespace in Oracle.

Read more

How to Move Tables Another Tablespace in Oracle

Hi, Sometimes you need moving tables to new tablespace in Oracle.

Read more

How to Kill Oracle Datapump Import Job

Hi, When you start  import in Oracle database with  impdp command, you may want to kill or stop these jobs.

Read more

How to Monitor RMAN Backup and Long Operations in Oracle

Hi, If you have big database about more than 1 TB, then your backup and export operations are taking long

Read more

Oracle Kill Session Scripts -4

Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or

Read more

Oracle 12c List Components Installed

Hi, You should know that which components are installed in your Oracle database as Oracle DBA.

Read more

Oracle Dataguard Monitoring Scripts -4

Hi, Dataguard should be monitored everytime by Oracle DBA.  

Read more

Oracle Dataguard Stop Start

Hi, You should stop and start your dataguard sometimes in case of need.  

Read more

Oracle Archivelog Delete

Hi, Oracle database is archiving redo log group files if database is in archivelog mode.  

Read more