Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is this a candidate for a stored outline?
"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
news:QfDsa.618$MJ5.209_at_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.
>
hmmm... I have 2 table sthat Im joining regularly based on different where clauses. Is it ever a good idea to run a cursor to just get those two tables blocks into memory? Received on Fri May 02 2003 - 19:33:19 CDT
![]() |
![]() |