This blog contains experience gained over the years of implementing (and de-implementing) large scale IT applications/software.

Flushing Cursor SQL Plan Out of Library Cache

Darryl Griffiths
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:

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


Thanks.

Add Your Comment

* Indicates Required Field

Your email address will not be published.

*