Re: Zeroising v$ views

From: Yong Huang <yhuang_at_indigopool.com>
Date: Wed, 28 Feb 2001 17:30:19 -0600
Message-ID: <97k1rq$t51$1@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:30:19 CST