The sql statistics presented here are reduced to a percentage figure to allow long term comparisons without reference needing to be taken to changes in, for example, the number of transactions occurring or the amount of memory available to the sga.

Be aware, however, that this approach can also hide a multiplicity of sins. For example, a small percentage of shared pool reloads may still be a damagingly large number. In addition, the sql is cast to provide a rounding to decimal places. Whilst this results in tidier output it also allows zero or 100% answers.

* cache hit ratio
* sorts in memory
* shared pool
* library cache hit ratios
* recursive calls/total calls
* short/total table scans
* redo activity
* table contention
* cpu parse overhead
* latches
* rollback segment contention
Oracle Database Tuning Statistics