Monthly Archives: December 2013

Expensive full table scans on AQ$_SYS$SERVICE_METRICS_TAB_L

A while ago a collegue DBA asked me to help him with a database he had problems with. The database was generating a lot of archives and since there also was a standby database, these archives had to be transported … Continue reading

Posted in Oracle performance tuning | Tagged , , , , , , , , | Leave a comment

Advanced mining the log writer trace

I’ve been working on shell code to mine the log writer trace. I wrote about that two weeks ago. Now I have a more advanced piece of shell code that mines all log writer traces of all instances. It makes … Continue reading

Posted in Oracle performance tuning, Oracle scripts | Leave a comment