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
-
« Home
-
Categories
Post a Comment