RE: save undo block & save undo header

Hello Khalid,

No, you should not consider them, and you are most unlikely to see non-zero values anyway. These statistics relate to 'deferred rollback segments', not conventional rollback segments. There is an explanation of deferred rollback segments on my web site (use the search box).

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/


-----Original Message-----
From:	Benhayoune khalid [SMTP:benhayoune_at_maroclear.co.ma]
Sent:	Monday, May 15, 2000 10:37 PM
To:	Multiple recipients of list ORACLE-L
Subject:	save undo block & save undo header

	Excuse my poor English ! 

> Could anybody explain me the meaning of the statistics 'save undo
> block' and 'save undo header' in the v_$waitstat view ?
>

        Should i consider those stats while tuning the contention for rollback segments ?

> Thanks.
>
> Khalid.
>
> ------------------------------------------------------------------
> K.Benhayoune
> System engineer/DBA
> MAROCLEAR
> Phone : 212-2-48-49-49
> Fax : 212-2-48-67-03
> Address : 216, BD ZERKTOUNI, 5 eme etage
> Casablanca (Morocco)
Received on Thu May 18 2000 - 23:12:01 CDT