Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> save undo block & save undo header
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
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 forrollback 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) >
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.0.1459.75">
<TITLE>save undo block & save undo header</TITLE>
</HEAD>
<BODY>
<UL>
<P><FONT SIZE=3D2 FACE=3D"Courier New">Excuse my poor English ! </FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">Could anybody explain me the =
meaning of the statistics 'save undo block' and 'save undo header' in =
the v_$waitstat view ?</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">Should i consider those stats =
while tuning the contention for rollback segments ?</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">Thanks.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">Khalid.</FONT>
</P>
<P><I><FONT COLOR=3D"#008000" SIZE=3D2 FACE=3D"Comic Sans =
MS">------------------------------------------------------------------</=FONT></I>
![]() |
![]() |