Database Utilities & Tuning
Unix Utilities & Tools
Useful Papers & Documents
My Oracle Toolbox
Identify tables with no data. These can then be truncated to reset HWM and reclaim space
Clone it! Copy all objects and data between schemas and across Databases
Start an executable in the background
Run an SQL script with just one command!
Tom Kyte's SQL*Unloader Source. Awesome!
Determine Foreground response times for a Database
Exhaustively list Database Performance Indicators at one stroke
Quick-and-Dirty look at Database Performance Indicators
DBWR waits for a log file sync operation
Check sizing of Log Buffer in SGA
Determine if the Database is switching Redo Logs excessively.
All source listed here is provided under the GNU Public License Version 2 unless expressly stated otherwise
Unix script to list all locks in the Database
Unix utility to get all details about a currently active Database connection
Monitor this page for changes
it's private
by
ChangeDetection
Generate a detailed report on all schema objects. Requires
this
additional script
Automagically generate an SQL*Loader CTL file for any table
Get rid of that pesky columnar output in SQL*Plus select results!