Oracle
I work as an Oracle consultant and some information about Oracle and related technologies, I have managed to add here. I intend to add more content when I get more time. You may be interested in my Feed-of-feeds about Oracle that aggregates the blogs about Oracle.
DBA Scripts
Typical scripts I use when I moonlight as a DBA! All these scripts are bundled into a PHP package so that you can run them online and view the output in HTML form. Download OraHoo! from the Web Development / PHP section.
Most of these scripts are from an excellent tool called
OraSnap
. Be sure
to visit that site.
- General Info
- Disk I/O, Events, Waits
- Tablespace Information
- Session Statistics
- Hit/Miss Ratios
- User Information
- Rollback Segments
- Full Table Scans
- Contention/Locking
- Redo Log Buffer
- Data Dictionary Info
- Miscellaneous Reports
- Shared Pool Information
- Cursor/SQL Processing
- Database Objects
- Tables/Indexes