timed stats

From: Uppal, Inde <Inde.Uppal_at_chelwest.org>
Date: Wed, 17 May 2000 08:58:41 +0100
Message-Id: <10500.105815@fatcity.com>

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_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.

------_=_NextPart_001_01BFBFD6.02D2C61C
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>timed stats</TITLE>
</HEAD>
<BODY>

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.

<P><FONT SIZE=3D2>Thanks</FONT>
<BR><FONT SIZE=3D2>Inde</FONT>
</P>

-----Original Message----- From: Jared Still [<A = HREF=3D"mailto:jkstill_at_bcbso.com">mailto:jkstill_at_bcbso.com</A>]

<BR><FONT SIZE=3D2>Sent: Tuesday, May 16, 2000 4:57 PM</FONT>
<BR><FONT SIZE=3D2>To: Steve Orr</FONT>
<BR><FONT SIZE=3D2>Cc: Oracle-L Jared's List; =

oracledba_at_lazydba.com
 Subject: Re: Anyone using statspack? (new for 8.1.6+ = only)

</P>
<BR>
<BR>

Steve,

Check out <A =
HREF=3D"http://www.oracle.com/oramag/oracle/00-Mar/o20tun.html" = TARGET=3D"_blank">http://www.oracle.com/oramag/oracle/00-Mar/o20tun.html= </A>
 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.

<P><FONT SIZE=3D2>Jared</FONT>
</P>
<BR>
<BR>

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

<BR><FONT SIZE=3D2>&gt; timed_statistics =3D TRUE all the time.</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; 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.

<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Steve Orr</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; --------</FONT>
<BR><FONT SIZE=3D2>&gt; If you're bored, then visit the list's website: =
<A HREF=3D"http://www.lazydba.com" =

TARGET=3D"_blank">http://www.lazydba.com</A> (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

<BR><FONT SIZE=3D2>&gt; </FONT>
</P>
<BR>

Jared Still
 Certified Oracle DBA and Part Time Perl = Evangelist  ;-)

<BR><FONT SIZE=3D2>Regence BlueCross BlueShield of Oregon</FONT>
<BR><FONT SIZE=3D2>jkstill_at_bcbso.com - Work - preferred address</FONT>
<BR><FONT SIZE=3D2>jkstill_at_teleport.com - private</FONT>
</P>
<BR>
<BR>

--------
 If you're bored, then visit the list's website: <A = HREF=3D"http://www.lazydba.com" =
TARGET=3D"_blank">http://www.lazydba.com</A> (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 = Received on Wed May 17 2000 - 02:58:41 CDT