Re: Zeroising v$ views

There are only the max values in v$filestat and v$session_event that can be reset.

Anjo.

Yong Huang wrote:

> 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 Thu Mar 01 2001 - 06:00:49 CST