Re: AWR Report - "Segments by Row Lock Waits" -> Column "% of Capture"

% 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-l