Re: statistic flush

MK wrote:

> No need to flush out your sarcism in these terms. He merely said that
> it is doable. Not that you go ahead and do it. Knowledge is one thing
> and legality is another. I see no harm if any one has additional
> knowledge. He does not need to worry about lawyer nor about people who
> keeps intelligence at the bottom of their foot labelling an entire
> group of people ignoring their talent.
>
> Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3CE04BAA.CDE6E784_at_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

Had to told anyone how to do it I would agree with you: He didn't. He just through out an unsupported statement. I think the follow-up questions are justified. I think the concern about Oracle support issues and license agreements doubly so.

Daniel Morgan Received on Tue May 14 2002 - 14:49:49 CDT