Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> save undo block & save undo header

save undo block & save undo header

From: Benhayoune khalid <benhayoune_at_maroclear.co.ma>
Date: Mon, 15 May 2000 10:45:22 -0000
Message-Id: <10498.105632@fatcity.com>


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 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)
> 

<!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 &amp; 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>
<BR><B><FONT COLOR=3D"#008000" SIZE=3D4 FACE=3D"Comic Sans =
MS">K.Benhayoune</FONT></B>
<BR><I><FONT COLOR=3D"#008000" SIZE=3D2 FACE=3D"Comic Sans MS">System =
engineer/DBA</FONT></I>
<BR><I><FONT COLOR=3D"#008000" SIZE=3D2 FACE=3D"Comic Sans =
MS">MAROCLEAR</FONT></I>
<BR><I><FONT COLOR=3D"#008000" SIZE=3D2 FACE=3D"Comic Sans MS">Phone : =
212-2-48-49-49</FONT></I>
<BR><I><FONT COLOR=3D"#008000" SIZE=3D2 FACE=3D"Comic Sans MS">Fax : =
212-2-48-67-03</FONT></I>
<BR><I><FONT COLOR=3D"#008000" SIZE=3D2 FACE=3D"Comic Sans MS">Address =
: 216, BD ZERKTOUNI, 5 eme etage</FONT></I>
<BR><I><FONT COLOR=3D"#008000" SIZE=3D2 FACE=3D"Comic Sans =
MS">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n= bsp;&nbsp; Casablanca (Morocco)</FONT></I> Received on Mon May 15 2000 - 05:45:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US