Re: Zeroising v$ views

"Andy Kent" <andykent.bristol.DontSpamMe_at_virgin.net> wrote in message news:56gn6.2370$Xe3.352917_at_news2-win.server.ntlworld.com...
> 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-

Then use utlbstat and utlestat. That's exactly what they are for. Bstat takes a snapshot of the v$ statistics at time A, and Estat takes a snapshot at time B, and then computes the difference between A and B -and outputs a rather nifty report called (unimaginitively enough) report.txt.

Both scripts are stored in the usual directory for these sorts of things -ie, ORACLE_HOME/rdbms/admin

Regards
HJR
>
>
> "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 Thu Mar 01 2001 - 07:14:03 CST