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

DB Resource Manager

Scripts sorted by Title

Create Database Resource Manager Plan ( Oracle : 8i 10g )
SQL Script : This script creates a simple resource manager plan.
Updated: 30-JUN-02
Database Resource Manager Configuration ( Oracle : 8i 9i 10g )
SQL Script : This script lists the configuration of the Database Resource Manager
Updated: 03-APR-02
Drop Database Resource Manager ( Oracle : 8i 9i )
SQL Script : Drops resource manager plan and any associated subplans
Updated: 19-JUL-04
Drop Database Resource Manager Plan ( Oracle : 10g )
SQL Script : This script drops a resource manager plan and any associated subplans.
Updated: 30-AUG-02
Grant Resource Manager Privileges ( Oracle : 8i 9i 10g )
SQL Script : This script assigns a resource manager plan to users
Updated: 30-JUL-02
Monitor Database Resource Manager ( Oracle : 9i 10g )
SQL Script : This script lists the CPU consumed and the Consumer Group a session is using whe
Updated: 26-SEP-02
Monitor Database Resource Manager ( Oracle : 8i )
SQL Script : This script lists the CPU consumed and the Consumer Group a session is using whe
Updated: 03-APR-02

Site Map