<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;} td.awrnclb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;} td.awrncbb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;border-right: thin solid black;} td.awrncrb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-right: thin solid black;} td.awrcrb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-right: thin solid black;} td.awrclb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-left: thin solid black;} td.awrcbb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-left: thin solid black;border-right: thin solid black;} a.awr {font:bold 8pt Arial,Helvetica,sans-serif;color:#663300; vertical-align:top;margin-top:0pt; margin-bottom:0pt;} td.awrnct {font:8pt Arial,Helvetica,Geneva,sans-serif;border-top: thin solid black;color:black;background:White;vertical-align:top;} td.awrct {font:8pt Arial,Helvetica,Geneva,sans-serif;border-top: thin solid black;color:black;background:#FFFFCC; vertical-align:top;} td.awrnclbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-top: thin solid black;border-left: thin solid black;} td.awrncbbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;border-right: thin solid black;border-top: thin solid black;} td.awrncrbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-top: thin solid black;border-right: thin solid black;} td.awrcrbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-right: thin solid black;} td.awrclbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-left: thin solid black;} td.awrcbbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-left: thin solid black;border-right: thin solid black;} table.tdiff { border_collapse: collapse; } </style></head><body class="awr"> <h1 class="awr"> Database Capture Report For ORCL </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'>ORCL</td><td align="right" class='awrnc'>1219369657</td><td class='awrnc'>11.2.0.1.0</td><td class='awrnc'>NO</td><td class='awrnc'>capturegrid1</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'>09-Jul-09 06:32:35 (SCN = 1669036)</td></tr> <tr><td class='awrnc'>End time:</td><td align="right" class='awrnc'>09-Jul-09 06:36:12 (SCN = 1675079)</td></tr> <tr><td class='awrc'>Duration:</td><td align="right" class='awrc'>3 minutes 37 seconds</td></tr> <tr><td class='awrnc'>Capture size:</td><td align="right" class='awrnc'>900.28 KB</td></tr> <tr><td class='awrc'>Directory object:</td><td align="right" class='awrc'>DBREPLAY</td></tr> <tr><td class='awrnc'>Directory path:</td><td align="right" class='awrnc'>/home/oracle/solutions/dbreplay</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> </table> <p /> <a class="awr" name="top"></a> <h2 class="awr"> DB Capture Report </h2> <ul> <li class="awr"><a class="awr" href="#11001">Capture Statistics</a></li> <li class="awr"><a class="awr" href="#502">Workload Captured</a></li> <li class="awr"><a class="awr" href="#503">Workload Not Captured - Contains Unreplayable Calls</a></li> <li class="awr"><a class="awr" href="#504">Workload Not Captured - User Filtered</a></li> <li class="awr"><a class="awr" href="#505">Workload Not Captured - DB Scheduler Jobs and Background Activity</a></li> <li class="awr"><a class="awr" href="#99997">SQL Text</a></li> <li class="awr"><a class="awr" href="#11002">Workload Filters</a></li> </ul> <br /><a class="awr" href="#top">Back to Top</a><hr /><p /> <a class="awr" name="11001"></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> <li class="awr"> '% Total' is the percentage of 'Value' over the corresponding system-wide aggregated total.</li> </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'>6.89</td><td align="right" class='awrc'>70.31</td></tr> <tr><td class='awrnc'>Average Active Sessions</td><td align="right" class='awrnc'>0.03</td><td align="right" class='awrnc'>&#160;</td></tr> <tr><td class='awrc'>User calls captured</td><td align="right" class='awrc'>4300</td><td align="right" class='awrc'>81.04</td></tr> <tr><td class='awrnc'>User calls captured with Errors</td><td align="right" class='awrnc'>0</td><td align="right" class='awrnc'>&#160;</td></tr> <tr><td class='awrc'>Session logins</td><td align="right" class='awrc'>11</td><td align="right" class='awrc'>52.38</td></tr> <tr><td class='awrnc'>Transactions</td><td align="right" class='awrnc'>2100</td><td align="right" class='awrnc'>96.69</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="#11101">Top Events Captured</a></li> <li class="awr"><a class="awr" href="#11102">Top Service/Module Captured</a></li> <li class="awr"><a class="awr" href="#11103">Top SQL Captured</a></li> <li class="awr"><a class="awr" href="#11104">Top Sessions Captured</a></li> </ul> <a class="awr" href="#top">Back to Top</a><p /> <a class="awr" name="11101"></a> <h3 class="awr">Top Events Captured</h3> <p /> No data exists for this section of the report. <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="11102"></a> <h3 class="awr">Top Service/Module Captured</h3> <p /> No data exists for this section of the report. <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="11103"></a> <h3 class="awr">Top SQL Captured</h3> <p /> No data exists for this section of the report. <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="11104"></a> <h3 class="awr">Top Sessions Captured</h3> <p /> No data exists for this section of the report. <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="#11201">Top Events containing Unreplayable Calls</a></li> <li class="awr"><a class="awr" href="#11202">Top Service/Module containing Unreplayable Calls</a></li> <li class="awr"><a class="awr" href="#11203">Top SQL containing Unreplayable Calls</a></li> <li class="awr"><a class="awr" href="#11204">Top Sessions containing Unreplayable Calls</a></li> </ul> <a class="awr" href="#top">Back to Top</a><p /> <a class="awr" name="11201"></a> <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="11202"></a> <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="11203"></a> <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="11204"></a> <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="#11301">Top Events Filtered Out</a></li> <li class="awr"><a class="awr" href="#11302">Top Service/Module Filtered Out</a></li> <li class="awr"><a class="awr" href="#11303">Top SQL Filtered Out</a></li> <li class="awr"><a class="awr" href="#11304">Top Sessions Filtered Out</a></li> </ul> <a class="awr" href="#top">Back to Top</a><p /> <a class="awr" name="11301"></a> <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="11302"></a> <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="11303"></a> <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="11304"></a> <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="#11401">Top Events (Jobs and Background Activity)</a></li> <li class="awr"><a class="awr" href="#11402">Top Service/Module (Jobs and Background Activity)</a></li> <li class="awr"><a class="awr" href="#11403">Top SQL (Jobs and Background Activity)</a></li> <li class="awr"><a class="awr" href="#11404">Top Sessions (Jobs and Background Activity)</a></li> </ul> <a class="awr" href="#top">Back to Top</a><p /> <a class="awr" name="11401"></a> <h3 class="awr">Top Events (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="11402"></a> <h3 class="awr">Top Service/Module (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="11403"></a> <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="11404"></a> <h3 class="awr">Top Sessions (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 /> <p /> <a class="awr" name="99997"></a> <p /> <h3 class="awr">Complete List of SQL Text</h3><p /> <p /> No data exists for this section of the report. <p /> <br /><a class="awr" href="#top">Back to Top</a><p /> <p /> <a class="awr" name="11002"></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>