I just reviewed Tom Kyte’s presentation from the 09′ IOUG Collaborate event and made a list of things that are specifically interesting to an Oracle DBA with the links for further research into each feature.

I. Those managing PHP/Oracle shops will be happy to learn that there’s a new Database Resident Connection Pool [DRCP] that performs as well as dedicated server (it really is) with benefits of shared server model.

II. Are you sill using TOAD? Perhaps it’s time to give Oracle Sql Developer a shoot because it’s offering a host of Sql/PLSQL Tuning Features built right in:

• Real Time Sql Monitoring
• AWR & ASH Reports
• Hierarchical Profiler

Vitaliy Mogilevskiy June 10, 2009

Posted In: Tuning

Tags: ASH, AWR, DRCP, Hierarchical Profiler, Oracle Sql Developer, Real Time Sql Monitoring, Tom Kyte