What the heck is the SQL Execution ID – SQL_EXEC_ID?
ORA-4031 errors, contention, cursor management issues and shared pool fragmentation – free secret seminar!
Oracle Exadata Performance series – Part 1: Should I use Hugepages on Linux Database Nodes?
A little new feature for shared pool geeks :-)
The full power of Oracle’s diagnostic events, part 2: ORADEBUG DOC and 11g improvements
cursor: pin S waits, sporadic CPU spikes and systematic troubleshooting
Oracle 11gR2 has been released – and with column oriented storage option
How to detect when a cursor was closed from SQL trace output?
“Free” DBA_HIST AWR views in 11g…
Oracle 11g: Reading alert log via SQL
Oracle, Timesten and PL/SQL support
Multipart cursor subexecution and PRECOMPUTE_SUBQUERY hint
Little oradebug enhancement in Oracle 11g
VLDB 2008 proceedings, Oracle optimizer plan stability, adaptive cursor sharing and SecureFiles
Library cache latches gone in Oracle 11g
Another use case for WaitProf – diagnosing “events in waitclass Other”
cursor_space_for_time To Be Deprecated
Performance and Scalalability Improvements in Oracle 10g and 11g
Excellent article on Oracle 11g PL/SQL function result cache
Oracle 11g internals part 1: Automatic Memory Management