Re: flush shared_pool?

strictly performance should degrade ever so slightly on the first run of a query after thsi, because the query will have to be reparsed.

your straining at gnats

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Kevin Brand" <kevin.brandx_at_tel.gte.com> wrote in message
news:90r4v6$n87$1_at_news.gte.com...


>

> Flushing shared pool does NOT remove Pinned objects ( sequences, PL

> blocks/procedures, or triggers ).

>

> It also does not do anything to the cached data blocks that your query

> plucks out of memory rather than from disk, so your performance will not

> change.  That is, unless you are experiencing the well documented

> shared-pool-free-list fragmentation problem.

>

> -Kevin

> <letokai_at_my-deja.com> wrote in message news:90qtgn$in5$1_at_nnrp1.deja.com...

> > So when I execute this command it is supposed to low the performance of

> > a query.

> > I mean if I run the same query 5 times i will have better performance

> > because of the cache mechanism. If i execute the alter command and then

> > i run the query again, is it going to run like it was the first time or

> > not.

> > With the timing on, it seems it has no effects.

> > Moreover in the trace I can see Oracle is doing what seems to be system

> > queries after the alter command.

> > So...

> >

> > I don't really understand what's going on.

> >

> >

> > Sent via Deja.com http://www.deja.com/

> > Before you buy.

>

>