|
<P>
No data exists for this section of the report.
<P>
<A class=‘awr‘ HREF=‘#30‘>Back to Segment Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘4700‘></A>
<H3 class=‘awr‘>Dictionary Cache Stats</H3>
<UL>
<LI class=‘awr‘> "Pct Misses" should be very low (< 2% in most cases)
<LI class=‘awr‘> "Final Usage" is the number of cache entries being used
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Cache</TH><TH class=‘awrbg‘>Get Requests</TH><TH class=‘awrbg‘>Pct Miss</TH><TH class=‘awrbg‘>Scan Reqs</TH><TH class=‘awrbg‘>Pct Miss</TH><TH class=‘awrbg‘>Mod Reqs</TH><TH class=‘awrbg‘>Final Usage</TH></TR>
<TR><TD class=‘awrc‘>dc_awr_control</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,025</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>36</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD></TR>
<TR><TD class=‘awrnc‘>dc_global_oids</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>209</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.44</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>87</TD></TR>
<TR><TD class=‘awrc‘>dc_histogram_data</TD> <TD ALIGN=‘right‘ class=‘awrc‘>16,192</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.72</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>11,807</TD></TR>
<TR><TD class=‘awrnc‘>dc_histogram_defs</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>18,005</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.81</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3,890</TD></TR>
<TR><TD class=‘awrc‘>dc_object_ids</TD> <TD ALIGN=‘right‘ class=‘awrc‘>8,556</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.55</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,189</TD></TR>
<TR><TD class=‘awrnc‘>dc_objects</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3,301</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.36</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,304</TD></TR>
<TR><TD class=‘awrc‘>dc_profiles</TD> <TD ALIGN=‘right‘ class=‘awrc‘>22</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD></TR>
<TR><TD class=‘awrnc‘>dc_rollback_segments</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>15,572</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>29</TD></TR>
<TR><TD class=‘awrc‘>dc_segments</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,960</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.51</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>37</TD> <TD ALIGN=‘right‘ class=‘awrc‘>819</TD></TR>
<TR><TD class=‘awrnc‘>dc_sequences</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>5</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>5</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8</TD></TR>
<TR><TD class=‘awrc‘>dc_tablespaces</TD> <TD ALIGN=‘right‘ class=‘awrc‘>16,710</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9</TD></TR>
<TR><TD class=‘awrnc‘>dc_usernames</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>125</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.80</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>12</TD></TR>
<TR><TD class=‘awrc‘>dc_users</TD> <TD ALIGN=‘right‘ class=‘awrc‘>13,645</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>37</TD></TR>
<TR><TD class=‘awrnc‘>outstanding_alerts</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>970</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8</TD></TR>
</TABLE><P>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘4900‘></A>
<H3 class=‘awr‘>Library Cache Activity</H3>
<UL>
<LI class=‘awr‘> "Pct Misses" should be very low
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Namespace</TH><TH class=‘awrbg‘>Get Requests</TH><TH class=‘awrbg‘>Pct Miss</TH><TH class=‘awrbg‘>Pin Requests</TH><TH class=‘awrbg‘>Pct Miss</TH><TH class=‘awrbg‘>Reloads</TH><TH class=‘awrbg‘>Invali- dations</TH></TR>
<TR><TD class=‘awrc‘>BODY</TD> <TD ALIGN=‘right‘ class=‘awrc‘>123</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.44</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,310</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.46</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD class=‘awrnc‘>CLUSTER</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>35</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>64</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD class=‘awrc‘>INDEX</TD> <TD ALIGN=‘right‘ class=‘awrc‘>45</TD> <TD ALIGN=‘right‘ class=‘awrc‘>22.22</TD> <TD ALIGN=‘right‘ class=‘awrc‘>115</TD> <TD ALIGN=‘right‘ class=‘awrc‘>8.70</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD class=‘awrnc‘>SQL AREA</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>176</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>97.16</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>48,607</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.77</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>105</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD class=‘awrc‘>TABLE/PROCEDURE</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,043</TD> <TD ALIGN=‘right‘ class=‘awrc‘>8.92</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5,550</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5.14</TD> <TD ALIGN=‘right‘ class=‘awrc‘>61</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
</TABLE><P>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘33‘></A>
<H2 class=‘awr‘>
Memory Statistics
</H2>
<UL>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#7300‘>
Process Memory Summary
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#5900‘>
SGA Memory Summary
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#6100‘>
SGA breakdown difference
</A>
</UL>
<A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘7300‘></A>
<H3 class=‘awr‘>Process Memory Summary</H3>
<UL>
<LI class=‘awr‘> B: Begin snap E: End snap
<LI class=‘awr‘> All rows below contain absolute values (i.e. not diffed over the interval)
<LI class=‘awr‘> Max Alloc is Maximum PGA Allocation size at snapshot time
<LI class=‘awr‘> Hist Max Alloc is the Historical Max Allocation for still-connected processes
<LI class=‘awr‘> ordered by Begin/End snapshot,Alloc (MB) desc
</UL>
<TABLE BORDER=1><TR><TH class=‘awrnobg‘></TH><TH class=‘awrbg‘>Category</TH><TH class=‘awrbg‘>Alloc (MB)</TH><TH class=‘awrbg‘>Used (MB)</TH><TH class=‘awrbg‘>Avg Alloc (MB)</TH><TH class=‘awrbg‘>Std Dev Alloc (MB)</TH><TH class=‘awrbg‘>Max Alloc (MB)</TH><TH class=‘awrbg‘>Hist Max Alloc (MB)</TH><TH class=‘awrbg‘>Num Proc</TH><TH class=‘awrbg‘>Num Alloc</TH></TR>
<TR><TD class=‘awrc‘>B</TD> <TD class=‘awrc‘>Other</TD> <TD ALIGN=‘right‘ class=‘awrc‘>99.86</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5.87</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9.41</TD> <TD ALIGN=‘right‘ class=‘awrc‘>23</TD> <TD ALIGN=‘right‘ class=‘awrc‘>23</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD></TR>
<TR><TD class=‘awrnc‘>?</TD> <TD class=‘awrnc‘>Freeable</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4.06</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.68</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.41</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6</TD></TR>
<TR><TD class=‘awrc‘>?</TD> <TD class=‘awrc‘>SQL</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.31</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.16</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.03</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.04</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7</TD></TR>
<TR><TD class=‘awrnc‘>?</TD> <TD class=‘awrnc‘>PL/SQL</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.09</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.03</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>17</TD></TR>
<TR><TD class=‘awrc‘>E</TD> <TD class=‘awrc‘>Other</TD> <TD ALIGN=‘right‘ class=‘awrc‘>99.55</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5.86</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9.42</TD> <TD ALIGN=‘right‘ class=‘awrc‘>23</TD> <TD ALIGN=‘right‘ class=‘awrc‘>23</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD></TR>
<TR><TD class=‘awrnc‘>?</TD> <TD class=‘awrnc‘>Freeable</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4.13</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.69</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.36</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6</TD></TR>
<TR><TD class=‘awrc‘>?</TD> <TD class=‘awrc‘>SQL</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.25</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.13</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.03</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.03</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7</TD></TR>
<TR><TD class=‘awrnc‘>?</TD> <TD class=‘awrnc‘>PL/SQL</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.11</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.05</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>17</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#33‘>Back to Memory Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘5900‘></A>
<H3 class=‘awr‘>SGA Memory Summary</H3>
<UL>
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>SGA regions</TH><TH class=‘awrbg‘>Begin Size (Bytes)</TH><TH class=‘awrbg‘>End Size (Bytes) (if different)</TH></TR>
<TR><TD class=‘awrc‘>Database Buffers</TD> <TD ALIGN=‘right‘ class=‘awrc‘>889,192,448</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>Fixed Size</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2,020,384</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>Redo Buffers</TD> <TD ALIGN=‘right‘ class=‘awrc‘>14,753,792</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>Variable Size</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>318,770,144</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#33‘>Back to Memory Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘6100‘></A>
<H3 class=‘awr‘>SGA breakdown difference</H3>
<UL>
<LI class=‘awr‘> ordered by Pool,Name
<LI class=‘awr‘> N/A value for Begin MB or End MB indicates the size of that Pool/Name was
insignificant,or zero in that snapshot
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Pool</TH><TH class=‘awrbg‘>Name</TH><TH class=‘awrbg‘>Begin MB</TH><TH class=‘awrbg‘>End MB</TH><TH class=‘awrbg‘>% Diff</TH></TR>
<TR><TD class=‘awrc‘>java</TD> <TD class=‘awrc‘>free memory</TD> <TD ALIGN=‘right‘ class=‘awrc‘>16.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>16.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>large</TD> <TD class=‘awrnc‘>PX msg pool</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.99</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.99</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>large</TD> <TD class=‘awrc‘>free memory</TD> <TD ALIGN=‘right‘ class=‘awrc‘>15.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>15.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>shared</TD> <TD class=‘awrnc‘>ASH buffers</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>shared</TD> <TD class=‘awrc‘>CCursor</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.02</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.58</TD></TR>
<TR><TD class=‘awrnc‘>shared</TD> <TD class=‘awrnc‘>FileOpenBlock</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.54</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.54</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>shared</TD> <TD class=‘awrc‘>KCB Table Scan Buffer</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>shared</TD> <TD class=‘awrnc‘>KGLS heap</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.87</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.96</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.11</TD></TR>
<TR><TD class=‘awrc‘>shared</TD> <TD class=‘awrc‘>KQR M PO</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.80</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.98</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6.39</TD></TR>
<TR><TD class=‘awrnc‘>shared</TD> <TD class=‘awrnc‘>KQR M SO</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>5.55</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>5.60</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.95</TD></TR>
<TR><TD class=‘awrc‘>shared</TD> <TD class=‘awrc‘>KSFD SGA I/O b</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>shared</TD> <TD class=‘awrnc‘>KTI-UNDO</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.22</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.22</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>shared</TD> <TD class=‘awrc‘>PCursor</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3.43</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3.42</TD> <TD ALIGN=‘right‘ class=‘awrc‘>-0.29</TD></TR>
<TR><TD class=‘awrnc‘>shared</TD> <TD class=‘awrnc‘>PL/SQL MPCODE</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.06</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>shared</TD> <TD class=‘awrc‘>db_block_hash_buckets</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.20</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.20</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>shared</TD> <TD class=‘awrnc‘>event statistics per sess</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.88</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.88</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>shared</TD> <TD class=‘awrc‘>free memory</TD> <TD ALIGN=‘right‘ class=‘awrc‘>123.16</TD> <TD ALIGN=‘right‘ class=‘awrc‘>111.86</TD> <TD ALIGN=‘right‘ class=‘awrc‘>-9.17</TD></TR>
<TR><TD class=‘awrnc‘>shared</TD> <TD class=‘awrnc‘>kglsim hash table bkts</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>shared</TD> <TD class=‘awrc‘>library cache</TD> <TD ALIGN=‘right‘ class=‘awrc‘>10.28</TD> <TD ALIGN=‘right‘ class=‘awrc‘>10.58</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.99</TD></TR>
<TR><TD class=‘awrnc‘>shared</TD> <TD class=‘awrnc‘>private strands</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6.05</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6.05</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>shared</TD> <TD class=‘awrc‘>row cache</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7.13</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7.13</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>shared</TD> <TD class=‘awrnc‘>sql area</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>17.95</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>27.16</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>51.32</TD></TR>
<TR><TD class=‘awrc‘>?</TD> <TD class=‘awrc‘>buffer_cache</TD> <TD ALIGN=‘right‘ class=‘awrc‘>848.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>848.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
<TR><TD class=‘awrnc‘>?</TD> <TD class=‘awrnc‘>fixed_sga</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.93</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.93</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD></TR>
<TR><TD class=‘awrc‘>?</TD> <TD class=‘awrc‘>log_buffer</TD> <TD ALIGN=‘right‘ class=‘awrc‘>14.07</TD> <TD ALIGN=‘right‘ class=‘awrc‘>14.07</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#33‘>Back to Memory Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘34‘></A>
<H2 class=‘awr‘>
Streams Statistics
</H2>
<UL>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#6150‘>
Streams CPU/IO Usage
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#6200‘>
Streams Capture
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#6300‘>
Streams Apply
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#6400‘>
Buffered Queues
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#6500‘>
Buffered Subscribers
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#6600‘>
Rule Set
</A>
</UL>
<A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘6150‘></A>
</TABLE><P>
<H3 class=‘awr‘>Streams CPU/IO Usage</H3> （编辑：威海站长网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
