Re: Zeroising v$ views

I want to see the effects of improvements we are making to indexing etc in v$sqlarea but without having to mess around comparing to old figures; however, it's a 24x7 system ...

-Andy-

"Yong Huang" <yhuang_at_indigopool.com> wrote in message news:97k1rq$t51$1_at_news.sinet.slb.com...
> There's no way to reset whatever is in v$ views except by bouncing the
> server. Why do you want to do this?
>
> Change to indexes and analysis of the tables involved in a SQL statement
> invalidate the SQL statement and so it needs a soft parse. The cursor body
> is recreated but the cursor head is the same. Check pp276-280 of James
> Morle's Scaling Oracle 8i.
>
> You don't need to do anything. Oracle parses SQL by itself.
>
> Yong Huang
> yhuang_at_indigopool.com
>
> Andy Kent <andykent.bristol.DontSpamMe_at_virgin.net> wrote in message
> news:aJbn6.740$Xe3.114341_at_news2-win.server.ntlworld.com...
> >
> > How do I zeroise the counters in the dynamic performance views without
> > stopping the database?
> >
> > Also, do queries automatically get re-parsed following major addition of
> > indexes and ANALYZE, or is there some way I have to force them?
> >
> > Thanks,
> >
> > --
> > -Andy Kent-
> > Bristol, England
> >
> > Remove '.DontSpamMe' from return address to respond.
> >
> >
> >
>
>
Received on Wed Feb 28 2001 - 17:47:59 CST