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

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:


Add Your Comment

* Indicates Required Field

Your email address will not be published.