flush shared_pool and query performance
Date: Thu, 3 Apr 2008 16:40:05 -0500
I am noticing that the same SQL executed before and after 'alter system
flush shared_pool' completes in VASTLY
different time - 0.01s before the command and 0.3s after the command. I wonder why is that. When I flush the
shared_pool, the library cache is flushed and so my SQL needs to be reparsed. Is that reasonable for parsing to take 0.3s?
Gene GurevichReceived on Thu Apr 03 2008 - 16:40:05 CDT