I suppose if you turned timed_statistics on then spent the next hour
blasting the database with scripts to see if timed_statistics is causing a
10% degradation, you would ultimately find that you have a 10% degradation.
............................................................................
.................................
Rich Gesler - <>< Saved By Grace
Database Administrator office: 336 878-7268
LifeStyle Furnishings International fax : 336 878-7038
............................................................................
.................................
Forgive them all - let God sort it out.
> -----Original Message-----
> From: Jared Still [SMTP:jkstill_at_bcbso.com]
> Sent: Wednesday, May 17, 2000 11:42 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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
> jkstill_at_bcbso.com - Work - preferred address
> jkstill_at_teleport.com - private
>
>
> --
> Author: Jared Still
> INET: jkstill_at_bcbso.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Wed May 17 2000 - 15:03:37 CDT
