| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: timed stats
1 or 2% tops - we keep all our instances company-wide with
timed_statistics=true and don't have any performance issues.
Jim
314.694.7592 - Office 314.308.6614 - Cellular 314.294.2623 - Pager james.w.hawkins_at_monsanto.com
"Far better it is to dare mighty things, to win glorious triumphs, even though checkered by failure, than to take rank with those poor spirits who neither enjoy much nor suffer much, because they live in the gray twilight that knows neither victory nor defeat."
--Theodore Roosevelt
-----Original Message-----
From: Jared Still [mailto:jkstill_at_bcbso.com]
Sent: Wednesday, May 17, 2000 10: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-LReceived on Wed May 17 2000 - 15:25:26 CDT
 |
 |