Sqlscripts
From Oramosswiki
A series of scripts that I commonly use - feel free to use them as you see fit.
They are, of course, subject to the limitations that they are supplied "as is" without any warranty, expressed or otherwise. Essentially you use them at your own risk and it would be sensible that you check that they function in a manner you require, on a non production system, before you use them in anger.
Performance
- File IO in last 24 hours - from AWR
- Get the Volume IO stats for the last 24 hours from AWR
- Get the Database IO stats for the last 24 hours from AWR
- Get the Volume IO stats by day since AWR has been recording them
- Get the Database IO stats by day since AWR has been recording them
- Get the ordering of columns for a table, which results in the maximum compression
- Gets the progress of a long running query
- Get session waits from SID (including PX slaves)
- Get memory areas combined with execution plan steps from a SID
- Get Cost Based Optimizer statistics for a given object
- Get the number of blocks per physical read from TEMP
- Get the number of blocks per physical read from normal Datafliles
