Script Library
Generl Database
- Checks the Status of the Oracle Database
- Tidy the Oracle Logs for 10g and 9i
- ADR Maintenance and Log Tidy Script
- Show ASM Disk Usage
- Creating Testing Tables
- Script to Monitor Oracle Processes
- Script to Get User Permissions
Grid Control
Backup & Recovery
- RMAN: Full Incremental Level 0 Backup to Tape Including Archive Logs
- EXPORT: Compressed Export Script
- IMPORT: Compressed Import Script
- New Datapump Export Script
Flashback
Clusterware
Performance & Tuning
- Tracing SQL Statements for 10g
- A Script to Generate CPU Load on a Unix Machine
- A Script to Monitor Plan Changes
- A Logon Trigger to Trace a User Session