<HTML><HEAD><TITLE>Database Capture 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,Helvetica,Geneva,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,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;} h3.awr {font:bold 16pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}li.awr {font: 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;} th.awrnobg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;padding-left:4px; padding-right:4px;padding-bottom:2px}th.awrbg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:White; background:#0066CC;padding-left:4px; padding-right:4px;padding-bottom:2px} td.awrnc {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;} td.awrc {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;}a.awr {font:bold 8pt Arial,Helvetica,sans-serif;color:#663300; vertical-align:top;margin-top:0pt; margin-bottom:0pt;} </style></HEAD><BODY class='awr'> <h1 class='awr'> Database Capture Report For DB10G </h1> <P> <TABLE BORDER=1 WIDTH=500> <TR><TH class='awrbg'>DB Name</TH><TH class='awrbg'>DB Id</TH><TH class='awrbg'>Release</TH><TH class='awrbg'>RAC</TH><TH class='awrbg'>Capture Name</TH><TH class='awrbg'>Status</TH></TR> <TR><TD class='awrnc'>DB10G</TD><TD ALIGN='right' class='awrnc'>33332549</TD><TD class='awrnc'>10.2.0.4.0</TD><TD class='awrnc'>NO</TD><TD class='awrnc'>DBR_CAPTURE_100</TD><TD class='awrnc'>COMPLETED</TD></TR> </TABLE> <P> <P> <TABLE BORDER=1> <TR><TH class='awrbg'>Information</TH><TH class='awrbg'>Capture</TH></TR> <TR><TD class='awrc'>Start time:</TD><TD ALIGN='right' class='awrc'>23-Jun-08 23:26:25 (SCN = 983513)</TD></TR> <TR><TD class='awrnc'>End time:</TD><TD ALIGN='right' class='awrnc'>23-Jun-08 23:32:35 (SCN = 988306)</TD></TR> <TR><TD class='awrc'>Duration:</TD><TD ALIGN='right' class='awrc'>6 minutes 10 seconds</TD></TR> <TR><TD class='awrnc'>Capture size:</TD><TD ALIGN='right' class='awrnc'>338.08 KB</TD></TR> <TR><TD class='awrc'>Directory object:</TD><TD ALIGN='right' class='awrc'>DBRCONTROL</TD></TR> <TR><TD class='awrnc'>Directory path:</TD><TD ALIGN='right' class='awrnc'>/home/oracle/DBRControl</TD></TR> <TR><TD class='awrc'>Directory shared in RAC:</TD><TD ALIGN='right' class='awrc'>TRUE</TD></TR> <TR><TD class='awrnc'>Filters used:</TD><TD ALIGN='right' class='awrnc'>2 EXCLUSION filters</TD></TR> <TR><TD class='awrc'>Error code:</TD><TD ALIGN='right' class='awrc'>&nbsp;</TD></TR> <TR><TD class='awrnc'>Error message:</TD><TD ALIGN='right' class='awrnc'>Termination (after 90 seconds)</TD></TR> </TABLE> <P> <A class='awr' NAME='top'></A> <H2 class='awr'> DB Capture Report </H2> <UL> <LI class='awr'><A class='awr' HREF='#50001'>Capture Statistics</A> <LI class='awr'><A class='awr' HREF='#502'>Workload Captured</A> <LI class='awr'><A class='awr' HREF='#503'>Workload Not Captured - Contains Unreplayable Calls</A> <LI class='awr'><A class='awr' HREF='#504'>Workload Not Captured - User Filtered</A> <LI class='awr'><A class='awr' HREF='#505'>Workload Not Captured - DB Scheduler Jobs and Background Activity</A> <LI class='awr'><A class='awr' HREF='#99997'>SQL Text</A> <LI class='awr'><A class='awr' HREF='#50002'>Workload Filters</A> </UL> <BR><A class='awr' HREF='#top'>Back to Top</A><HR><P> <A class='awr' NAME='50001'></A> <H3 class='awr'>Captured Workload Statistics</H3> <UL> <LI class='awr'> 'Value' represents the corresponding statistic aggregated across the entire captured database workload. <LI class='awr'> '% Total' is the percentage of 'Value' over the corresponding system-wide aggregated total. </UL> <TABLE BORDER=1><TR><TH class='awrbg'>Statistic Name</TH><TH class='awrbg'>Value</TH><TH class='awrbg'>% Total</TH></TR> <TR><TD class='awrc'>DB time (secs)</TD> <TD ALIGN='right' class='awrc'>812.67</TD> <TD ALIGN='right' class='awrc'>99.91</TD></TR> <TR><TD class='awrnc'>Average Active Sessions</TD> <TD ALIGN='right' class='awrnc'>2.20</TD> <TD ALIGN='right' class='awrnc'>&nbsp;</TD></TR> <TR><TD class='awrc'>User calls captured</TD> <TD ALIGN='right' class='awrc'>1844</TD> <TD ALIGN='right' class='awrc'>100.00</TD></TR> <TR><TD class='awrnc'>User calls captured with Errors</TD> <TD ALIGN='right' class='awrnc'>0</TD> <TD ALIGN='right' class='awrnc'>&nbsp;</TD></TR> <TR><TD class='awrc'>Session logins</TD> <TD ALIGN='right' class='awrc'>80</TD> <TD ALIGN='right' class='awrc'>90.91</TD></TR> <TR><TD class='awrnc'>Transactions</TD> <TD ALIGN='right' class='awrnc'>1365</TD> <TD ALIGN='right' class='awrnc'>97.01</TD></TR> </TABLE><P> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <P> <A class='awr' NAME='502'></A> <H2 class='awr'> Workload Captured </H2> <UL> <LI class='awr'><A class='awr' HREF='#50101'> Top Events Captured </A> <LI class='awr'><A class='awr' HREF='#50102'> Top Service/Module Captured </A> <LI class='awr'><A class='awr' HREF='#50103'> Top SQL Captured </A> <LI class='awr'><A class='awr' HREF='#50104'> Top Sessions Captured </A> </UL> <A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50101'></A> <H3 class='awr'>Top Events Captured</H3> <UL> </UL> <TABLE BORDER=1><TR><TH class='awrbg'>Event</TH><TH class='awrbg'>Event Class</TH><TH class='awrbg'>% Activity</TH><TH class='awrbg'>Avg Active Sessions</TH></TR> <TR><TD class='awrc'>CPU + Wait for CPU</TD> <TD class='awrc'>CPU</TD> <TD ALIGN='right' class='awrc'>82.76</TD> <TD ALIGN='right' class='awrc'>1.96</TD></TR> <TR><TD class='awrnc'>buffer deadlock</TD> <TD class='awrnc'>Other</TD> <TD ALIGN='right' class='awrnc'>5.37</TD> <TD ALIGN='right' class='awrnc'>0.13</TD></TR> <TR><TD class='awrc'>latch: cache buffers chains</TD> <TD class='awrc'>Concurrency</TD> <TD ALIGN='right' class='awrc'>2.63</TD> <TD ALIGN='right' class='awrc'>0.06</TD></TR> <TR><TD class='awrnc'>log file switch completion</TD> <TD class='awrnc'>Configuration</TD> <TD ALIGN='right' class='awrnc'>1.71</TD> <TD ALIGN='right' class='awrnc'>0.04</TD></TR> <TR><TD class='awrc'>buffer busy waits</TD> <TD class='awrc'>Concurrency</TD> <TD ALIGN='right' class='awrc'>1.48</TD> <TD ALIGN='right' class='awrc'>0.04</TD></TR> </TABLE><P> <A class='awr' HREF='#502'>Back to Workload Captured</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50102'></A> <H3 class='awr'>Top Service/Module Captured</H3> <UL> </UL> <TABLE BORDER=1><TR><TH class='awrbg'>Service</TH><TH class='awrbg'>Module</TH><TH class='awrbg'>% Activity</TH><TH class='awrbg'>Action</TH><TH class='awrbg'>% Action</TH></TR> <TR><TD class='awrc'>db10g</TD> <TD class='awrc'>LoadGenerator</TD> <TD ALIGN='right' class='awrc'>94.52</TD> <TD class='awrc'>BuildInvoiceDetail</TD> <TD ALIGN='right' class='awrc'>89.50</TD></TR> <TR><TD class='awrnc'>&nbsp;</TD> <TD class='awrnc'>&nbsp;</TD> <TD ALIGN='right' class='awrnc'>&nbsp;</TD> <TD class='awrnc'>BuildInvoices</TD> <TD ALIGN='right' class='awrnc'>3.54</TD></TR> <TR><TD class='awrc'>&nbsp;</TD> <TD class='awrc'>&nbsp;</TD> <TD ALIGN='right' class='awrc'>&nbsp;</TD> <TD class='awrc'>SpinCPUs</TD> <TD ALIGN='right' class='awrc'>1.48</TD></TR> </TABLE><P> <A class='awr' HREF='#502'>Back to Workload Captured</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50103'></A> <H3 class='awr'>Top SQL Captured</H3> <UL> </UL> <TABLE BORDER=1><TR><TH class='awrbg'>SQL ID</TH><TH class='awrbg'>% Activity</TH><TH class='awrbg'>Event</TH><TH class='awrbg'>% Event</TH><TH class='awrbg'>SQL Text</TH></TR> <TR><TD ALIGN='right' class='awrc'><A class='awr' HREF='#1dmv3vasxtjtu'>1dmv3vasxtjtu</A></TD> <TD ALIGN='right' class='awrc'>17.81</TD> <TD class='awrc'>CPU + Wait for CPU</TD> <TD ALIGN='right' class='awrc'>8.22</TD> <TD class='awrc'>INSERT INTO AP.INVOICE_ITEMS (...</TD></TR> <TR><TD ALIGN='right' class='awrnc'>&nbsp;</TD> <TD ALIGN='right' class='awrnc'>&nbsp;</TD> <TD class='awrnc'>buffer deadlock</TD> <TD ALIGN='right' class='awrnc'>4.79</TD> <TD class='awrnc'></TD></TR> <TR><TD ALIGN='right' class='awrc'>&nbsp;</TD> <TD ALIGN='right' class='awrc'>&nbsp;</TD> <TD class='awrc'>latch: cache buffers chains</TD> <TD ALIGN='right' class='awrc'>2.63</TD> <TD class='awrc'></TD></TR> <TR><TD ALIGN='right' class='awrnc'><A class='awr' HREF='#9qqv0czupcx22'>9qqv0czupcx22</A></TD> <TD ALIGN='right' class='awrnc'>17.58</TD> <TD class='awrnc'>CPU + Wait for CPU</TD> <TD ALIGN='right' class='awrnc'>17.58</TD> <TD class='awrnc'>BEGIN AP.PKG_LOAD_GENERATO...</TD></TR> <TR><TD ALIGN='right' class='awrc'><A class='awr' HREF='#9cz4yg1a8m2km'>9cz4yg1a8m2km</A></TD> <TD ALIGN='right' class='awrc'>13.93</TD> <TD class='awrc'>CPU + Wait for CPU</TD> <TD ALIGN='right' class='awrc'>13.93</TD> <TD class='awrc'>BEGIN AP.PKG_LOAD_GENERATO...</TD></TR> <TR><TD ALIGN='right' class='awrnc'><A class='awr' HREF='#5jzk6sd0qjafm'>5jzk6sd0qjafm</A></TD> <TD ALIGN='right' class='awrnc'>13.24</TD> <TD class='awrnc'>CPU + Wait for CPU</TD> <TD ALIGN='right' class='awrnc'>13.24</TD> <TD class='awrnc'>BEGIN AP.PKG_LOAD_GENERATO...</TD></TR> <TR><TD ALIGN='right' class='awrc'><A class='awr' HREF='#45cd1yp2y379a'>45cd1yp2y379a</A></TD> <TD ALIGN='right' class='awrc'>10.73</TD> <TD class='awrc'>CPU + Wait for CPU</TD> <TD ALIGN='right' class='awrc'>10.73</TD> <TD class='awrc'>BEGIN AP.PKG_LOAD_GENERATO...</TD></TR> </TABLE><P> <A class='awr' HREF='#502'>Back to Workload Captured</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50104'></A> <H3 class='awr'>Top Sessions Captured</H3> <UL> <LI class='awr'> '# Samples Active' shows the number of ASH samples in which the session was found waiting for that particular event. The percentage shown in this column is calculated with respect to wall clock time and not total database activity. <LI class='awr'> 'XIDs' shows the number of distinct transaction IDs sampled in ASH when the session was waiting for that particular event <LI class='awr'> For sessions running Parallel Queries, this section will NOT aggregate the PQ slave activity into the session issuing the PQ. Refer to the 'Top Sessions running PQs' section for such statistics. </UL> <TABLE BORDER=1><TR><TH class='awrbg'>Sid, Serial#</TH><TH class='awrbg'>% Activity</TH><TH class='awrbg'>Event</TH><TH class='awrbg'>% Event</TH><TH class='awrbg'>User</TH><TH class='awrbg'>Program</TH><TH class='awrbg'># Samples Active</TH><TH class='awrbg'>XIDs</TH></TR> <TR><TD ALIGN='right' class='awrc'>148, 29</TD> <TD ALIGN='right' class='awrc'>9.02</TD> <TD class='awrc'>CPU + Wait for CPU</TD> <TD ALIGN='right' class='awrc'>8.22</TD> <TD class='awrc'>OE</TD> <TD class='awrc'>sqlplus@11gR1NF (TNS V1-V3)</TD> <TD ALIGN='right' class='awrc'>72/370 [ 19%]</TD> <TD ALIGN='right' class='awrc'>41</TD></TR> <TR><TD ALIGN='right' class='awrnc'>144, 65</TD> <TD ALIGN='right' class='awrnc'>7.99</TD> <TD class='awrnc'>CPU + Wait for CPU</TD> <TD ALIGN='right' class='awrnc'>6.16</TD> <TD class='awrnc'>OE</TD> <TD class='awrnc'>sqlplus@11gR1NF (TNS V1-V3)</TD> <TD ALIGN='right' class='awrnc'>54/370 [ 15%]</TD> <TD ALIGN='right' class='awrnc'>38</TD></TR> <TR><TD ALIGN='right' class='awrc'>&nbsp;</TD> <TD ALIGN='right' class='awrc'>&nbsp;</TD> <TD class='awrc'>buffer deadlock</TD> <TD ALIGN='right' class='awrc'>1.03</TD> <TD class='awrc'>&nbsp;</TD> <TD class='awrc'>&nbsp;</TD> <TD ALIGN='right' class='awrc'>9/370 [ 2%]</TD> <TD ALIGN='right' class='awrc'>1</TD></TR> <TR><TD ALIGN='right' class='awrnc'>143, 37</TD> <TD ALIGN='right' class='awrnc'>7.65</TD> <TD class='awrnc'>CPU + Wait for CPU</TD> <TD ALIGN='right' class='awrnc'>6.39</TD> <TD class='awrnc'>HR</TD> <TD class='awrnc'>sqlplus@11gR1NF (TNS V1-V3)</TD> <TD ALIGN='right' class='awrnc'>56/370 [ 15%]</TD> <TD ALIGN='right' class='awrnc'>25</TD></TR> <TR><TD ALIGN='right' class='awrc'>&nbsp;</TD> <TD ALIGN='right' class='awrc'>&nbsp;</TD> <TD class='awrc'>log file switch completion</TD> <TD ALIGN='right' class='awrc'>1.26</TD> <TD class='awrc'>&nbsp;</TD> <TD class='awrc'>&nbsp;</TD> <TD ALIGN='right' class='awrc'>11/370 [ 3%]</TD> <TD ALIGN='right' class='awrc'>1</TD></TR> <TR><TD ALIGN='right' class='awrnc'>147, 214</TD> <TD ALIGN='right' class='awrnc'>5.48</TD> <TD class='awrnc'>CPU + Wait for CPU</TD> <TD ALIGN='right' class='awrnc'>5.48</TD> <TD class='awrnc'>OE</TD> <TD class='awrnc'>sqlplus@11gR1NF (TNS V1-V3)</TD> <TD ALIGN='right' class='awrnc'>48/370 [ 13%]</TD> <TD ALIGN='right' class='awrnc'>22</TD></TR> <TR><TD ALIGN='right' class='awrc'>137, 96</TD> <TD ALIGN='right' class='awrc'>5.25</TD> <TD class='awrc'>CPU + Wait for CPU</TD> <TD ALIGN='right' class='awrc'>4.79</TD> <TD class='awrc'>OE</TD> <TD class='awrc'>sqlplus@11gR1NF (TNS V1-V3)</TD> <TD ALIGN='right' class='awrc'>42/370 [ 11%]</TD> <TD ALIGN='right' class='awrc'>34</TD></TR> </TABLE><P> <A class='awr' HREF='#502'>Back to Workload Captured</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <P> <A class='awr' NAME='503'></A> <H2 class='awr'> Workload Not Captured - Contains Unreplayable Calls </H2> <UL> <LI class='awr'><A class='awr' HREF='#50201'> Top Events containing Unreplayable Calls </A> <LI class='awr'><A class='awr' HREF='#50202'> Top Service/Module containing Unreplayable Calls </A> <LI class='awr'><A class='awr' HREF='#50203'> Top SQL containing Unreplayable Calls </A> <LI class='awr'><A class='awr' HREF='#50204'> Top Sessions containing Unreplayable Calls </A> </UL> <A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50201'></A> </TABLE><P> <H3 class='awr'>Top Events containing Unreplayable Calls</H3> <P> No data exists for this section of the report. <P> <A class='awr' HREF='#503'>Back to Workload Not Captured - Contains Unreplayable Calls</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50202'></A> </TABLE><P> <H3 class='awr'>Top Service/Module containing Unreplayable Calls</H3> <P> No data exists for this section of the report. <P> <A class='awr' HREF='#503'>Back to Workload Not Captured - Contains Unreplayable Calls</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50203'></A> </TABLE><P> <H3 class='awr'>Top SQL containing Unreplayable Calls</H3> <P> No data exists for this section of the report. <P> <A class='awr' HREF='#503'>Back to Workload Not Captured - Contains Unreplayable Calls</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50204'></A> </TABLE><P> <H3 class='awr'>Top Sessions containing Unreplayable Calls</H3> <P> No data exists for this section of the report. <P> <A class='awr' HREF='#503'>Back to Workload Not Captured - Contains Unreplayable Calls</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <P> <A class='awr' NAME='504'></A> <H2 class='awr'> Workload Not Captured - User Filtered </H2> <UL> <LI class='awr'><A class='awr' HREF='#50301'> Top Events Filtered Out </A> <LI class='awr'><A class='awr' HREF='#50302'> Top Service/Module Filtered Out </A> <LI class='awr'><A class='awr' HREF='#50303'> Top SQL Filtered Out </A> <LI class='awr'><A class='awr' HREF='#50304'> Top Sessions Filtered Out </A> </UL> <A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50301'></A> </TABLE><P> <H3 class='awr'>Top Events Filtered Out</H3> <P> No data exists for this section of the report. <P> <A class='awr' HREF='#504'>Back to Workload Not Captured - User Filtered</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50302'></A> </TABLE><P> <H3 class='awr'>Top Service/Module Filtered Out</H3> <P> No data exists for this section of the report. <P> <A class='awr' HREF='#504'>Back to Workload Not Captured - User Filtered</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50303'></A> </TABLE><P> <H3 class='awr'>Top SQL Filtered Out</H3> <P> No data exists for this section of the report. <P> <A class='awr' HREF='#504'>Back to Workload Not Captured - User Filtered</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50304'></A> </TABLE><P> <H3 class='awr'>Top Sessions Filtered Out</H3> <P> No data exists for this section of the report. <P> <A class='awr' HREF='#504'>Back to Workload Not Captured - User Filtered</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <P> <A class='awr' NAME='505'></A> <H2 class='awr'> Workload Not Captured - DB Scheduler Jobs and Background Activity </H2> <UL> <LI class='awr'><A class='awr' HREF='#50401'> Top Events (Jobs and Background Activity) </A> <LI class='awr'><A class='awr' HREF='#50402'> Top Service/Module (Jobs and Background Activity) </A> <LI class='awr'><A class='awr' HREF='#50403'> Top SQL (Jobs and Background Activity) </A> <LI class='awr'><A class='awr' HREF='#50404'> Top Sessions (Jobs and Background Activity) </A> </UL> <A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50401'></A> <H3 class='awr'>Top Events (Jobs and Background Activity)</H3> <UL> </UL> <TABLE BORDER=1><TR><TH class='awrbg'>Event</TH><TH class='awrbg'>Event Class</TH><TH class='awrbg'>% Activity</TH><TH class='awrbg'>Avg Active Sessions</TH></TR> <TR><TD class='awrc'>log file parallel write</TD> <TD class='awrc'>System I/O</TD> <TD ALIGN='right' class='awrc'>2.63</TD> <TD ALIGN='right' class='awrc'>0.06</TD></TR> <TR><TD class='awrnc'>Log archive I/O</TD> <TD class='awrnc'>System I/O</TD> <TD ALIGN='right' class='awrnc'>1.26</TD> <TD ALIGN='right' class='awrnc'>0.03</TD></TR> </TABLE><P> <A class='awr' HREF='#505'>Back to Workload Not Captured - DB Scheduler Jobs and Background Activity</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50402'></A> <H3 class='awr'>Top Service/Module (Jobs and Background Activity)</H3> <UL> </UL> <TABLE BORDER=1><TR><TH class='awrbg'>Service</TH><TH class='awrbg'>Module</TH><TH class='awrbg'>% Activity</TH><TH class='awrbg'>Action</TH><TH class='awrbg'>% Action</TH></TR> <TR><TD class='awrc'>SYS$BACKGROUND</TD> <TD class='awrc'>UNNAMED</TD> <TD ALIGN='right' class='awrc'>5.14</TD> <TD class='awrc'>UNNAMED</TD> <TD ALIGN='right' class='awrc'>5.14</TD></TR> </TABLE><P> <A class='awr' HREF='#505'>Back to Workload Not Captured - DB Scheduler Jobs and Background Activity</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50403'></A> </TABLE><P> <H3 class='awr'>Top SQL (Jobs and Background Activity)</H3> <P> No data exists for this section of the report. <P> <A class='awr' HREF='#505'>Back to Workload Not Captured - DB Scheduler Jobs and Background Activity</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <A class='awr' NAME='50404'></A> <H3 class='awr'>Top Sessions (Jobs and Background Activity)</H3> <UL> <LI class='awr'> '# Samples Active' shows the number of ASH samples in which the session was found waiting for that particular event. The percentage shown in this column is calculated with respect to wall clock time and not total database activity. <LI class='awr'> 'XIDs' shows the number of distinct transaction IDs sampled in ASH when the session was waiting for that particular event <LI class='awr'> For sessions running Parallel Queries, this section will NOT aggregate the PQ slave activity into the session issuing the PQ. Refer to the 'Top Sessions running PQs' section for such statistics. </UL> <TABLE BORDER=1><TR><TH class='awrbg'>Sid, Serial#</TH><TH class='awrbg'>% Activity</TH><TH class='awrbg'>Event</TH><TH class='awrbg'>% Event</TH><TH class='awrbg'>User</TH><TH class='awrbg'>Program</TH><TH class='awrbg'># Samples Active</TH><TH class='awrbg'>XIDs</TH></TR> <TR><TD ALIGN='right' class='awrc'>166, 1</TD> <TD ALIGN='right' class='awrc'>2.63</TD> <TD class='awrc'>log file parallel write</TD> <TD ALIGN='right' class='awrc'>2.63</TD> <TD class='awrc'>SYS</TD> <TD class='awrc'>oracle@11gR1NF (LGWR)</TD> <TD ALIGN='right' class='awrc'>23/370 [ 6%]</TD> <TD ALIGN='right' class='awrc'>0</TD></TR> <TR><TD ALIGN='right' class='awrnc'>154, 1</TD> <TD ALIGN='right' class='awrnc'>1.83</TD> <TD class='awrnc'>Log archive I/O</TD> <TD ALIGN='right' class='awrnc'>1.26</TD> <TD class='awrnc'>SYS</TD> <TD class='awrnc'>oracle@11gR1NF (ARC0)</TD> <TD ALIGN='right' class='awrnc'>11/370 [ 3%]</TD> <TD ALIGN='right' class='awrnc'>0</TD></TR> </TABLE><P> <A class='awr' HREF='#505'>Back to Workload Not Captured - DB Scheduler Jobs and Background Activity</A> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <P> <A class='awr' NAME='99997'></A> <P> <H3 class='awr'>Complete List of SQL Text</H3><P> <TABLE BORDER=1> <TR><TH class='awrbg'>SQL Id</TH><TH class='awrbg'>SQL Text</TH></TR> <TR><TD class='awrc'><A class='awr' NAME='1dmv3vasxtjtu'></A>1dmv3vasxtjtu</TD><TD class='awrc'>INSERT INTO AP.INVOICE_ITEMS ( INVOICE_ID , LINE_ITEM_NBR , ACTIVE_IND , PRODUCT_ID , QTY , EXTENDED_AMT , TAXABLE_IND ) VALUES( :B6 , :B5 , 'Y' , :B4 , :B3 , :B2 , :B1 )</TD></TR> <TR><TD class='awrnc'><A class='awr' NAME='45cd1yp2y379a'></A>45cd1yp2y379a</TD><TD class='awrnc'>BEGIN AP.PKG_LOAD_GENERATOR.RandomDML(30); COMMIT; END;</TD></TR> <TR><TD class='awrc'><A class='awr' NAME='5jzk6sd0qjafm'></A>5jzk6sd0qjafm</TD><TD class='awrc'>BEGIN AP.PKG_LOAD_GENERATOR.RandomDML(75); COMMIT; END;</TD></TR> <TR><TD class='awrnc'><A class='awr' NAME='9cz4yg1a8m2km'></A>9cz4yg1a8m2km</TD><TD class='awrnc'>BEGIN AP.PKG_LOAD_GENERATOR.RandomDML(125); COMMIT; END;</TD></TR> <TR><TD class='awrc'><A class='awr' NAME='9qqv0czupcx22'></A>9qqv0czupcx22</TD><TD class='awrc'>BEGIN AP.PKG_LOAD_GENERATOR.RandomDML(50); COMMIT; END;</TD></TR> </TABLE> <P> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <P> <A class='awr' NAME='50002'></A> <H3 class='awr'>Workload Filters</H3> <UL> </UL> <TABLE BORDER=1><TR><TH class='awrbg'>#</TH><TH class='awrbg'>Filter Name</TH><TH class='awrbg'>Type </TH><TH class='awrbg'>Attribute </TH><TH class='awrbg'>Value</TH></TR> <TR><TD ALIGN='right' class='awrc'>1</TD> <TD class='awrc'>ORACLE MANAGEMENT AGENT (DEFAULT)</TD> <TD class='awrc'>EXCLUDE</TD> <TD class='awrc'>PROGRAM</TD> <TD class='awrc'>emagent%</TD></TR> <TR><TD ALIGN='right' class='awrnc'>2</TD> <TD class='awrnc'>ORACLE MANAGEMENT SERVICE (DEFAULT)</TD> <TD class='awrnc'>EXCLUDE</TD> <TD class='awrnc'>PROGRAM</TD> <TD class='awrnc'>OMS</TD></TR> </TABLE><P> <BR><A class='awr' HREF='#top'>Back to Top</A><P> <P> End of Report </BODY></HTML>