Re: timed stats

I have never seen a 10% overhead. Neither has anyone else that has shared their experiences with the list.

Jared

On Wed, 17 May 2000, Uppal, Inde wrote:

> Jared,
> I wonder if you could clarify this for me, the oracle tuning manual says
> that timed_stats can give up to a 10% overhead.
>
> Thanks
> Inde
>
> -----Original Message-----
> From: Jared Still [mailto:jkstill_at_bcbso.com]
> Sent: Tuesday, May 16, 2000 4:57 PM
> To: Steve Orr
> Cc: Oracle-L Jared's List; oracledba_at_lazydba.com
> Subject: Re: Anyone using statspack? (new for 8.1.6+ only)
>
>
>
> Steve,
>
> Check out http://www.oracle.com/oramag/oracle/00-Mar/o20tun.html
> if you haven't already seen it. It is an article on StatsPack.
>
> As for having timed_statistics=true, the overhead is negligible.
>
> I turn it on in all databases.
>
> Jared
>
>
>
> On Wed, 10 May 2000, Steve Orr wrote:
>
> > Anyone using the new statspack which became available as of 8.1.6? It
> looks
> > like a worthy replacement for bstat/estat. (See the files matching
> > $ORACLE_HOME/rdbms/admin/stats*.) It provides a sample DBMS_JOB to gather
> > stats every hour on the hour but to do this properly they want you to have
> > timed_statistics = TRUE all the time.
> >
> > What are the pros/cons of having timed_statistics permanently turned on? I
> > know some of the 3rd party monitoring tools want it on all the time. I'm
> > thinking about collecting "performance snapshots" on a periodic basis with
> > cron so I can toggle timed_statistics on/off.
> >
> > Any recommendations or feedback on timed_statistics?
> >
> > Anyone enthused about or have feedback on statspack?
> >
> > Statspack was covered in the March/April issue of Oracle Magazine.
> >
> >
> > Steve Orr
> >
> >
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> >
>
>
> Jared Still
> Certified Oracle DBA and Part Time Perl Evangelist ;-)
> Regence BlueCross BlueShield of Oregon
> jkstill_at_bcbso.com - Work - preferred address
> jkstill_at_teleport.com - private
>
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>
>
> This e-mail is confidential and may well also be legally privileged. If you
> have received it in error, you are on notice of its status. Please notify us
> immediately by reply e-mail and then delete this message from your system.
> Please do not copy it or use it for any purposes, or disclose its contents
> to any other person: to do so could be a breach of confidence. Any views
> expressed in this message are those of the individual sender, except where
> the sender specifically states them to be the views of the Trust.
> Thank you for your co-operation.
>
>
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon Received on Wed May 17 2000 - 09:27:13 CDT