Using Google Chrome?

Download my
free Chrome Extension, Power Notes Searcher, to make searching for and evaluating SAP notes, much easier.

Recent Posts

Monday, September 26, 2011

Flushing Cursor SQL Plan Out of Library Cache

Print Friendly and PDF
I can never remember how to do this.

I wanted to flush a specific SQL execution plan out of the Oracle 11g SQL Library Cache so that I could try and compare a before and after SQL execution scenario using SQL trace and then tkprof'ing it.
Here's the link to the blog that helped me remember again:

http://prutser.wordpress.com/2009/04/19/flushing-a-cursor-out-of-the-library-cache/

Thanks.

No comments: