29 May
Modifying sprepins.sql for Custom Statspack Reports II
My last post was about modifying $ORACLE_HOME/rdbms/admin/sprepins.sql which is the script that produces the statspack report.
Another change I make in my sprepins.sql is about the section “Top 5 Timed Events”. In 9.2 this section lists the wait events and CPU time and their percentages contributing to the database time. This way we can see which wait event caused most of the waits for that