oracle 10g 生成awr报告过程

<P>
No data exists for this section of the report.
<P>
<A class=‘awr‘ HREF=‘#27‘>Back to Wait Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘28‘></A>
<H2 class=‘awr‘>
Undo Statistics
</H2>
<UL>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#3300‘>
Undo Segment Summary
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#3400‘>
Undo Segment Stats
</A>
</UL>
<A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘3300‘></A>
<H3 class=‘awr‘>Undo Segment Summary</H3>
<UL>
<LI class=‘awr‘> Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
<LI class=‘awr‘> STO - Snapshot Too Old count,OOS - Out of Space count
<LI class=‘awr‘> Undo segment block stats:
<LI class=‘awr‘> uS - unexpired Stolen,uR - unexpired Released,uU - unexpired reUsed
<LI class=‘awr‘> eS - expired Stolen,eR - expired Released,eU - expired reUsed
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Undo TS#</TH><TH class=‘awrbg‘>Num Undo Blocks (K)</TH><TH class=‘awrbg‘>Number of Transactions</TH><TH class=‘awrbg‘>Max Qry Len (s)</TH><TH class=‘awrbg‘>Max Tx Concurcy</TH><TH class=‘awrbg‘>Min/Max TR (mins)</TH><TH class=‘awrbg‘>STO/ OOS</TH><TH class=‘awrbg‘> uS/uR/uU/ eS/eR/eU</TH></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.75</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,008</TD> <TD ALIGN=‘right‘ class=‘awrc‘>174</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD class=‘awrc‘>180/180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#28‘>Back to Undo Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘3400‘></A>
<H3 class=‘awr‘>Undo Segment Stats</H3>
<UL>
<LI class=‘awr‘> Most recent 35 Undostat rows,ordered by Time desc
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>End Time</TH><TH class=‘awrbg‘>Num Undo Blocks</TH><TH class=‘awrbg‘>Number of Transactions</TH><TH class=‘awrbg‘>Max Qry Len (s)</TH><TH class=‘awrbg‘>Max Tx Concy</TH><TH class=‘awrbg‘>Tun Ret (mins)</TH><TH class=‘awrbg‘>STO/ OOS</TH><TH class=‘awrbg‘> uS/uR/uU/ eS/eR/eU</TH></TR>
<TR><TD class=‘awrc‘>01-Jul 16:06</TD> <TD ALIGN=‘right‘ class=‘awrc‘>91</TD> <TD ALIGN=‘right‘ class=‘awrc‘>104</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 15:56</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 15:46</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5</TD> <TD ALIGN=‘right‘ class=‘awrc‘>174</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 15:36</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 15:26</TD> <TD ALIGN=‘right‘ class=‘awrc‘>41</TD> <TD ALIGN=‘right‘ class=‘awrc‘>172</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 15:16</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 15:06</TD> <TD ALIGN=‘right‘ class=‘awrc‘>67</TD> <TD ALIGN=‘right‘ class=‘awrc‘>141</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 14:56</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 14:46</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>27</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 14:36</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 14:26</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 14:16</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 14:06</TD> <TD ALIGN=‘right‘ class=‘awrc‘>32</TD> <TD ALIGN=‘right‘ class=‘awrc‘>91</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 13:56</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 13:46</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 13:36</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 13:26</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 13:16</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 13:06</TD> <TD ALIGN=‘right‘ class=‘awrc‘>40</TD> <TD ALIGN=‘right‘ class=‘awrc‘>91</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 12:56</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 12:46</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6</TD> <TD ALIGN=‘right‘ class=‘awrc‘>12</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 12:36</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 12:26</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 12:16</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 12:06</TD> <TD ALIGN=‘right‘ class=‘awrc‘>37</TD> <TD ALIGN=‘right‘ class=‘awrc‘>90</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 11:56</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 11:46</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 11:36</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 11:26</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 11:16</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 11:06</TD> <TD ALIGN=‘right‘ class=‘awrc‘>30</TD> <TD ALIGN=‘right‘ class=‘awrc‘>85</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 10:56</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrc‘>01-Jul 10:46</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>180</TD> <TD class=‘awrc‘>0/0</TD> <TD class=‘awrc‘>0/0/0/0/0/0</TD></TR>
<TR><TD class=‘awrnc‘>01-Jul 10:36</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>180</TD> <TD class=‘awrnc‘>0/0</TD> <TD class=‘awrnc‘>0/0/0/0/0/0</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#28‘>Back to Undo Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘29‘></A>
<H2 class=‘awr‘>
Latch Statistics
</H2>
<UL>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#3500‘>
Latch Activity
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#3600‘>
Latch Sleep Breakdown
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#3700‘>
Latch Miss Sources
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#3800‘>
Parent Latch Statistics
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#3900‘>
Child Latch Statistics
</A>
</UL>
<A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘3500‘></A>
<H3 class=‘awr‘>Latch Activity</H3>
<UL>
<LI class=‘awr‘> "Get Requests","Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
<LI class=‘awr‘> "NoWait Requests","Pct NoWait Miss" are for no-wait latch get requests
<LI class=‘awr‘> "Pct Misses" for both should be very close to 0.0
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Latch Name</TH><TH class=‘awrbg‘>Get Requests</TH><TH class=‘awrbg‘>Pct Get Miss</TH><TH class=‘awrbg‘>Avg Slps /Miss</TH><TH class=‘awrbg‘>Wait Time (s)</TH><TH class=‘awrbg‘>NoWait Requests</TH><TH class=‘awrbg‘>Pct NoWait Miss</TH></TR>
<TR><TD class=‘awrc‘>AWR Alerted Metric Element list</TD> <TD ALIGN=‘right‘ class=‘awrc‘>205,563</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>Consistent RBA</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>10,840</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>FAL request queue</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,163</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>FAL subheap alocation</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,163</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>FIB s.o chain latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>FOB s.o list latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>487</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>JS mem alloc latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>JS queue access latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>JS queue state obj latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>348,464</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>JS slv state obj latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>KGX</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>45,434</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>KMG MMAN ready and startup request latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>19,356</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>KTF sga latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>99</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>19,349</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>KWQMN job cache list latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>13</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>MQL Tracking Latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,147</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>Memory Management Latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>19,356</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>OS process</TD> <TD ALIGN=‘right‘ class=‘awrc‘>384</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>OS process allocation</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>19,612</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>OS process: request allocation</TD> <TD ALIGN=‘right‘ class=‘awrc‘>116</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>PL/SQL warning settings</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,126</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>SQL memory manager latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>19,338</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>SQL memory manager workarea list latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,298,248</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>Shared B-Tree</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,073</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>active checkpoint queue latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>24,156</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>active service list</TD> <TD ALIGN=‘right‘ class=‘awrc‘>104,881</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>19,412</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>archive control</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,101</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>archive process latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>20,501</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>begin backup scn array</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>78</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>cache buffer handles</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,004</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>cache buffers chains</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>906,714</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>11,004</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>cache buffers lru chain</TD> <TD ALIGN=‘right‘ class=‘awrc‘>26,757</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>14,570</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>cache table scan latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>50</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>50</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>cas latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>44</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>channel handle pool latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>118</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>channel operations parent latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>271,775</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>checkpoint queue latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>777,600</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6,078</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>client/application info</TD> <TD ALIGN=‘right‘ class=‘awrc‘>155</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>compile environment latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>640</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>dml lock allocation</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7,015</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>dummy allocation</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>118</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>enqueue hash chains</TD> <TD ALIGN=‘right‘ class=‘awrc‘>862,789</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>enqueues</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>822,144</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>event group latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>58</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>file cache latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,630</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>global KZLD latch for mem in SGA</TD> <TD ALIGN=‘right‘ class=‘awrc‘>20</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>hash table column usage latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>451</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>91,302</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>hash table modification latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>845</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>job workq parent latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>job_queue_processes parameter latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>969</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>kks stats</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>976</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>ksuosstats global area</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3,908</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>ktm global data</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>202</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>kwqbsn:qsga</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,073</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>lgwr LWN SCN</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>20,417</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>library cache</TD> <TD ALIGN=‘right‘ class=‘awrc‘>186,984</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.13</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>404</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>library cache load lock</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>654</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>library cache lock</TD> <TD ALIGN=‘right‘ class=‘awrc‘>51,295</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.03</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.29</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>library cache lock allocation</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>854</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>library cache pin</TD> <TD ALIGN=‘right‘ class=‘awrc‘>133,569</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>library cache pin allocation</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>304</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>list of block allocation</TD> <TD ALIGN=‘right‘ class=‘awrc‘>286</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>loader state object freelist</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>272</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>message pool operations parent latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>messages</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>387,049</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>mostly latch-free SCN</TD> <TD ALIGN=‘right‘ class=‘awrc‘>23,209</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>multiblock read objects</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>120</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>ncodef allocation latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>925</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>object queue header heap</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>26</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>object queue header operation</TD> <TD ALIGN=‘right‘ class=‘awrc‘>87,417</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>object stats modification</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>35</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>parallel query alloc buffer</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7,736</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>parameter table allocation management</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>60</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.67</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>post/wait queue</TD> <TD ALIGN=‘right‘ class=‘awrc‘>148</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>40</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>process allocation</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>116</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.59</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>58</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>process group creation</TD> <TD ALIGN=‘right‘ class=‘awrc‘>116</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>qmn task queue latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8,292</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>redo allocation</TD> <TD ALIGN=‘right‘ class=‘awrc‘>51,791</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>37,118</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD></TR>
<TR><TD class=‘awrnc‘>redo copy</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>37,118</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.57</TD></TR>
<TR><TD class=‘awrc‘>redo on-disk SCN</TD> <TD ALIGN=‘right‘ class=‘awrc‘>71,288</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>redo writing</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>97,300</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>resmgr group change latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>29</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>resmgr:actses active list</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>67</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>resmgr:actses change group</TD> <TD ALIGN=‘right‘ class=‘awrc‘>24</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>resmgr:free threads list</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>49</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.04</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>resmgr:schema config</TD> <TD ALIGN=‘right‘ class=‘awrc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>rm cas latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>188</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>row cache objects</TD> <TD ALIGN=‘right‘ class=‘awrc‘>253,565</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>sequence cache</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>202</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>session allocation</TD> <TD ALIGN=‘right‘ class=‘awrc‘>59,898</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>session idle bit</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3,229</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>session state list latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>205</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>session switching</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>925</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>session timer</TD> <TD ALIGN=‘right‘ class=‘awrc‘>19,412</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>shared pool</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>56,812</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.25</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>simulator hash latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>22,753</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>simulator lru latch</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>21,971</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>462</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>slave class</TD> <TD ALIGN=‘right‘ class=‘awrc‘>35</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>slave class create</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>139</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>12.23</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>sort extent pool</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,614</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>state object free list</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>36</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>statistics aggregation</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,016</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>temp lob duration state obj allocation</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>threshold alerts latch</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3,069</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>transaction allocation</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>202</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>transaction branch allocation</TD> <TD ALIGN=‘right‘ class=‘awrc‘>925</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>undo global data</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>23,103</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>user lock</TD> <TD ALIGN=‘right‘ class=‘awrc‘>82</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3.66</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#29‘>Back to Latch Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘3600‘></A>
<H3 class=‘awr‘>Latch Sleep Breakdown</H3>
<UL>
<LI class=‘awr‘> ordered by misses desc
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Latch Name</TH><TH class=‘awrbg‘>Get Requests</TH><TH class=‘awrbg‘>Misses</TH><TH class=‘awrbg‘>Sleeps</TH><TH class=‘awrbg‘>Spin Gets</TH><TH class=‘awrbg‘>Sleep1</TH><TH class=‘awrbg‘>Sleep2</TH><TH class=‘awrbg‘>Sleep3</TH></TR>
<TR><TD class=‘awrc‘>library cache</TD>
<TD ALIGN=‘right‘ class=‘awrc‘>186,984</TD> <TD ALIGN=‘right‘ class=‘awrc‘>40</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5</TD> <TD ALIGN=‘right‘ class=‘awrc‘>35</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD class=‘awrnc‘>library cache lock</TD>
<TD ALIGN=‘right‘ class=‘awrnc‘>51,295</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>5</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>13</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD class=‘awrc‘>slave class create</TD>
<TD ALIGN=‘right‘ class=‘awrc‘>139</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD class=‘awrnc‘>shared pool</TD>
<TD ALIGN=‘right‘ class=‘awrnc‘>56,812</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD class=‘awrc‘>process allocation</TD>
<TD ALIGN=‘right‘ class=‘awrc‘>116</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#29‘>Back to Latch Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘3700‘></A>
<H3 class=‘awr‘>Latch Miss Sources</H3>
<UL>
<LI class=‘awr‘> only latches with sleeps are shown
<LI class=‘awr‘> ordered by name,sleeps desc
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Latch Name</TH><TH class=‘awrbg‘>Where</TH><TH class=‘awrbg‘>NoWait Misses</TH><TH class=‘awrbg‘> Sleeps</TH><TH class=‘awrbg‘>Waiter Sleeps</TH></TR>
<TR><TD class=‘awrc‘>library cache</TD> <TD class=‘awrc‘>kglhdgc: child:</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD></TR>
<TR><TD class=‘awrnc‘>library cache</TD> <TD class=‘awrnc‘>kglpin: child: heap processing</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD class=‘awrc‘>library cache</TD> <TD class=‘awrc‘>kglpndl: child: before processing</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD></TR>
<TR><TD class=‘awrnc‘>library cache lock</TD> <TD class=‘awrnc‘>kgllkdl: child: cleanup</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>5</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>5</TD></TR>
<TR><TD class=‘awrc‘>process allocation</TD> <TD class=‘awrc‘>ksucrp</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD class=‘awrnc‘>shared pool</TD> <TD class=‘awrnc‘>kghalo</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD></TR>
<TR><TD class=‘awrc‘>slave class create</TD> <TD class=‘awrc‘>ksvcreate</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#29‘>Back to Latch Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘3800‘></A>
</TABLE><P>
<H3 class=‘awr‘>Parent Latch Statistics</H3>

（编辑：威海站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!