Utility Scripts Overview
Oracle Utility Scripts
Section titled “Oracle Utility Scripts”This collection contains 35+ production-tested Oracle database utility scripts organized by category for easy navigation and reference.
Script Categories
Section titled “Script Categories”📊 Database Information
Section titled “📊 Database Information”Basic database and instance information scripts for quick health checks and system overview.
🔧 Administration
Section titled “🔧 Administration”DBA maintenance and management scripts including invalid objects, scheduled jobs, and storage management.
🗂️ Schema Analysis
Section titled “🗂️ Schema Analysis”Table, index, and database object analysis scripts for schema documentation and optimization.
⚡ Performance Analysis
Section titled “⚡ Performance Analysis”Performance monitoring, tuning, and troubleshooting scripts including locks, latches, and resource usage.
🔒 Security Analysis
Section titled “🔒 Security Analysis”User account, role, and privilege analysis scripts for security auditing and compliance.
💾 ASM Analysis
Section titled “💾 ASM Analysis”Automatic Storage Management scripts for ASM disk and configuration analysis.
Usage Guidelines
Section titled “Usage Guidelines”Before Running Any Script
Section titled “Before Running Any Script”- Review the script code - Understand what it does
- Check prerequisites - Ensure you have required privileges
- Test in development - Never run untested scripts in production
- Backup if needed - Some scripts may affect system state
Common Script Patterns
Section titled “Common Script Patterns”Most scripts follow these patterns:
- Prompt for parameters using
&variablesyntax - Use formatting commands for clean output
- Include column formatting for readability
- Filter results based on user input
Quick Reference
Section titled “Quick Reference”Find specific functionality:
- Locks and blocking → Performance Analysis section
- Invalid objects → Administration section
- Table analysis → Schema Analysis section
- User permissions → Security Analysis section
- ASM storage → ASM Analysis section
Most commonly used scripts:
db.sql- Quick database overviewgvinst.sql- Instance status (RAC)gvlock.sql- Lock analysisdinvalid.sql- Find invalid objectsdtable.sql- Table storage parameters
Start exploring with the scripts that match your immediate needs!