Oracle Scratchpad

July 10, 2009

Statspack Skills

Filed under: Performance, Statspack, Troubleshooting — Jonathan Lewis @ 7:28 pm UTC Jul 10,2009

I had a great time a couple of weeks ago at the  UKOUG meeting of the DBMS SIG (reported here by Coskan Gundogar). The range of presentations was good and I had a number of interesting conversations.

Of course, the exciting part for me was sitting down with a batch of Statspack and AWR reports that I had been supplied with in the previous couple of days and doing a “real-time” analysis of them.

(more…)

Must Read

Filed under: Uncategorized — Jonathan Lewis @ 7:10 pm UTC Jul 10,2009

Just a quick note to point out that Greg Rahn has just published some useful information on parallel execution (including an important addition to monitoring in 11.1)  [Edit 12/7/09: originally typed in error as 11.2]

Blog at WordPress.com.