Blog Archives

http://coskan.wordpress.com/2007/09/14/what-i-learned-about-shared-pool-management/   What I learned about shared pool management Filed under: Performance — coskan @ 11:00 pm   22   1     Rate This   Update on 07/06/11: Please also watch this video tutorial from Tanel Poder after you read this article Nowadays, I am … Continue reading

Aside | Posted on by | Leave a comment

http://blog.psftdba.com/2007/10/using-vsessionlongops-to-find-long.html Using v$session_longops to find long running SQL statements   v$session_longops is a dynamic performance view in which Oracle reports on the status of operations that run for more than 6 (elapsed) seconds. Various operations, including queries are automatically reported … Continue reading

Aside | Posted on by | Leave a comment