Message-Id: <10500.105815@fatcity.com> From: "Uppal, Inde" Date: Wed, 17 May 2000 08:58:41 +0100 Subject: timed stats This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFBFD6.02D2C61C Content-Type: text/plain; charset="iso-8859-1" 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@bcbso.com] Sent: Tuesday, May 16, 2000 4:57 PM To: Steve Orr Cc: Oracle-L Jared's List; oracledba@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@quickdoc.co.uk > to subscribe send a blank email to oracledba-subscribe@quickdoc.co.uk > Jared Still Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon jkstill@bcbso.com - Work - preferred address jkstill@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@quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe@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. ------_=_NextPart_001_01BFBFD6.02D2C61C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable timed stats

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@bcbso.com]
Sent: Tuesday, May 16, 2000 4:57 PM
To: Steve Orr
Cc: Oracle-L Jared's List; = oracledba@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=3Dtrue, 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 =3D 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@quickdoc.co.uk
> to subscribe send a blank email to = oracledba-subscribe@quickdoc.co.uk
>


Jared Still
Certified Oracle DBA and Part Time Perl = Evangelist  ;-)
Regence BlueCross BlueShield of Oregon
jkstill@bcbso.com - Work - preferred address
jkstill@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@quickdoc.co.uk
to subscribe send a blank email to = oracledba-subscribe@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 =