Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is this a candidate for a stored outline?

Re: Is this a candidate for a stored outline?

From: Ryan <rgaffuri_at_cox.net>
Date: Sat, 03 May 2003 00:33:19 GMT
Message-ID: <j7Esa.11337$g41.615572@news1.east.cox.net>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US