|
副标题[/!--empirenews.page--]
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning,OLAP and Data Mining options
[
[email?protected]_maridb ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 1 16:08:08 2019
Copyright (c) 1982,2005,Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning,OLAP and Data Mining options
SQL> var snap_id number
SQL> exec :snap_id:=dbms_workload_repository.create_snapshot
PL/SQL procedure successfully completed.
SQL> print snap_id
SNAP_ID
52434
SQL> @?/rdbms/admin/awrrpt.sql
Current Instance
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
3047903966 SKODACOM 1 TSH1
Specify the Report Type
Would you like an HTML report,or a plain text report?
Enter ‘html‘ for an HTML report,or ‘text‘ for plain text
Defaults to ‘html‘
Enter value for report_type:
Type Specified: html
Instances in this Workload Repository schema
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
3047903966 1 SKODACOM skodacom skodacom
3047903966 1 SKODACOM skodacom localhost.lo
caldomain
* 3047903966 1 SKODACOM TSH1 204_maridb
Using 3047903966 for database Id
Using 1 for instance number
Specify the number of days of snapshots to choose from
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing <return> without
specifying a number lists all completed snapshots.
Enter value for num_days: 1
Listing the last day‘s Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
TSH1 SKODACOM 52416 01 Jul 2019 00:00 1
52417 01 Jul 2019 01:00 1
52418 01 Jul 2019 02:00 1
52419 01 Jul 2019 03:00 1
52420 01 Jul 2019 04:01 1
52421 01 Jul 2019 05:00 1
52422 01 Jul 2019 06:00 1
52423 01 Jul 2019 07:00 1
52424 01 Jul 2019 08:00 1
52425 01 Jul 2019 09:01 1
52426 01 Jul 2019 10:00 1
52427 01 Jul 2019 11:00 1
52428 01 Jul 2019 12:00 1
52429 01 Jul 2019 13:00 1
52430 01 Jul 2019 14:00 1
52431 01 Jul 2019 15:00 1
52432 01 Jul 2019 15:20 1
52433 01 Jul 2019 16:00 1
52434 01 Jul 2019 16:08 1
Specify the Begin and End Snapshot Ids
Enter value for begin_snap: 52416
Begin Snapshot Id specified: 52416
Enter value for end_snap: 52434
End Snapshot Id specified: 52434
Specify the Report Name
The default report file name is awrrpt_1_52416_52434.html. To use this name,
press <return> to continue,otherwise enter an alternative.
Enter value for report_name:
Using the report name awrrpt_1_52416_52434.html
<HTML><HEAD><TITLE>AWR Report</TITLE><style type="text/css">body.awr {font:bold 10pt Arial,Helvetica,Geneva,sans-serif;color:black; background:White;}
pre.awr {font:8pt Courier;color:black; background:White;}h1.awr {font:bold 20pt Arial,sans-serif;color:#336699;background-color:White;border-bottom:1px solid #cccc99;margin-top:0pt; margin-bottom:0pt;padding:0px 0px 0px 0px;}
h2.awr {font:bold 18pt Arial,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}
h3.awr {font:bold 16pt Arial,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}li.awr {font: 8pt Arial,sans-serif; color:black; background:White;}
th.awrnobg {font:bold 8pt Arial,sans-serif; color:black; background:White;padding-left:4px; padding-right:4px;padding-bottom:2px}th.awrbg {font:bold 8pt Arial,sans-serif; color:White; background:#0066CC;padding-left:4px; padding-right:4px;padding-bottom:2px}
td.awrnc {font:8pt Arial,sans-serif;color:black;background:White;vertical-align:top;}
td.awrc {font:8pt Arial,sans-serif;color:black;background:#FFFFCC; vertical-align:top;}a.awr {font:bold 8pt Arial,sans-serif;color:#663300; vertical-align:top;margin-top:0pt; margin-bottom:0pt;}
</style></HEAD><BODY class=‘awr‘>
<H1 class=‘awr‘>
WORKLOAD REPOSITORY report for
</H1>
<P>
<TABLE BORDER=1 WIDTH=500>
<TR><TH class=‘awrbg‘>DB Name</TH><TH class=‘awrbg‘>DB Id</TH><TH class=‘awrbg‘>Instance</TH><TH class=‘awrbg‘>Inst num</TH><TH class=‘awrbg‘>Release</TH><TH class=‘awrbg‘>RAC</TH><TH class=‘awrbg‘>Host</TH></TR>
<TR><TD class=‘awrnc‘>SKODACOM</TD><TD ALIGN=‘right‘ class=‘awrnc‘>3047903966</TD><TD class=‘awrnc‘>TSH1</TD><TD ALIGN=‘right‘ class=‘awrnc‘>1</TD><TD class=‘awrnc‘>10.2.0.1.0</TD><TD class=‘awrnc‘>NO</TD><TD class=‘awrnc‘>204_maridb</TD></TR>
</TABLE>
<P>
<TABLE BORDER=1 WIDTH=500>
<TR><TH class=‘awrnobg‘></TH><TH class=‘awrbg‘>Snap Id</TH><TH class=‘awrbg‘>Snap Time</TH><TH class=‘awrbg‘>Sessions</TH><TH class=‘awrbg‘>Cursors/Session</TH></TR>
<TR><TD class=‘awrnc‘>Begin Snap:</TD><TD ALIGN=‘right‘ class=‘awrnc‘>52416</TD><TD ALIGN=‘center‘ class=‘awrnc‘>01-Jul-19 00:00:43</TD><TD ALIGN=‘right‘ class=‘awrnc‘>17</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 2.5</TD></TR>
<TR><TD class=‘awrc‘>End Snap:</TD><TD ALIGN=‘right‘ class=‘awrc‘>52434</TD><TD ALIGN=‘center‘ class=‘awrc‘>01-Jul-19 16:08:31</TD><TD ALIGN=‘right‘ class=‘awrc‘>17</TD><TD ALIGN=‘right‘ class=‘awrc‘> 2.3</TD></TR>
<TR><TD class=‘awrnc‘>Elapsed:</TD><TD class=‘awrnc‘>?</TD><TD ALIGN=‘center‘ class=‘awrnc‘> 967.81 (mins)</TD><TD class=‘awrnc‘>?</TD><TD class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>DB Time:</TD><TD class=‘awrc‘>?</TD><TD ALIGN=‘center‘ class=‘awrc‘> 0.12 (mins)</TD><TD class=‘awrc‘>?</TD><TD class=‘awrc‘>?</TD></TR>
</TABLE>
<P>
<H3 class=‘awr‘><A class=‘awr‘ NAME=‘99999‘></A>Report Summary</H3>
<P>
Cache Sizes
<P>
<TABLE BORDER=1 WIDTH=500>
<TR><TH class=‘awrnobg‘></TH><TH class=‘awrbg‘>Begin</TH><TH class=‘awrbg‘>End</TH><TH class=‘awrnobg‘></TH><TH class=‘awrnobg‘></TH></TR>
<TR><TD class=‘awrnc‘>Buffer Cache:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 848M</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 848M</TD><TD class=‘awrnc‘>Std Block Size:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 8K</TD></TR>
<TR><TD class=‘awrc‘>Shared Pool Size:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 272M</TD><TD ALIGN=‘right‘ class=‘awrc‘> 272M</TD><TD class=‘awrc‘>Log Buffer:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 14,408K</TD></TR>
</TABLE>
<P>Load Profile<P>
<TABLE BORDER=1 WIDTH=500>
<TR><TH class=‘awrnobg‘></TH><TH class=‘awrbg‘>Per Second</TH><TH class=‘awrbg‘>Per Transaction</TH></TR>
<TR><TD class=‘awrnc‘>Redo size:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 275.43</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 110,302.15</TD></TR>
<TR><TD class=‘awrc‘>Logical reads:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 6.96</TD><TD ALIGN=‘right‘ class=‘awrc‘> 2,788.01</TD></TR>
<TR><TD class=‘awrnc‘>Block changes:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 1.17</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 467.69</TD></TR>
<TR><TD class=‘awrc‘>Physical reads:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 0.03</TD><TD ALIGN=‘right‘ class=‘awrc‘> 10.90</TD></TR>
<TR><TD class=‘awrnc‘>Physical writes:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 0.11</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 45.72</TD></TR>
<TR><TD class=‘awrc‘>User calls:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 0.02</TD><TD ALIGN=‘right‘ class=‘awrc‘> 9.13</TD></TR>
<TR><TD class=‘awrnc‘>Parses:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 0.15</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 61.34</TD></TR>
<TR><TD class=‘awrc‘>Hard parses:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 0.00</TD><TD ALIGN=‘right‘ class=‘awrc‘> 1.58</TD></TR>
<TR><TD class=‘awrnc‘>Sorts:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 0.34</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 134.33</TD></TR>
<TR><TD class=‘awrc‘>Logons:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 0.00</TD><TD ALIGN=‘right‘ class=‘awrc‘> 0.41</TD></TR>
<TR><TD class=‘awrnc‘>Executes:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 0.71</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 286.07</TD></TR>
<TR><TD class=‘awrc‘>Transactions:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 0.00</TD><TD class=‘awrc‘>?</TD></TR>
</TABLE>
<P>
<TABLE BORDER=1 WIDTH=500>
<TR><TD class=‘awrnc‘>% Blocks changed per Read:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 16.78</TD><TD class=‘awrnc‘>Recursive Call %:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 99.55</TD></TR>
<TR><TD class=‘awrc‘>Rollback per transaction %:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 0.00</TD><TD class=‘awrc‘>Rows per Sort:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 11.79</TD></TR>
</TABLE>
<P>
Instance Efficiency Percentages (Target 100%)
<P>
<TABLE BORDER=1 WIDTH=500>
<TR><TD class=‘awrc‘>Buffer Nowait %:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 100.00</TD><TD class=‘awrc‘>Redo NoWait %:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 99.99</TD></TR>
<TR><TD class=‘awrnc‘>Buffer Hit %:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 99.63</TD><TD class=‘awrnc‘>In-memory Sort %:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 100.00</TD></TR>
<TR><TD class=‘awrc‘>Library Hit %:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 98.79</TD><TD class=‘awrc‘>Soft Parse %:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 97.43</TD></TR>
<TR><TD class=‘awrnc‘>Execute to Parse %:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 78.56</TD><TD class=‘awrnc‘>Latch Hit %:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 100.00</TD></TR>
<TR><TD class=‘awrc‘>Parse CPU to Parse Elapsd %:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 95.45</TD><TD class=‘awrc‘>% Non-Parse CPU:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 49.03</TD></TR>
</TABLE>
<P>
Shared Pool Statistics
<P>
<TABLE BORDER=1 WIDTH=500>
<TR><TH class=‘awrnobg‘></TH><TH class=‘awrbg‘>Begin</TH><TH class=‘awrbg‘>End</TH></TR>
<TR><TD class=‘awrnc‘>Memory Usage %:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 54.72</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 58.88</TD></TR>
<TR><TD class=‘awrc‘>% SQL with executions>1:</TD><TD ALIGN=‘right‘ class=‘awrc‘> 69.86</TD><TD ALIGN=‘right‘ class=‘awrc‘> 86.77</TD></TR>
<TR><TD class=‘awrnc‘>% Memory for SQL w/exec>1:</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 73.78</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 89.49</TD></TR>
</TABLE>
<P>
Top 5 Timed Events
<P>
<TABLE BORDER=1 WIDTH=500>
<TR><TH class=‘awrbg‘>Event</TH><TH class=‘awrbg‘>Waits</TH><TH class=‘awrbg‘>Time(s)</TH><TH class=‘awrbg‘>Avg Wait(ms)</TH><TH class=‘awrbg‘>% Total Call Time</TH><TH class=‘awrbg‘>Wait Class</TH></TR>
<TR><TD class=‘awrnc‘>control file parallel write</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 19,358</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 50</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 3</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 689.2</TD><TD class=‘awrnc‘>System I/O</TD></TR>
<TR><TD class=‘awrc‘>log file parallel write</TD><TD ALIGN=‘right‘ class=‘awrc‘> 10,837</TD><TD ALIGN=‘right‘ class=‘awrc‘> 9</TD><TD ALIGN=‘right‘ class=‘awrc‘> 1</TD><TD ALIGN=‘right‘ class=‘awrc‘> 127.0</TD><TD class=‘awrc‘>System I/O</TD></TR>
<TR><TD class=‘awrnc‘>CPU time</TD><TD ALIGN=‘right‘ class=‘awrnc‘>?</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 6</TD><TD ALIGN=‘right‘ class=‘awrnc‘>?</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 85.0</TD><TD class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>os thread startup</TD><TD ALIGN=‘right‘ class=‘awrc‘> 35</TD><TD ALIGN=‘right‘ class=‘awrc‘> 1</TD><TD ALIGN=‘right‘ class=‘awrc‘> 42</TD><TD ALIGN=‘right‘ class=‘awrc‘> 20.1</TD><TD class=‘awrc‘>Concurrency</TD></TR>
<TR><TD class=‘awrnc‘>db file sequential read</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 1,287</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 1</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 1</TD><TD ALIGN=‘right‘ class=‘awrnc‘> 17.2</TD><TD class=‘awrnc‘>User I/O</TD></TR>
</TABLE>
<P>
<A class=‘awr‘ NAME=‘top‘></A>
<H2 class=‘awr‘>
Main Report
</H2>
<UL>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#99999‘>Report Summary</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#21‘>Wait Events Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#22‘>SQL Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#23‘>Instance Activity Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#24‘>IO Stats</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#1900‘>Buffer Pool Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#26‘>Advisory Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#27‘>Wait Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#28‘>Undo Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#29‘>Latch Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#30‘>Segment Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#4700‘>Dictionary Cache Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#4900‘>Library Cache Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#33‘>Memory Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#34‘>Streams Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#6700‘>Resource Limit Statistics</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#6800‘>init.ora Parameters</A>
</UL>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘21‘></A>
<H2 class=‘awr‘>
Wait Events Statistics
</H2>
<UL>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#1500‘>
Time Model Statistics
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#200‘>
Wait Class
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#100‘>
Wait Events
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#300‘>
Background Wait Events
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#1600‘>
Operating System Statistics
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#5800‘>
Service Statistics
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#5820‘>
Service Wait Class Stats
</A>
</UL>
<A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘1500‘></A>
<H3 class=‘awr‘>Time Model Statistics</H3>
<UL>
<LI class=‘awr‘>Total time in database user-calls (DB Time): 7.3s
<LI class=‘awr‘>Statistics including the word "background" measure background process
time,and so do not contribute to the DB time statistic
<LI class=‘awr‘>Ordered by % or DB time desc,Statistic name
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Statistic Name</TH><TH class=‘awrbg‘>Time (s)</TH><TH class=‘awrbg‘>% of DB Time</TH></TR>
<TR><TD class=‘awrc‘>DB CPU</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6.18</TD> <TD ALIGN=‘right‘ class=‘awrc‘>85.02</TD></TR>
<TR><TD class=‘awrnc‘>sql execute elapsed time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4.91</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>67.54</TD></TR>
<TR><TD class=‘awrc‘>parse time elapsed</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3.45</TD> <TD ALIGN=‘right‘ class=‘awrc‘>47.49</TD></TR>
<TR><TD class=‘awrnc‘>hard parse elapsed time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3.30</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>45.36</TD></TR>
<TR><TD class=‘awrc‘>PL/SQL execution elapsed time</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.06</TD> <TD ALIGN=‘right‘ class=‘awrc‘>14.53</TD></TR>
<TR><TD class=‘awrnc‘>connection management call elapsed time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.14</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.87</TD></TR>
<TR><TD class=‘awrc‘>PL/SQL compilation elapsed time</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.12</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.69</TD></TR>
<TR><TD class=‘awrnc‘>failed parse elapsed time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.08</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.09</TD></TR>
<TR><TD class=‘awrc‘>hard parse (sharing criteria) elapsed time</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.30</TD></TR>
<TR><TD class=‘awrnc‘>sequence load elapsed time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.03</TD></TR>
<TR><TD class=‘awrc‘>hard parse (bind mismatch) elapsed time</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.03</TD></TR>
<TR><TD class=‘awrnc‘>repeated bind elapsed time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.02</TD></TR>
<TR><TD class=‘awrc‘>DB time</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7.27</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
<TR><TD class=‘awrnc‘>background elapsed time</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>138.22</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>?</TD></TR>
<TR><TD class=‘awrc‘>background cpu time</TD> <TD ALIGN=‘right‘ class=‘awrc‘>129.06</TD> <TD ALIGN=‘right‘ class=‘awrc‘>?</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#21‘>Back to Wait Events Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘200‘></A>
<H3 class=‘awr‘>Wait Class</H3>
<UL>
<LI class=‘awr‘> s - second
<LI class=‘awr‘> cs - centisecond - 100th of a second
<LI class=‘awr‘> ms - millisecond - 1000th of a second
<LI class=‘awr‘> us - microsecond - 1000000th of a second
<LI class=‘awr‘> ordered by wait time desc,waits desc
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Wait Class</TH><TH class=‘awrbg‘>Waits</TH><TH class=‘awrbg‘>%Time -outs</TH><TH class=‘awrbg‘>Total Wait Time (s)</TH><TH class=‘awrbg‘>Avg wait (ms)</TH><TH class=‘awrbg‘>Waits /txn</TH></TR>
<TR><TD class=‘awrc‘>System I/O</TD> <TD ALIGN=‘right‘ class=‘awrc‘>72,706</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>60</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>501.42</TD></TR>
<TR><TD class=‘awrnc‘>Concurrency</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>47</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>32</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.32</TD></TR>
<TR><TD class=‘awrc‘>User I/O</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,499</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>10.34</TD></TR>
<TR><TD class=‘awrnc‘>Other</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>241</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.66</TD></TR>
<TR><TD class=‘awrc‘>Configuration</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>26</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD></TR>
<TR><TD class=‘awrnc‘>Commit</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>38</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.26</TD></TR>
<TR><TD class=‘awrc‘>Application</TD> <TD ALIGN=‘right‘ class=‘awrc‘>12</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.08</TD></TR>
<TR><TD class=‘awrnc‘>Network</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,296</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‘>8.94</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#21‘>Back to Wait Events Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘100‘></A>
<H3 class=‘awr‘>Wait Events</H3>
<UL>
<LI class=‘awr‘> s - second
<LI class=‘awr‘> cs - centisecond - 100th of a second
<LI class=‘awr‘> ms - millisecond - 1000th of a second
<LI class=‘awr‘> us - microsecond - 1000000th of a second
<LI class=‘awr‘> ordered by wait time desc,waits desc (idle events last)
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Event</TH><TH class=‘awrbg‘>Waits</TH><TH class=‘awrbg‘>%Time -outs</TH><TH class=‘awrbg‘>Total Wait Time (s)</TH><TH class=‘awrbg‘>Avg wait (ms)</TH><TH class=‘awrbg‘>Waits /txn</TH></TR>
<TR><TD class=‘awrc‘>control file parallel write</TD> <TD ALIGN=‘right‘ class=‘awrc‘>19,358</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>50</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>133.50</TD></TR>
<TR><TD class=‘awrnc‘>log file parallel write</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>10,837</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>74.74</TD></TR>
<TR><TD class=‘awrc‘>os thread startup</TD> <TD ALIGN=‘right‘ class=‘awrc‘>35</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>42</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.24</TD></TR>
<TR><TD class=‘awrnc‘>db file sequential read</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,287</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8.88</TD></TR>
<TR><TD class=‘awrc‘>latch free</TD> <TD ALIGN=‘right‘ class=‘awrc‘>20</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>26</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.14</TD></TR>
<TR><TD class=‘awrnc‘>control file sequential read</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>42,416</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‘>292.52</TD></TR>
<TR><TD class=‘awrc‘>db file scattered read</TD> <TD ALIGN=‘right‘ class=‘awrc‘>50</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.34</TD></TR>
<TR><TD class=‘awrnc‘>Log archive I/O</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>47</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.32</TD></TR>
<TR><TD class=‘awrc‘>log file sequential read</TD> <TD ALIGN=‘right‘ class=‘awrc‘>46</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.32</TD></TR>
<TR><TD class=‘awrnc‘>log file switch completion</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>26</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>log file sync</TD> <TD ALIGN=‘right‘ class=‘awrc‘>38</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.26</TD></TR>
<TR><TD class=‘awrnc‘>latch: library cache lock</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‘>6</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.03</TD></TR>
<TR><TD class=‘awrc‘>LGWR wait for redo copy</TD> <TD ALIGN=‘right‘ class=‘awrc‘>210</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‘>1.45</TD></TR>
<TR><TD class=‘awrnc‘>rdbms ipc reply</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>11</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.08</TD></TR>
<TR><TD class=‘awrc‘>SQLNet break/reset to client</TD> <TD ALIGN=‘right‘ class=‘awrc‘>12</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.08</TD></TR>
<TR><TD class=‘awrnc‘>SQLNet more data to client</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>172</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‘>1.19</TD></TR>
<TR><TD class=‘awrc‘>latch: shared pool</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD></TR>
<TR><TD class=‘awrnc‘>SQLNet message to client</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,112</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‘>7.67</TD></TR>
<TR><TD class=‘awrc‘>log file single write</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD></TR>
<TR><TD class=‘awrnc‘>latch: library cache</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‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.03</TD></TR>
<TR><TD class=‘awrc‘>buffer busy waits</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</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‘>0.01</TD></TR>
<TR><TD class=‘awrnc‘>direct path write</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>136</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‘>0.94</TD></TR>
<TR><TD class=‘awrc‘>SQLNet more data from client</TD> <TD ALIGN=‘right‘ class=‘awrc‘>12</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‘>0.08</TD></TR>
<TR><TD class=‘awrnc‘>direct path read</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>26</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‘>0.18</TD></TR>
<TR><TD class=‘awrc‘>Streams AQ: qmn slave idle wait</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,073</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>56,545</TD> <TD ALIGN=‘right‘ class=‘awrc‘>27277</TD> <TD ALIGN=‘right‘ class=‘awrc‘>14.30</TD></TR>
<TR><TD class=‘awrnc‘>Streams AQ: qmn coordinator idle wait</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4,150</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>50.05</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>56,545</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>13625</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>28.62</TD></TR>
<TR><TD class=‘awrc‘>Streams AQ: waiting for time management or cleanup tasks</TD> <TD ALIGN=‘right‘ class=‘awrc‘>13</TD> <TD ALIGN=‘right‘ class=‘awrc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>23,673</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1821025</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.09</TD></TR>
<TR><TD class=‘awrnc‘>SQL*Net message from client</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,112</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>19,705</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>17721</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>7.67</TD></TR>
<TR><TD class=‘awrc‘>class slave wait</TD> <TD ALIGN=‘right‘ class=‘awrc‘>35</TD> <TD ALIGN=‘right‘ class=‘awrc‘>97.14</TD> <TD ALIGN=‘right‘ class=‘awrc‘>166</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4743</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.24</TD></TR>
<TR><TD class=‘awrnc‘>jobq slave wait</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>20</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>59</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2930</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.14</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#21‘>Back to Wait Events Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘300‘></A>
<H3 class=‘awr‘>Background Wait Events</H3>
<UL>
<LI class=‘awr‘> ordered by wait time desc,837</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>74.74</TD></TR>
<TR><TD class=‘awrc‘>os thread startup</TD> <TD ALIGN=‘right‘ class=‘awrc‘>35</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>42</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.24</TD></TR>
<TR><TD class=‘awrnc‘>control file sequential read</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>29,786</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‘>205.42</TD></TR>
<TR><TD class=‘awrc‘>Log archive I/O</TD> <TD ALIGN=‘right‘ class=‘awrc‘>47</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.32</TD></TR>
<TR><TD class=‘awrnc‘>log file sequential read</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>46</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.32</TD></TR>
<TR><TD class=‘awrc‘>events in waitclass Other</TD> <TD ALIGN=‘right‘ class=‘awrc‘>221</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‘>1.52</TD></TR>
<TR><TD class=‘awrnc‘>log file single write</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>latch: library cache</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4</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‘>0.03</TD></TR>
<TR><TD class=‘awrnc‘>buffer busy waits</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</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‘>0.01</TD></TR>
<TR><TD class=‘awrc‘>direct path read</TD> <TD ALIGN=‘right‘ class=‘awrc‘>8</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‘>0.06</TD></TR>
<TR><TD class=‘awrnc‘>direct path write</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8</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‘>0.06</TD></TR>
<TR><TD class=‘awrc‘>rdbms ipc message</TD> <TD ALIGN=‘right‘ class=‘awrc‘>187,709</TD> <TD ALIGN=‘right‘ class=‘awrc‘>99.62</TD> <TD ALIGN=‘right‘ class=‘awrc‘>610,971</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3255</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,294.54</TD></TR>
<TR><TD class=‘awrnc‘>pmon timer</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>19,412</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>56,680</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2920</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>133.88</TD></TR>
<TR><TD class=‘awrc‘>Streams AQ: qmn slave idle wait</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,545</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>13625</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>28.62</TD></TR>
<TR><TD class=‘awrc‘>smon timer</TD> <TD ALIGN=‘right‘ class=‘awrc‘>196</TD> <TD ALIGN=‘right‘ class=‘awrc‘>97.96</TD> <TD ALIGN=‘right‘ class=‘awrc‘>54,961</TD> <TD ALIGN=‘right‘ class=‘awrc‘>280413</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.35</TD></TR>
<TR><TD class=‘awrnc‘>Streams AQ: waiting for time management or cleanup tasks</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>13</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>100.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>23,673</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1821025</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.09</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#21‘>Back to Wait Events Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘1600‘></A>
<H3 class=‘awr‘>Operating System Statistics</H3>
<UL>
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Statistic</TH><TH class=‘awrbg‘>Total</TH></TR>
<TR><TD class=‘awrc‘>BUSY_TIME</TD> <TD ALIGN=‘right‘ class=‘awrc‘>150,595</TD></TR>
<TR><TD class=‘awrnc‘>IDLE_TIME</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>23,037,966</TD></TR>
<TR><TD class=‘awrc‘>NICE_TIME</TD> <TD ALIGN=‘right‘ class=‘awrc‘>14</TD></TR>
<TR><TD class=‘awrnc‘>SYS_TIME</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>62,816</TD></TR>
<TR><TD class=‘awrc‘>USER_TIME</TD> <TD ALIGN=‘right‘ class=‘awrc‘>87,765</TD></TR>
<TR><TD class=‘awrnc‘>LOAD</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
<TR><TD class=‘awrc‘>RSRC_MGR_CPU_WAIT_TIME</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD></TR>
<TR><TD class=‘awrnc‘>PHYSICAL_MEMORY_BYTES</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>161,772</TD></TR>
<TR><TD class=‘awrc‘>NUM_CPUS</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4</TD></TR>
<TR><TD class=‘awrnc‘>NUM_CPU_SOCKETS</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#21‘>Back to Wait Events Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘5800‘></A>
<H3 class=‘awr‘>Service Statistics</H3>
<UL>
<LI class=‘awr‘> ordered by DB Time
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Service Name</TH><TH class=‘awrbg‘>DB Time (s)</TH><TH class=‘awrbg‘>DB CPU (s)</TH><TH class=‘awrbg‘>Physical Reads</TH><TH class=‘awrbg‘>Logical Reads</TH></TR>
<TR><TD class=‘awrc‘>SYS$USERS</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7.30</TD> <TD ALIGN=‘right‘ class=‘awrc‘>6.20</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,517</TD> <TD ALIGN=‘right‘ class=‘awrc‘>199,781</TD></TR>
<TR><TD class=‘awrnc‘>SYS$BACKGROUND</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>65</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>206,296</TD></TR>
<TR><TD class=‘awrc‘>skodacom.skodacom</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></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#21‘>Back to Wait Events Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘5820‘></A>
<H3 class=‘awr‘>Service Wait Class Stats</H3>
<UL>
<LI class=‘awr‘> Wait Class info for services in the Service Statistics section.
<LI class=‘awr‘> Total Waits and Time Waited displayed for the following wait
classes: User I/O,Concurrency,Administrative,Network
<LI class=‘awr‘> Time Waited (Wt Time) in centisecond (100th of a second)
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Service Name</TH><TH class=‘awrbg‘>User I/O Total Wts</TH><TH class=‘awrbg‘>User I/O Wt Time</TH><TH class=‘awrbg‘>Concurcy Total Wts</TH><TH class=‘awrbg‘>Concurcy Wt Time</TH><TH class=‘awrbg‘>Admin Total Wts</TH><TH class=‘awrbg‘>Admin Wt Time</TH><TH class=‘awrbg‘>Network Total Wts</TH><TH class=‘awrbg‘>Network Wt Time</TH></TR>
<TR><TD class=‘awrc‘>SYS$USERS</TD>
<TD ALIGN=‘right‘ class=‘awrc‘>1162</TD> <TD ALIGN=‘right‘ class=‘awrc‘>124</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7</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‘>1219</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD></TR>
<TR><TD class=‘awrnc‘>SYS$BACKGROUND</TD>
<TD ALIGN=‘right‘ class=‘awrnc‘>337</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>22</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>40</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>147</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#21‘>Back to Wait Events Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘22‘></A>
<H2 class=‘awr‘>
SQL Statistics
</H2>
<UL>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#400‘>
SQL ordered by Elapsed Time
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#500‘>
SQL ordered by CPU Time
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#600‘>
SQL ordered by Gets
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#700‘>
SQL ordered by Reads
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#800‘>
SQL ordered by Executions
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#900‘>
SQL ordered by Parse Calls
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#1000‘>
SQL ordered by Sharable Memory
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#1100‘>
SQL ordered by Version Count
</A>
<LI class=‘awr‘><A class=‘awr‘ HREF=‘#99997‘>
Complete List of SQL Text
</A>
</UL>
<A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘400‘></A>
<H3 class=‘awr‘>SQL ordered by Elapsed Time</H3>
<UL>
<LI class=‘awr‘> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
<LI class=‘awr‘> % Total DB Time is the Elapsed Time of the SQL statement divided
into the Total Database Time multiplied by 100
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Elapsed Time (s)</TH><TH class=‘awrbg‘>CPU Time (s)</TH><TH class=‘awrbg‘>Executions </TH><TH class=‘awrbg‘>Elap per Exec (s) </TH><TH class=‘awrbg‘>% Total DB Time</TH><TH class=‘awrbg‘> SQL Id</TH><TH class=‘awrbg‘>SQL Module</TH><TH class=‘awrbg‘>SQL Text</TH></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>9</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9</TD> <TD ALIGN=‘right‘ class=‘awrc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.48</TD> <TD ALIGN=‘right‘ class=‘awrc‘>119.75</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#bunssq950snhf‘>bunssq950snhf</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>insert into wrh$_sga_target_ad...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.32</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>31.86</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#572fbaj0fdw2b‘>572fbaj0fdw2b</A></TD>
<TD class=‘awrnc‘>
[email?protected]maridb (TNS V1-V3)
</TD>
<TD class=‘awrnc‘>select output from table(dbms...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,935</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>26.70</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#aykvshm7zsabd‘>aykvshm7zsabd</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select size_for_estimate,...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>11,613</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>21.46</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#803b7z0t84sq7‘>803b7z0t84sq7</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select job,nvl2(last_date,...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.50</TD> <TD ALIGN=‘right‘ class=‘awrc‘>13.81</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#95w06sfdyppfj‘>95w06sfdyppfj</A></TD>
<TD class=‘awrc‘>
navicat.exe
</TD>
<TD class=‘awrc‘>SELECT FROM (SELECT "NAVICAT...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.23</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>12.83</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#0pt2789bczdp0‘>0pt2789bczdp0</A></TD>
<TD class=‘awrnc‘>
navicat.exe
</TD>
<TD class=‘awrnc‘>SELECT T.TABLE_NAME,T.OWNER,...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.38</TD> <TD ALIGN=‘right‘ class=‘awrc‘>10.53</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#15xnmd14bcfby‘>15xnmd14bcfby</A></TD>
<TD class=‘awrc‘>
navicat.exe
</TD>
<TD class=‘awrc‘>SELECT T.TABLE_NAME,...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.76</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>10.51</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#5n73rjfpt3q4b‘>5n73rjfpt3q4b</A></TD>
<TD class=‘awrnc‘>
[email?protected]_maridb (TNS V1-V3)
</TD>
<TD class=‘awrnc‘>BEGIN :snap_id:=dbmsworkload...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.04</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9.53</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#d92h3rjp0y217‘>d92h3rjp0y217</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>begin prvt_hdm.auto_execute( :...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>11,613</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9.02</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#g2wr3u7s1gtf3‘>g2wr3u7s1gtf3</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select count() from sys.job$ ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>107</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5.77</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#g337099aatnuj‘>g337099aatnuj</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>update smon_scntime set orig...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4.77</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#84qubbrsr0kfn‘>84qubbrsr0kfn</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>insert into wrh$_latch (snap...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,855</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.27</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#772s25v1y0x8k‘>772s25v1y0x8k</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select shared_pool_size_for_es...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.07</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4.07</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#86synsm5txwj6‘>86synsm5txwj6</A></TD>
<TD class=‘awrnc‘>
navicat.exe
</TD>
<TD class=‘awrnc‘>SELECT V.VIEW_NAME,V.TEXT_LE...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.13</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#agpd044zj368m‘>agpd044zj368m</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>insert into wrh$_system_event ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>16</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.12</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#32wqka2zwvu65‘>32wqka2zwvu65</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>insert into wrh$_parameter (...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>97</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.88</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#a1xgxtssv5rrp‘>a1xgxtssv5rrp</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select sum(used_blocks),ts.t...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.07</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.87</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#84vvbj8g8sups‘>84vvbj8g8sups</A></TD>
<TD class=‘awrnc‘>
navicat.exe
</TD>
<TD class=‘awrnc‘>SELECT V.VIEW_NAME,V.TEXT_LE...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.13</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.84</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#1srfjbzhb29z8‘>1srfjbzhb29z8</A></TD>
<TD class=‘awrc‘>
[email?protected]_maridb (TNS V1-V3)
</TD>
<TD class=‘awrc‘> select from sys.wrh$_active...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,048</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.79</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#g00cj285jmgsw‘>g00cj285jmgsw</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>update sys.mon_mods$ set inser...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.03</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.73</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#d5bwbakqj3f79‘>d5bwbakqj3f79</A></TD>
<TD class=‘awrc‘>
navicat.exe
</TD>
<TD class=‘awrc‘>SELECT OWNER,TABLE_NAME FROM...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>85</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.62</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#6cxqh7mktnbjm‘>6cxqh7mktnbjm</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>insert into smon_scn_time (thr...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>122</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.50</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#7cq8d0jqxzum1‘>7cq8d0jqxzum1</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>delete from smon_scn_time wher...</TD></TR>
<TR><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‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.43</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#cvn54b7yz0s8u‘>cvn54b7yz0s8u</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select /+ index(idl_ub1$ i_id...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.35</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#7vgmvmy8vvb9s‘>7vgmvmy8vvb9s</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>insert into wrh$_tempstatxs ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>15</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.34</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#cfz686a6qp0kg‘>cfz686a6qp0kg</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select o.obj#,u.name,o.nam...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.31</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#chunmygjj8x7g‘>chunmygjj8x7g</A></TD>
<TD class=‘awrc‘>
navicat.exe
</TD>
<TD class=‘awrc‘>SELECT OWNER,TABLE_NAME,CO...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,680</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.30</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#8p447s6p0rv6b‘>8p447s6p0rv6b</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select java_pool_size_for_esti...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.05</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.25</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#0m9ka0jk9kk4z‘>0m9ka0jk9kk4z</A></TD>
<TD class=‘awrc‘>
navicat.exe
</TD>
<TD class=‘awrc‘>SELECT OWNER,TABLE_NAME FROM...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.08</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.10</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#8dw6saa5zu2sk‘>8dw6saa5zu2sk</A></TD>
<TD class=‘awrnc‘>
[email?protected]_maridb (TNS V1-V3)
</TD>
<TD class=‘awrnc‘>select
service_name,ui...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>328</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.07</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#bsa0wjtftg3uw‘>bsa0wjtftg3uw</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select file# from file$ where ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>16</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.05</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#586b2udq6dbng‘>586b2udq6dbng</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>insert into wrh$_sysstat (sn...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>16</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.04</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#g6wf9na8zs5hb‘>g6wf9na8zs5hb</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>insert into wrh$_sysmetric_sum...</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#22‘>Back to SQL Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘500‘></A>
<H3 class=‘awr‘>SQL ordered by CPU Time</H3>
<UL>
<LI class=‘awr‘> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
<LI class=‘awr‘> % Total DB Time is the Elapsed Time of the SQL statement divided
into the Total Database Time multiplied by 100
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>CPU Time (s)</TH><TH class=‘awrbg‘>Elapsed Time (s)</TH><TH class=‘awrbg‘>Executions </TH><TH class=‘awrbg‘>CPU per Exec (s)</TH><TH class=‘awrbg‘>% Total DB Time</TH><TH class=‘awrbg‘> SQL Id</TH><TH class=‘awrbg‘>SQL Module</TH><TH class=‘awrbg‘>SQL Text</TH></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>9</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9</TD> <TD ALIGN=‘right‘ class=‘awrc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.48</TD> <TD ALIGN=‘right‘ class=‘awrc‘>119.75</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#bunssq950snhf‘>bunssq950snhf</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>insert into wrh$_sga_target_ad...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.19</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>31.86</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#572fbaj0fdw2b‘>572fbaj0fdw2b</A></TD>
<TD class=‘awrnc‘>
[email?protected]maridb (TNS V1-V3)
</TD>
<TD class=‘awrnc‘>select output from table(dbms...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.23</TD> <TD ALIGN=‘right‘ class=‘awrc‘>12.83</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#0pt2789bczdp0‘>0pt2789bczdp0</A></TD>
<TD class=‘awrc‘>
navicat.exe
</TD>
<TD class=‘awrc‘>SELECT T.TABLE_NAME,...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.38</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>10.53</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#15xnmd14bcfby‘>15xnmd14bcfby</A></TD>
<TD class=‘awrnc‘>
navicat.exe
</TD>
<TD class=‘awrnc‘>SELECT T.TABLE_NAME,...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.73</TD> <TD ALIGN=‘right‘ class=‘awrc‘>10.51</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#5n73rjfpt3q4b‘>5n73rjfpt3q4b</A></TD>
<TD class=‘awrc‘>
[email?protected]_maridb (TNS V1-V3)
</TD>
<TD class=‘awrc‘>BEGIN :snap_id:=dbmsworkload...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.04</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9.53</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#d92h3rjp0y217‘>d92h3rjp0y217</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>begin prvt_hdm.auto_execute( :...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>11,613</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9.02</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#g2wr3u7s1gtf3‘>g2wr3u7s1gtf3</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select count() from sys.job$ ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>107</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>5.77</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#g337099aatnuj‘>g337099aatnuj</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>update smon_scntime set orig...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.77</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#84qubbrsr0kfn‘>84qubbrsr0kfn</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>insert into wrh$_latch (snap...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,855</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4.27</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#772s25v1y0x8k‘>772s25v1y0x8k</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select shared_pool_size_for_es...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.13</TD> <TD ALIGN=‘right‘ class=‘awrc‘>13.81</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#95w06sfdyppfj‘>95w06sfdyppfj</A></TD>
<TD class=‘awrc‘>
navicat.exe
</TD>
<TD class=‘awrc‘>SELECT FROM (SELECT "NAVICAT...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.06</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4.07</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#86synsm5txwj6‘>86synsm5txwj6</A></TD>
<TD class=‘awrnc‘>
navicat.exe
</TD>
<TD class=‘awrnc‘>SELECT V.VIEW_NAME,V.TEXT_LE...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.13</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#agpd044zj368m‘>agpd044zj368m</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>insert into wrh$_system_event ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>97</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.88</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#a1xgxtssv5rrp‘>a1xgxtssv5rrp</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select sum(used_blocks),ts.t...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.07</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.87</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#84vvbj8g8sups‘>84vvbj8g8sups</A></TD>
<TD class=‘awrc‘>
navicat.exe
</TD>
<TD class=‘awrc‘>SELECT V.VIEW_NAME,V.TEXT_LE...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,TABLE_NAME FROM...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>85</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.62</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#6cxqh7mktnbjm‘>6cxqh7mktnbjm</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>insert into smon_scn_time (thr...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>122</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.50</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#7cq8d0jqxzum1‘>7cq8d0jqxzum1</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>delete from smon_scn_time wher...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.10</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.84</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#1srfjbzhb29z8‘>1srfjbzhb29z8</A></TD>
<TD class=‘awrnc‘>
[email?protected]_maridb (TNS V1-V3)
</TD>
<TD class=‘awrnc‘> select * from sys.wrh$_active...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>16</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.12</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#32wqka2zwvu65‘>32wqka2zwvu65</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>insert into wrh$_parameter (...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.35</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#7vgmvmy8vvb9s‘>7vgmvmy8vvb9s</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>insert into wrh$_tempstatxs ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>15</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.34</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#cfz686a6qp0kg‘>cfz686a6qp0kg</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select o.obj#,o.nam...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.31</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#chunmygjj8x7g‘>chunmygjj8x7g</A></TD>
<TD class=‘awrnc‘>
navicat.exe
</TD>
<TD class=‘awrnc‘>SELECT OWNER,CO...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,680</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.30</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#8p447s6p0rv6b‘>8p447s6p0rv6b</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select java_pool_size_for_esti...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.05</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.25</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#0m9ka0jk9kk4z‘>0m9ka0jk9kk4z</A></TD>
<TD class=‘awrnc‘>
navicat.exe
</TD>
<TD class=‘awrnc‘>SELECT OWNER,TABLE_NAME FROM...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.08</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.10</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#8dw6saa5zu2sk‘>8dw6saa5zu2sk</A></TD>
<TD class=‘awrc‘>
[email?protected]_maridb (TNS V1-V3)
</TD>
<TD class=‘awrc‘>select
service_name,ui...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>328</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.07</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#bsa0wjtftg3uw‘>bsa0wjtftg3uw</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select file# from file$ where ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>16</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.05</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#586b2udq6dbng‘>586b2udq6dbng</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>insert into wrh$_sysstat (sn...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>16</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.04</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#g6wf9na8zs5hb‘>g6wf9na8zs5hb</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>insert into wrh$_sysmetric_sum...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.43</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#cvn54b7yz0s8u‘>cvn54b7yz0s8u</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select /*+ index(idl_ub1$ i_id...</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#22‘>Back to SQL Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘600‘></A>
<H3 class=‘awr‘>SQL ordered by Gets</H3>
<UL>
<LI class=‘awr‘> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
<LI class=‘awr‘>Total Buffer Gets: 404,261
<LI class=‘awr‘>Captured SQL account for 94.8% of Total
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Buffer Gets </TH><TH class=‘awrbg‘>Executions </TH><TH class=‘awrbg‘>Gets per Exec </TH><TH class=‘awrbg‘>%Total</TH><TH class=‘awrbg‘>CPU Time (s)</TH><TH class=‘awrbg‘>Elapsed Time (s)</TH><TH class=‘awrbg‘> SQL Id</TH><TH class=‘awrbg‘>SQL Module</TH><TH class=‘awrbg‘>SQL Text</TH></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>113,582</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>113,582.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>28.10</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.19</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.32</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#572fbaj0fdw2b‘>572fbaj0fdw2b</A></TD>
<TD class=‘awrc‘>
[email?protected]maridb (TNS V1-V3)
</TD>
<TD class=‘awrc‘>select output from table(dbms...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>38,995</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>122</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>319.63</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9.65</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.11</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.11</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#7cq8d0jqxzum1‘>7cq8d0jqxzum1</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>delete from smon_scn_time wher...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>37,904</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9,476.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>9.38</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.10</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.10</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#chunmygjj8x7g‘>chunmygjj8x7g</A></TD>
<TD class=‘awrc‘>
navicat.exe
</TD>
<TD class=‘awrc‘>SELECT OWNER,CO...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>34,630</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>107</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>323.64</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>8.57</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.42</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.42</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#g337099aatnuj‘>g337099aatnuj</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>update smon_scntime set orig...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>23,794</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5,948.50</TD> <TD ALIGN=‘right‘ class=‘awrc‘>5.89</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.93</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.93</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#0pt2789bczdp0‘>0pt2789bczdp0</A></TD>
<TD class=‘awrc‘>
navicat.exe
</TD>
<TD class=‘awrc‘>SELECT T.TABLE_NAME,...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>23,226</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>11,613</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>5.75</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.56</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.56</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#803b7z0t84sq7‘>803b7z0t84sq7</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select job,...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>17,971</TD> <TD ALIGN=‘right‘ class=‘awrc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrc‘>998.39</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.45</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.69</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.69</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#d92h3rjp0y217‘>d92h3rjp0y217</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>begin prvt_hdm.auto_execute( :...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>11,613</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>11,613</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.87</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.66</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.66</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#g2wr3u7s1gtf3‘>g2wr3u7s1gtf3</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select count() from sys.job$ ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>9,525</TD> <TD ALIGN=‘right‘ class=‘awrc‘>15</TD> <TD ALIGN=‘right‘ class=‘awrc‘>635.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.36</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.10</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.10</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#cfz686a6qp0kg‘>cfz686a6qp0kg</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select o.obj#,o.nam...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>6,019</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>3,009.50</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.49</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.26</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#95w06sfdyppfj‘>95w06sfdyppfj</A></TD>
<TD class=‘awrnc‘>
navicat.exe
</TD>
<TD class=‘awrnc‘>SELECT FROM (SELECT "NAVICAT...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>5,782</TD> <TD ALIGN=‘right‘ class=‘awrc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrc‘>321.22</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.43</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.03</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.03</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#31a13pnjps7j3‘>31a13pnjps7j3</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>SELECT source,(case w...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>4,944</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,236.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.22</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.13</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.13</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#d5bwbakqj3f79‘>d5bwbakqj3f79</A></TD>
<TD class=‘awrnc‘>
navicat.exe
</TD>
<TD class=‘awrnc‘>SELECT OWNER,TABLE_NAME FROM...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>4,594</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2,297.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.14</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.04</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.04</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#b7jn4mf49n569‘>b7jn4mf49n569</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select o.name,u.name from ob...</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#22‘>Back to SQL Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘700‘></A>
<H3 class=‘awr‘>SQL ordered by Reads</H3>
<UL>
<LI class=‘awr‘>Total Disk Reads: 1,581
<LI class=‘awr‘>Captured SQL account for 109.7% of Total
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Physical Reads</TH><TH class=‘awrbg‘>Executions</TH><TH class=‘awrbg‘>Reads per Exec </TH><TH class=‘awrbg‘>%Total</TH><TH class=‘awrbg‘>CPU Time (s)</TH><TH class=‘awrbg‘>Elapsed Time (s)</TH><TH class=‘awrbg‘> SQL Id</TH><TH class=‘awrbg‘>SQL Module</TH><TH class=‘awrbg‘>SQL Text</TH></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>880</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrc‘>440.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>55.66</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.26</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#95w06sfdyppfj‘>95w06sfdyppfj</A></TD>
<TD class=‘awrc‘>
navicat.exe
</TD>
<TD class=‘awrc‘>SELECT FROM (SELECT "NAVICAT...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>305</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>4</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>76.25</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>19.29</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.22</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.30</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#86synsm5txwj6‘>86synsm5txwj6</A></TD>
<TD class=‘awrnc‘>
navicat.exe
</TD>
<TD class=‘awrnc‘>SELECT V.VIEW_NAME,V.TEXT_LE...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>233</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>233.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>14.74</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.19</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.32</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#572fbaj0fdw2b‘>572fbaj0fdw2b</A></TD>
<TD class=‘awrc‘>
[email?protected]maridb (TNS V1-V3)
</TD>
<TD class=‘awrc‘>select output from table(dbms...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>157</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>17</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9.24</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>9.93</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.07</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.10</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#cvn54b7yz0s8u‘>cvn54b7yz0s8u</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select /+ index(idl_ub1$ i_id...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>73</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>73.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>4.62</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.10</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.13</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#1srfjbzhb29z8‘>1srfjbzhb29z8</A></TD>
<TD class=‘awrc‘>
[email?protected]_maridb (TNS V1-V3)
</TD>
<TD class=‘awrc‘> select * from sys.wrh$_active...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>14</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>12</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.17</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.89</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.02</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.03</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#a1y2ba3awndas‘>a1y2ba3awndas</A></TD>
<TD class=‘awrnc‘>
[email?protected]_maridb (TNS V1-V3)
</TD>
<TD class=‘awrnc‘>SELECT VALUE FROM DBA_HIST_PAR...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>12</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1</TD> <TD ALIGN=‘right‘ class=‘awrc‘>12.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.76</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.73</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.76</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#5n73rjfpt3q4b‘>5n73rjfpt3q4b</A></TD>
<TD class=‘awrc‘>
[email?protected]_maridb (TNS V1-V3)
</TD>
<TD class=‘awrc‘>BEGIN :snap_id:=dbmsworkload...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>12</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>6.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.76</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.03</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#awppxms81us4n‘>awppxms81us4n</A></TD>
<TD class=‘awrnc‘>
[email?protected]_maridb (TNS V1-V3)
</TD>
<TD class=‘awrnc‘>SELECT SUM(TIME_WAITED_MICRO) ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>11</TD> <TD ALIGN=‘right‘ class=‘awrc‘>18</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.61</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.70</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.69</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.69</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#d92h3rjp0y217‘>d92h3rjp0y217</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>begin prvt_hdm.auto_execute( :...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>5</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>583</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.01</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.32</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.04</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.04</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#5h7w8ykwtb2xt‘>5h7w8ykwtb2xt</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>INSERT INTO SYS.WRI$_ADV_PARAM...</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#22‘>Back to SQL Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘800‘></A>
<H3 class=‘awr‘>SQL ordered by Executions</H3>
<UL>
<LI class=‘awr‘>Total Executions: 41,480
<LI class=‘awr‘>Captured SQL account for 90.8% of Total
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Executions </TH><TH class=‘awrbg‘>Rows Processed</TH><TH class=‘awrbg‘>Rows per Exec</TH><TH class=‘awrbg‘>CPU per Exec (s)</TH><TH class=‘awrbg‘>Elap per Exec (s) </TH><TH class=‘awrbg‘> SQL Id</TH><TH class=‘awrbg‘>SQL Module</TH><TH class=‘awrbg‘>SQL Text</TH></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>11,613</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#803b7z0t84sq7‘>803b7z0t84sq7</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select job,...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>11,613</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#g2wr3u7s1gtf3‘>g2wr3u7s1gtf3</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select count(*) from sys.job$ ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1,935</TD> <TD ALIGN=‘right‘ class=‘awrc‘>40,635</TD> <TD ALIGN=‘right‘ class=‘awrc‘>21.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#aykvshm7zsabd‘>aykvshm7zsabd</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select size_for_estimate,...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>1,855</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>25,970</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>14.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#772s25v1y0x8k‘>772s25v1y0x8k</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select shared_pool_size_for_es...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1,680</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3,360</TD> <TD ALIGN=‘right‘ class=‘awrc‘>2.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#8p447s6p0rv6b‘>8p447s6p0rv6b</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select java_pool_size_for_esti...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>1,048</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#350f5yrnnmshs‘>350f5yrnnmshs</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>lock table sys.mon_mods$ in ex...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1,048</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1,028</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.98</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#g00cj285jmgsw‘>g00cj285jmgsw</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>update sys.mon_mods$ set inser...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>704</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>704</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#49s332uhbnsma‘>49s332uhbnsma</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘> declare
vsn va...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>583</TD> <TD ALIGN=‘right‘ class=‘awrc‘>583</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#5h7w8ykwtb2xt‘>5h7w8ykwtb2xt</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>INSERT INTO SYS.WRI$_ADV_PARAM...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>522</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>403</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.77</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#3c1kubcdjnppq‘>3c1kubcdjnppq</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>update sys.col_usage$ set eq...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>504</TD> <TD ALIGN=‘right‘ class=‘awrc‘>504</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrc‘>0.00</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#f9u3p2bz694dd‘>f9u3p2bz694dd</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select count(*) from sys.job$ ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>466</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>466</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>0.00</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#grwydz59pu6mc‘>grwydz59pu6mc</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select text from view$ where r...</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#22‘>Back to SQL Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘900‘></A>
<H3 class=‘awr‘>SQL ordered by Parse Calls</H3>
<UL>
<LI class=‘awr‘>Total Parse Calls: 8,895
<LI class=‘awr‘>Captured SQL account for 77.5% of Total
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Parse Calls</TH><TH class=‘awrbg‘>Executions </TH><TH class=‘awrbg‘>% Total Parses</TH><TH class=‘awrbg‘> SQL Id</TH><TH class=‘awrbg‘>SQL Module</TH><TH class=‘awrbg‘>SQL Text</TH></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>1,048</TD> <TD ALIGN=‘right‘ class=‘awrc‘>11.78</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#350f5yrnnmshs‘>350f5yrnnmshs</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>lock table sys.mon_mods$ in ex...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>1,048</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1,048</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>11.78</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#g00cj285jmgsw‘>g00cj285jmgsw</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>update sys.mon_mods$ set inser...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>704</TD> <TD ALIGN=‘right‘ class=‘awrc‘>704</TD> <TD ALIGN=‘right‘ class=‘awrc‘>7.91</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#49s332uhbnsma‘>49s332uhbnsma</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘> declare
vsn va...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>466</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>466</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>5.24</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#grwydz59pu6mc‘>grwydz59pu6mc</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select text from view$ where r...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>328</TD> <TD ALIGN=‘right‘ class=‘awrc‘>328</TD> <TD ALIGN=‘right‘ class=‘awrc‘>3.69</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#bsa0wjtftg3uw‘>bsa0wjtftg3uw</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select file# from file$ where ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>191</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>191</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>2.15</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#chsyr0gssbuqf‘>chsyr0gssbuqf</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select f.file#,f.block#,f....</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>171</TD> <TD ALIGN=‘right‘ class=‘awrc‘>522</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.92</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#3c1kubcdjnppq‘>3c1kubcdjnppq</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>update sys.col_usage$ set eq...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>171</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>119</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.92</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#53btfq0dt9bs9‘>53btfq0dt9bs9</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>insert into sys.col_usage$ val...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>171</TD> <TD ALIGN=‘right‘ class=‘awrc‘>171</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.92</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#b2gnxm5z6r51n‘>b2gnxm5z6r51n</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>lock table sys.col_usage$ in e...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>168</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>168</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.89</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#7mvdhsu3d43ag‘>7mvdhsu3d43ag</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select a.obj# OBJOID,a.class...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>107</TD> <TD ALIGN=‘right‘ class=‘awrc‘>107</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.20</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#g337099aatnuj‘>g337099aatnuj</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>update smon_scntime set orig...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>97</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>97</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.09</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#a1xgxtssv5rrp‘>a1xgxtssv5rrp</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select sum(used_blocks),ts.t...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>94</TD> <TD ALIGN=‘right‘ class=‘awrc‘>94</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.06</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#0h6b2sajwb74n‘>0h6b2sajwb74n</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select privilege#,level from ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrnc‘>89</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>89</TD> <TD ALIGN=‘right‘ class=‘awrnc‘>1.00</TD> <TD class=‘awrnc‘><A class=‘awr‘ HREF=‘#8swypbbr0m372‘>8swypbbr0m372</A></TD>
<TD class=‘awrnc‘>?
</TD>
<TD class=‘awrnc‘>select order#,columns,types ...</TD></TR>
<TR><TD ALIGN=‘right‘ class=‘awrc‘>89</TD> <TD ALIGN=‘right‘ class=‘awrc‘>89</TD> <TD ALIGN=‘right‘ class=‘awrc‘>1.00</TD> <TD class=‘awrc‘><A class=‘awr‘ HREF=‘#cqgv56fmuj63x‘>cqgv56fmuj63x</A></TD>
<TD class=‘awrc‘>?
</TD>
<TD class=‘awrc‘>select owner#,name,namespace...</TD></TR>
</TABLE><P>
<A class=‘awr‘ HREF=‘#22‘>Back to SQL Statistics</A>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<A class=‘awr‘ NAME=‘1000‘></A>
</TABLE><P>
<H3 class=‘awr‘>SQL ordered by Sharable Memory</H3>
（编辑：核心网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
