flush shared_pool and query performance

From: <genegurevich_at_discover.com>
Date: Thu, 3 Apr 2008 16:40:05 -0500
Message-ID: <OF0C3378A2.8BE78709-ON86257420.007662FD-86257420.007706B0@discover.com>

Hi all:

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?

thank you

Gene Gurevich

Received on Thu Apr 03 2008 - 16:40:05 CDT

Original text of this message