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:[EMAIL PROTECTED]] > 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" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >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: [EMAIL PROTECTED] > > > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
