Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Meaning of V$WAITSTAT statistics
Thank you very much !!!
I don't know why some people have made a joke with this question...
When we are tuning a database we must try to understand the statistics, and
I didn't found this in the documentation...
And when I explain to my pupils the wait statistics, they want to know the
meaning of all them ...
I'm sorry if I have disturbe the attention of someone...
>From: Christopher Spence <cspence_at_FuelSpot.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Meaning of V$WAITSTAT statistics
>Date: Tue, 02 Oct 2001 08:50:23 -0800
>
>Save undo is when a tablespace has undo information, but is currently
>offline.
>
>"Do not criticize someone until you walked a mile in their shoes, that way
>when you criticize them, you are a mile a way and have their shoes."
>
>Christopher R. Spence
>Oracle DBA
>Phone: (978) 322-5744
>Fax: (707) 885-2275
>
>Fuelspot
>73 Princeton Street
>North, Chelmsford 01863
>
>
>
>-----Original Message-----
>Sent: Monday, October 01, 2001 4:30 PM
>To: Multiple recipients of list ORACLE-L
>
>Hello !
> I need to know what is the meaning of the "save undo block" and "save
>undo header" statistics in the V$WAITSTAT view.
>
>TIA.
> Alejandra.
>
>
>
>
>_________________________________________________________________
>Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Alejandra Pazos Freire
> INET: alepazosfreire2_at_hotmail.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
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Christopher Spence
> INET: cspence_at_FuelSpot.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
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: alepazosfreire2_at_hotmail.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 (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Oct 02 2001 - 16:26:39 CDT