Oracle DBA Scripts and Tips

It has come to our attention that an Oracle Development company have copied our scripts without our permission and are using them as part of their own products for which they are charging users a license fee.

As a result of this, we have decided to suspend access to our DBA scripts until further notice and we regret the impact that this decision will inevitably have upon genuine users of the scripts repository.

We are continuing to monitor the situation and would encourage you to check back in the future for developments.

Script Home

Monitor Scripts

Scripts sorted by Title

Database DeadLocks ( Oracle : 7 8 8i 9i 10g )
SQL Script : This script lists details of all current database deadlocks on the system, who i
Updated: 03-NOV-98
Find Redo ( Oracle : 9i 10g )
SQL Script : Script to see what session are using redo
Updated: 28-DEC-05
MTS Monitor Script ( Oracle : 8i 9i 10g )
SQL Script : Lists difference aspects of MTS monitoring.
Updated: 27-MAY-03
Monitor All Database Locks ( Oracle : 7 8 8i 9i 10g )
SQL Script : This script lists details of all current database locks on the system, who is ho
Updated: 03-NOV-98
Monitor Cursors ( Oracle : 7 8 8i 9i 10g )
SQL Script : This script listsdetails of current open cursors.
Updated: 02-NOV-98
Monitor Data Guard ( Oracle : 9i 10g )
SQL Script : This script lists the important tables from which you can tell if Data Guard is
Updated: 19-JUL-04
Monitor Latch Contention ( Oracle : 7 8 8i 9i 10g )
SQL Script : The first statement lists information critical to determining if a database inst
Updated: 29-MAR-02
Monitor Long Operations ( Oracle : 8i 9i 10g )
SQL Script : Queries the session details for long running operations such as a Full Table /In
Updated: 03-JAN-03
Monitor Redo Logs ( Oracle : 7 8 8i 9i 10g )
SQL Script : Simple listing of redo log status and the key system statistics. The key statist
Updated: 29-MAR-02
Monitor Rollback Segments ( Oracle : 7 )
SQL Script : This script reports key indicators in determining whats happening with rollback
Updated: 06-JUN-00
Monitor Rollback Segments ( Oracle : 8 8i 9i 10g )
SQL Script : This script reports key indicators in determining whats happening with rollback
Updated: 24-NOV-05
Monitor SQL Area ( Oracle : 7 8 )
SQL Script : This script queries the SQL area ordered by the the average cost of the statemen
Updated: 30-JUN-99
Monitor SQL Area ( Oracle : 8i )
SQL Script : This script queries the SQL area ordered by the the average cost of the statemen
Updated: 24-NOV-04
Monitor SQL Area ( Oracle : 9i 10g )
SQL Script : This script queries the SQL area ordered by the the average cost of the statemen
Updated: 24-MAR-05
Monitor SQL Text and Locks ( Oracle : 7 8 8i 9i 10g )
SQL Script : This script reports the SQL text of locks currently being held in the database.
Updated: 18-MAR-02
Monitor Session Activity ( Oracle : 8i 9i 10g )
SQL Script : Script displays many different session related details for a specific Oracle Sys
Updated: 01-OCT-02
Monitor User ( Oracle : 7 8 8i 9i 10g )
SQL Script : This script reports session statistics and what queries the current user has ope
Updated: 01-OCT-02
Redo Log History ( Oracle : 8 8i )
SQL Script : Simple listing of redo log switching over time. A useful tip is to change the fo
Updated: 04-JAN-03
Redo Log History ( Oracle : 9i 10g )
SQL Script : Simple listing of redo log switching over time. A useful tip is to change the fo
Updated: 31-DEC-02
Redo Log History ( Oracle : 7 )
SQL Script : Simple listing of redo log switching over time. A useful tip is to change the fo
Updated: 08-JAN-02
Session Idle Time ( Oracle : 8i 9i 10g )
SQL Script : Two different ways to monitor idle sessions. This script displays the top 5 long
Updated: 24-NOV-04

Site Map