Re: statistic flush

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 13 May 2002 23:26:35 GMT
Message-ID: <3CE04BAA.CDE6E784@exesolutions.com>

Sybrand Bakker wrote:

> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3CE03224.3C0D41A2_at_exesolutions.com...
> > K Gopalakrishnan wrote:
> >
> > > 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
> > > >
> > > >
> >
> > Which undocumented package?
> >
> > And for those that may know the answer ... is the use of undocumented
> packages
> > the equivalent of using undocumented parameters in the init.ora? Does that
> have
> > license and support implications?
> >
> > Thanks.
> >
> > Daniel Morgan
> >

>

> Probably it does.
> But maybe lawyers from India are very good at getting rid of claims.

>

> Regards

>

> --
> Sybrand Bakker
> Senior Oracle DBA

>
> to reply remove '-verwijderdit' from my e-mail address

And maybe developers in India just don't care.

Perhaps we will find out. ;-)

Daniel Morgan Received on Mon May 13 2002 - 18:26:35 CDT