Oracle DBA Scripts

Hi, Hi, I will share Oracle RAC Administration Scripts in this post.

Hi, Hi, I will continue to share Oracle RAC Administration Scripts in this post.

Hi, Sometimes you need killing some long running sessions that coming from specific machines and specific Queries.

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

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

I will explain How to Move Tables, Index Rebuild, Partitions and Subpartitions to Another Tablespace in Oracle in Oracle.

When you start  import in Oracle database with  impdp command, you may want to kill ( impdp ) or stop these jobs. I will explain the How to Kill or …

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

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

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