Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: timed stats

RE: timed stats

From: <martyn.r.baker_at_uk.pwcglobal.com>
Date: Thu, 18 May 2000 11:09:23 +0100
Message-Id: <10501.105953@fatcity.com>


--0__=0J1SD5FS9BQcGelS7TSGXuHWB7zP0wQrVbjeUaLEXmTy0nniBTgJWZsf Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Mark,
Timed_statistics was always poo-poo'd by Oracle during the early versions of Oracle 7. They stated in their documentation that it should only be used for short periods as it had an overhead of around 10%. As time has gone on, those adminstrators who have used it realised that Oracle were just covering themselves.
I first heard of this about 3 years ago when a chap from Oracle interviewed me and during the interview passed the comment that the overhead was negligable. Most places I have worked since have had the stats switched on. Regards,
Martyn

                                                                  
 (Embedded                                                        
 image moved   Mark Marsden <mark.marsden_at_hyde-housing.co.uk>     
 to file:      18/05/2000 10:29                                   
 pic21241.pcx)                                                    
                                                                  



To: 'Jared Still' <jkstill_at_bcbso.com>, "Uppal, Inde" <Inde.Uppal_at_chelwest.org> cc: Oracle-L Jared's List <ORACLE-L_at_fatcity.com>, oracledba_at_lazydba.com Subject: RE: timed stats

I don't know if the rumour about TIMED_STATISTICS comes from confusion with TIMED_OS_STATISTICS
concerning which the Oracle 8 Reference manual says:

TIMED_OS_STATISTICS can be used by the system administrator to gather operating system statistics when a request is made from the client to the server or a request completes. For dedicated servers, OS statistics are gathered at the time of user logon and thereafter when calls are popped, provided the specified time limit has expired. The statistics are also gathered at the user logoff time.
Gathering OS statistics is expensive and should be done on an as-needed basis. further, as this is a dynamic parameter, this should be set to zero immediately after the need for gathering OS statistics has been satisfied.

Mark.
> -----Original Message-----
> From: Jared Still [SMTP:jkstill_at_bcbso.com]
> Sent: Wednesday, May 17, 2000 3:27 PM
> To: Uppal, Inde
> Cc: Oracle-L Jared's List; oracledba_at_lazydba.com
> 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
>
>



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

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

--0__=0J1SD5FS9BQcGelS7TSGXuHWB7zP0wQrVbjeUaLEXmTy0nniBTgJWZsf Content-type: application/octet-stream;

        name="pic21241.pcx"
Content-Disposition: attachment; filename="pic21241.pcx" Content-transfer-encoding: base64

CgUBCAAAAABoACwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAABaQABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAD1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPH
E8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sT zRPHE8MTwhPwEwzIBgzYE8wTxhPDE8IT7hPOBtcTzBPGE8MTE+wTwgbCBwbCEgbCEgbCEsUG1hPL E8YTwxMT6hMMwgYHwgLCAwISwgfEEsMCwwbVE8sTxRPDExPpE8MGAwcCBwMCwhLDB8ISwgISwgLD BtUTyhPFE8MTE+gTwgIHA8ICEw4DDgLDE8USwwLCEMIG1BPKE8UTwxMT5xMCAwcDAg4TDgITwgIS D8ISD8ISBRICEcICwwbUE8oTxRPCExPmEwYCBwMCDgIOwgLDExITEhPCEg8GxgLDBtMMDAfJE8QT whMT5hMGwwITBgMCDhLFEw8SE8ISBgIDwhIDEsMGB9MDxwwHxRPDExPlEwYHAhESAg8CwhMPwhMP xBMPxRIQwgIDAgMCBtMDxwPEDAfDE8IT4RMHwwzCBgLCEhMCDxLIE8MSD8MSwwIQAwIDBgfSDMkD wgPCDAfCExPbEwfGDMIDDAIHERITEhMSwxMPwxMPwxPDEgIDAgMCwwMCBgzREwfHDMYDDMITE9YT B8UMyAMGB8ICBhLDAsYTEhMSExIPwhIHAgcCAwUQAgYRBgfSE8UTB8QMwgMMwhMT0hMHxAzLA8IM BsISDxESExITAw4DxBMSExITwxICBwPCAsMDDMIGB9ITyRMHwwzCExPPEwfDDMkDxQwHwhMGBxIT AhECEwMOAg7DExITDxMPwxIDAgMCBwMCDAYRBgfSE8kTwhPCDMITE8wTB8MMxwPEDMIHxxMGxBLD Ag4DDgIGwg/IEgIDwgIDAgwCEMIGB9ITyRMHDAcMwhMTyhMHwgzGA8MMwgfMEwYHwhLCEAIOAg4C DhDDAhIPxhIFAgXDAgUCEQYH0hPHEwfCDAcPDMITE8gTB8IMxQPDDAfQEwbDEhDEAhAOEA4QwgLG EgcSBhIGBcMCBcIGB9ATB8UMEwfCDA8HDwwHwhMTxhMHwgzEA8MMB9MTBgfCEhADEMICDhAOEMIC EQIDxxIGBwbCAgUCEQYHyxMHxAwHwhMHEwzCEwcPBw8MB8MTE8UTBwzEA8IMB9YTBsQSEAMCA8UC EQIDAgPDEgcSBgfCBgUQAhDCBgfGEwfEDAfGE8INEwzCEw8HwgwHwxPCE8QTBwzDA8IMB9gTBgfE EhACEMYCEQIDAsQSBhLDBsICEALCBgfCEwfDDAfKEwfCDRMHwhPCDAfEE8ITE8MTBwzCA8IMB9oT DBIHwxLDDBEDxQIDAgPDEgYSBgfCBgIQAhAGDAfCEwzDE8MHyRMHwhPCBxMHxRPDExPDEwzCAwwH 3RMGxxICEQPDAgMCA8MSBhIGBwYMBhACEAIGDMMTDBPCB8YTwwfHEwfGE8MTwhPDEwwDDAfeEwYH xxICEQPDAgMCwhIGEgYHBgwGEAIQAsIGB8MTDMYTwwfKEwzGE8MTwhPDE8IMB98TDBLCB8USAgMR xAISB8ISBgcGDAYQBhAGEAYMB8MMB8kTwwfHEwzGE8MTwhPDEwwPwgzfEwYSB8ISB8ISAhECAwID EgcSBwYHBgwGEAYQxgzDD8IHxRPDB8kTBwzGE8MTwhPDEwzDD8QM3BPCBhIGwxIGAhECAwIHBgcG yAzJDxMHzRMHwwwHxxPDE8ITwxMHDMYPxwwH1BMGEgYSBhLLDM4PwwwTDMcTwgfEDAfJE8QTwhMT xBMHwgzLD9sM0w/GDAfDEwzDEwfEDAfLE8YTwxMTxhMHxAztD8gMBgfIE8QMB84TxxPDE8ITyhMH xwzbD8sMEAUMBcIMwgYH1RPKE8UTwxMT0RMH2wwGEAYQBhACBQwFDAUMBgwHBgfWE8sTxRPDExPu EwYMBhAGEAIGDAYMwwYH1xPLE8YTwxMT8BPKBgfYE8wTxhPDExP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhMMAAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD/
/wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8A
AAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A
//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAA
AP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA
/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCk
gICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vw
oKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw
//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzA
psrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDA
wNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICA wMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACA Received on Thu May 18 2000 - 05:09:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US