RE: Meaning of V$WAITSTAT statistics

Save undo headers are made for the Billy Graham's database only. Just kidding.
The "save undo headers" refer to the deferred rollback segment, which are created if a tablespace goes offline with uncommitted transactions. Those deferred rollback segments are created in the tablespace "SYSTEM" and there is
no way of changing that (allegedly, some magic happens if the default tablespace
is changed for the user 'SYS', but I've never tested that. It might be a rumor).
>From the performance perspective, you can safely ignore the "save undo"
statistics.

> -----Original Message-----
> From: Alejandra Pazos Freire [mailto:alepazosfreire2_at_hotmail.com]
> Sent: Monday, October 01, 2001 11:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Meaning of V$WAITSTAT statistics
>
>
> ok, I know the meaning of the "undo block" and "undo header"
> statistics, but
> I don't know how to understand the "save undo block" and
> "save undo header"
> statistics.
>
>
>
> >From: "Mohan, Ross" <MohanR_at_STARS-SMI.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Meaning of V$WAITSTAT statistics
> >Date: Mon, 01 Oct 2001 13:05:51 -0800
> >
> >rollback=undo
> >
> >-----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.
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Mohan, Ross
> > INET: MohanR_at_STARS-SMI.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).
>
>
> _________________________________________________________________
> 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: Gogala, Mladen
  INET: MGogala_at_oxhp.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).