|
<P>
No data exists for this section of the report.
<P>
<A class=‘awr‘ HREF=‘#29‘>Back to Latch Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘30‘></A>
<H2 class=‘awr‘>
Segment Statistics
</H2>
<UL>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#4000‘>
Segments by Logical Reads
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#4100‘>
Segments by Physical Reads
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#4200‘>
Segments by Row Lock Waits
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#4300‘>
Segments by ITL Waits
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#4400‘>
Segments by Buffer Busy Waits
</A>
</UL>
<A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘4000‘></A>
<H3 class=‘awr‘>Segments by Logical Reads</H3>
<UL>
<LI class=‘awr‘>Total Logical Reads: 404,261
<LI class=‘awr‘>Captured Segments account for 70.5% of Total
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Owner</TH><TH class=‘awrbg‘>Tablespace Name</TH><TH class=‘awrbg‘>Object Name</TH><TH class=‘awrbg‘>Subobject Name</TH><TH class=‘awrbg‘>Obj. Type</TH><TH class=‘awrbg‘>Logical Reads</TH><TH class=‘awrbg‘>%Total</TH></TR>
<TR><TD class=‘awrc‘>SYS</TD> <TD class=‘awrc‘>SYSTEM</TD> <TD class=‘awrc‘>SMON_SCN_TIME</TD> <TD class=‘awrc‘>?</TD> <TD class=‘awrc‘>TABLE</TD> <TD ALIGN=‘right‘ class=‘awrc‘>75,936</TD> <TD ALIGN=‘right‘ class=‘awrc‘>18.78</TD></TR>
<TR><TD class=‘awrnc‘>SYS</TD> <TD class=‘awrnc‘>SYSTEM</TD> <TD class=‘awrnc‘>I_JOB_NEXT</TD> <TD class=‘awrnc‘>?</TD> <TD class=‘awrnc‘>INDEX</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>35,136</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8.69</TD></TR>
<TR><TD class=‘awrc‘>SYS</TD> <TD class=‘awrc‘>SYSTEM</TD> <TD class=‘awrc‘>COLTYPE$</TD> <TD class=‘awrc‘>?</TD> <TD class=‘awrc‘>TABLE</TD> <TD ALIGN=‘right‘ class=‘awrc‘>16,528</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.09</TD></TR>
<TR><TD class=‘awrnc‘>SYS</TD> <TD class=‘awrnc‘>SYSTEM</TD> <TD class=‘awrnc‘>TAB$</TD> <TD class=‘awrnc‘>?</TD> <TD class=‘awrnc‘>TABLE</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>13,904</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.44</TD></TR>
<TR><TD class=‘awrc‘>SYS</TD> <TD class=‘awrc‘>SYSTEM</TD> <TD class=‘awrc‘>OBJ$</TD> <TD class=‘awrc‘>?</TD> <TD class=‘awrc‘>TABLE</TD> <TD ALIGN=‘right‘ class=‘awrc‘>11,968</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.96</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#30‘>Back to Segment Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘4100‘></A>
<H3 class=‘awr‘>Segments by Physical Reads</H3>
<UL>
<LI class=‘awr‘>Total Physical Reads: 1,581
<LI class=‘awr‘>Captured Segments account for 93.0% of Total
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Owner</TH><TH class=‘awrbg‘>Tablespace Name</TH><TH class=‘awrbg‘>Object Name</TH><TH class=‘awrbg‘>Subobject Name</TH><TH class=‘awrbg‘>Obj. Type</TH><TH class=‘awrbg‘>Physical Reads</TH><TH class=‘awrbg‘>%Total</TH></TR>
<TR><TD class=‘awrc‘>SKODACOM</TD> <TD class=‘awrc‘>SKODACOM</TD> <TD class=‘awrc‘>TB_USER</TD> <TD class=‘awrc‘>?</TD> <TD class=‘awrc‘>TABLE</TD> <TD ALIGN=‘right‘ class=‘awrc‘>400</TD> <TD ALIGN=‘right‘ class=‘awrc‘>25.30</TD></TR>
<TR><TD class=‘awrnc‘>SYS</TD> <TD class=‘awrnc‘>SYSTEM</TD> <TD class=‘awrnc‘>VIEW$</TD> <TD class=‘awrnc‘>?</TD> <TD class=‘awrnc‘>TABLE</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>306</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>19.35</TD></TR>
<TR><TD class=‘awrc‘>SKODACOM</TD> <TD class=‘awrc‘>SKODACOM</TD> <TD class=‘awrc‘>TB_USER_PK</TD> <TD class=‘awrc‘>?</TD> <TD class=‘awrc‘>INDEX</TD> <TD ALIGN=‘right‘ class=‘awrc‘>250</TD> <TD ALIGN=‘right‘ class=‘awrc‘>15.81</TD></TR>
<TR><TD class=‘awrnc‘>SKODACOM</TD> <TD class=‘awrnc‘>SKODACOM</TD> <TD class=‘awrnc‘>TB_THREAD</TD> <TD class=‘awrnc‘>?</TD> <TD class=‘awrnc‘>TABLE</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>181</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>11.45</TD></TR>
<TR><TD class=‘awrc‘>SYS</TD> <TD class=‘awrc‘>SYSTEM</TD> <TD class=‘awrc‘>IDL_UB1$</TD> <TD class=‘awrc‘>?</TD> <TD class=‘awrc‘>TABLE</TD> <TD ALIGN=‘right‘ class=‘awrc‘>152</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9.61</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#30‘>Back to Segment Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘4200‘></A>
</TABLE><P>
<H3 class=‘awr‘>Segments by Row Lock Waits</H3> （编辑：广西网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
