DB version: 11.2.0.4
Platform : Oracle Linux 6.4
In production environment, I am testing the performance of a custom query.
I have made few minor changes to the Original SQL by re-writing it. Before I run the revised version of this SQL , I want to flush out the blocks in the DB Buffer cache which are there from the previous execution . I do not want to issue ALTER SYSTEM FLUSH BUFFER_CACHE just for this requirement as this is a production DB.
Similarly , is there a way to flush out the parsed version (hash version) of previous SQL from Library cache as well without issuing ALTER SYSTEM FLUSH SHARED POOL ?