Re: AWR Report - "Segments by Row Lock Waits" -> Column "% of Capture"
Date: Mon, 11 Aug 2008 13:51:54 -0500
Message-ID: <48A08A4A.1060607@gmail.com>
% of capture will add up to near 100% for all rows in that section..For
e.g., if there is another object with 1 row lock wait, then it will be:
Anyway 1 row lock wait is too small to worry about..
Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits *% of Capture* TBAADM IDX_LOG_HISTORY IDX_INTERFACE_REQUEST_DTL_TBL INDEX 1 *50.00* TBAADM IDX_LOG_HISTORY SOME_INTERFACE_REQUEST_DTL_TBL INDEX 1 *50.00
Cheers
Riyaj
The Pythian group - www.pythian.com
Personal : http://orainternals.wordpress.com
*VIVEK_SHARMA wrote:
>
> Folks
>
>
>
> In AWR, in the section “Segments by Row Lock Waits” , What does the
> column “% of Capture” mean? ..
>
>
>
> From an AWR Report taken from a Benchmark Run, there exists Only 1
> entry specifying the index IDX_INTERFACE_REQUEST_DTL_TBL with “% of
> Capture” = 100%
>
>
>
> Qs. What does this mean? Is the following index HOT / Lock waits?
>
>
>
> Any advice / links will help.
>
>
>
> Cheers & Thanks V much
>
>
>
> Vivek
>
>
>
> P.S.
>
>
>
>
> *Segments by Row Lock Waits*
>
> * *% of Capture shows % of row lock waits for each top segment
> compared *
> * *with total row lock waits for all segments captured by the
> Snapshot *
>
> Owner Tablespace Name Object Name
> Subobject Name Obj. Type Row Lock Waits *% of Capture*
>
> TBAADM IDX_LOG_HISTORY
> IDX_INTERFACE_REQUEST_DTL_TBL INDEX
> 1 *100.00 *
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
> for the use of the addressee(s). If you are not the intended recipient, please
> notify the sender by e-mail and delete the original message. Further, you are not
> to copy, disclose, or distribute this e-mail or its contents to any other person and
> any such actions are unlawful. This e-mail may contain viruses. Infosys has taken
> every reasonable precaution to minimize this risk, but is not liable for any damage
> you may sustain as a result of any virus in this e-mail. You should carry out your
> own virus checks before opening the e-mail or attachment. Infosys reserves the
> right to monitor and review the content of all messages sent to or from this e-mail
> address. Messages sent to or from this e-mail address may be stored on the
> Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 11 2008 - 13:51:54 CDT