New feature 11g: DBMS_SQLDIAG to dump 10053 trace

Almost everyday I learn a new 11g feature. Today I found this way to dump a 10053 trace for a existing cursor.
I wanted to get a 10053 trace on a query already in library cache. I did not want to flush shared pool. I was thinking about gathering statistics with NO_INVALIDATE=false. But this was a big partitioned table, and did not really want to do this.
Instead I found this article

Post a Comment

Your email is never published nor shared. Required fields are marked *