Re: statistic flush

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Tue, 14 May 2002 02:49:34 -0700
Message-ID: <3ce02e7c@news.mhogaming.com>

Not very true. You can reset few statistics (for example READ/WRITE times in X$KCFIO which is exposed as V$FILESTAT, and MAXWAIT in V$SESSION_WAIT) by using an undocumented package. Rest of the things can not be flushed until you bounce the server.

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA

"Krzysztof Kryczka" <kryczus_at_rpg.pl> wrote in message news:abhe22$60r$1_at_news.tpi.pl...
> OK - thanks for answer
> That was what I thought after few hours searching in metalink.
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> was wrote in message
> news:arvmdu47gre33a4rm9jtri3gcfrh8r1g57_at_4ax.com...
> > On Fri, 10 May 2002 09:52:47 +0200, "Krzysztof Kryczka"
> > <kryczus_at_rpg.pl> wrote:
> >
> > >Is it possible without bounce?
> >
> > NO
> >
> > Regards
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
>
Received on Tue May 14 2002 - 04:49:34 CDT