Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: statistic flush

Re: statistic flush

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 13 May 2002 21:37:57 GMT
Message-ID: <3CE03224.3C0D41A2@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 Received on Mon May 13 2002 - 16:37:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US