Re: Is this a candidate for a stored outline?

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 02 May 2003 16:34:08 -0700
Message-ID: <QfDsa.618$MJ5.209@fed1read03>

Ryan wrote:
> We do bulk processing every night. I noticed that if I run SQL statement,
> then flush the shared pool, then run it again it still runs alot faster the
> second time. Since the blocks have been flushed from memory this leads me to
> believe that its the reuse of the outline leading to the performance
> increase.

SHARED POOL <> DB_BLOCK_BUFFERS
SHARED POOL is for SQL & PL/SQL code
DB_BLOCK_BUFFERS is for data blocks.

The 2nd run is faster than the 1st because the data is already in memory!

Enable SQL TRACE to get facts rather than draw conclusions based upon idle speculation. Received on Fri May 02 2003 - 18:34:08 CDT