Edit D:\app\Administrator\product\11.2.0\dbhome_1\j2ee\OC4J_EM\applications\em\em\admin\rep\extendedSQLTrace.uix
<page xmlns="http://bali.us.oracle.com/cabo/baja" xmlns:baja="http://bali.us.oracle.com/cabo/baja" xmlns:marlin="http://bali.us.oracle.com/cabo/marlin" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:data="http://bali.us.oracle.com/cabo/marlin" xmlns:ui="http://xmlns.oracle.com/uix/ui"> <baja:head xmlns="http://www.w3.org/TR/REC-html40"> <title>Oracle Enterprise Manager Extended SQL Trace</title> </baja:head> <baja:content xmlns="http://bali.us.oracle.com/cabo/marlin"> <pageLayout> <globalButtons> <include baja:node="../../globalButtonBar" /> </globalButtons> <tabs> <include baja:node="../../globalTabs" /> </tabs> <pageHeader> <include baja:node="../../globalHeader" /> </pageHeader> <location> <include baja:node="../../breadCrumbs"/> </location> <copyright> <include baja:node="../../copyright"/> </copyright> <contents> <dataScope> <provider> <data name="extendedSQLTraceData"> <method class="oracle.sysman.eml.admin.rep.ExtendedSQLTrace" method="getTableData"/> </data> <data name="jobExtendedSQLTraceData"> <method class="oracle.sysman.eml.admin.rep.ExtendedSQLTrace" method="getJobTableData"/> </data> <data name="pingExtendedSQLTraceData"> <method class="oracle.sysman.eml.admin.rep.ExtendedSQLTrace" method="getPingTableData"/> </data> <data name="loaderExtendedSQLTraceData"> <method class="oracle.sysman.eml.admin.rep.ExtendedSQLTrace" method="getLoaderTableData"/> </data> <data name="rcaTraceData"> <method class="oracle.sysman.eml.admin.rep.ExtendedSQLTrace" method="getRcaData"/> </data> </provider> <contents> <stackLayout> <contents> <stackLayout> <contents> <spacer height="10"/> <header text="Current UI Extended SQL Trace state"> <contents> <spacer height="10"/> <table name="state" data:tableData="@extendedSQLTraceData"> <contents> <text data:text="firstColumnText"/> <text data:text="secondColumnText"/> </contents> </table> </contents> </header> <spacer height="30"/> <header text="New UI Extended SQL Trace state"> <contents> <spacer height="10"/> <form name="newState" method="GET"> <contents> <tableLayout cellPadding="2"> <contents> <rowLayout> <contents> <radioButton name="radioSelection" text="OFF" value="OFF" selected="true" /> </contents> </rowLayout> <rowLayout> <contents> <radioButton name="radioSelection" text="URL" value="URL" selected="false" /> <textInput name="URLText" columns="50" required="no" /> </contents> </rowLayout> <rowLayout> <contents> <radioButton name="radioSelection" text="RE" value="RE" selected="false" /> <textInput name="REPattern" columns="50" required="no" /> </contents> </rowLayout> <rowLayout> <contents> <radioButton name="radioSelection" text="ALL" value="ALL" selected="false" /> </contents> </rowLayout> <rowLayout> <contents> <submitButton formName="newState" event="change" text="change" value="change"/> </contents> </rowLayout> </contents> </tableLayout> </contents> </form> </contents> </header> <spacer height="30"/> <header text="UI Directions"> <contents> <stackLayout> <contents> <spacer height="10"/> <styledText text="Selecting ALL will generate extended sql trace for all ui pages" /> <styledText text="Selecting RE will generate extended sql trace for all ui pages that pattern match with the given regular expression" /> <styledText text="Selecting URL will generate extended sql trace for the specified url only" /> <styledText text="Selecting OFF will turn off extended sql trace" /> <spacer height="5"/> <styledText text="The extended sql trace generated will be located in the udump directory of the database" /> <styledText text="The file name will be of the following format: (SID)_ora_(PID)_(HASH).trc"/> <styledText text="The HASH value is outputted to the $ORACLE_HOME/opmn/logs/OC4J~OC4J_EM~default_island~1 file" /> <styledText text="The HASH entry in the above file will be of the form: HASH=(HASH VALUE) USER=(USERNAME) URL=(URL)"/> <styledText text="Find the hash value for your url and then locate the trc file"/> <styledText text="Then run tkprof on the file to generate a readable extended sql trace file"/> <spacer height="5"/> <styledText text="Extended SQL trace should be turned off when not in use as it will generate allot of trace files"/> </contents> </stackLayout> </contents> </header> </contents> </stackLayout> <spacer height="25"/> <separator/> <spacer height="25"/> <stackLayout> <contents> <header text="Current Job System Extended SQL Trace"> <contents> <spacer height="10"/> <table name="state" data:tableData="@jobExtendedSQLTraceData"> <contents> <text data:text="firstColumnText"/> <text data:text="secondColumnText"/> </contents> </table> </contents> </header> <spacer height="30"/> <header text="New Job Extended SQL Trace state"> <contents> <spacer height="10"/> <form name="newJobState" method="GET"> <contents> <tableLayout cellPadding="2"> <contents> <rowLayout> <contents> <radioButton name="jobRadioSelection" text="OFF" value="OFF" selected="true" /> </contents> </rowLayout> <rowLayout> <contents> <radioButton name="jobRadioSelection" text="ON" value="ON" selected="false" /> <textInput name="JobSeconds" columns="10" required="no" /> </contents> </rowLayout> <rowLayout> <contents> <submitButton formName="newJobState" event="jobChange" text="change" value="change"/> </contents> </rowLayout> </contents> </tableLayout> </contents> </form> </contents> </header> </contents> </stackLayout> <spacer height="25"/> <separator/> <spacer height="25"/> <stackLayout> <contents> <header text="Current Ping System Extended SQL Trace"> <contents> <spacer height="10"/> <table name="state" data:tableData="@pingExtendedSQLTraceData"> <contents> <text data:text="firstColumnText"/> <text data:text="secondColumnText"/> </contents> </table> </contents> </header> <spacer height="30"/> <header text="New Ping Extended SQL Trace state"> <contents> <spacer height="10"/> <form name="newPingState" method="GET"> <contents> <tableLayout cellPadding="2"> <contents> <rowLayout> <contents> <radioButton name="pingRadioSelection" text="OFF" value="OFF" selected="true" /> </contents> </rowLayout> <rowLayout> <contents> <radioButton name="pingRadioSelection" text="ON" value="ON" selected="false" /> <textInput name="PingSeconds" columns="10" required="no" /> </contents> </rowLayout> <rowLayout> <contents> <submitButton formName="newPingState" event="pingChange" text="change" value="change"/> </contents> </rowLayout> </contents> </tableLayout> </contents> </form> </contents> </header> </contents> </stackLayout> <spacer height="25"/> <separator/> <spacer height="25"/> <stackLayout> <contents> <header text="Current Loader System Extended SQL Trace"> <contents> <spacer height="10"/> <table name="state" data:tableData="@loaderExtendedSQLTraceData"> <contents> <text data:text="firstColumnText"/> <text data:text="secondColumnText"/> </contents> </table> </contents> </header> <spacer height="30"/> <header text="New Loader Extended SQL Trace state"> <contents> <spacer height="10"/> <form name="newLoaderState" method="GET"> <contents> <tableLayout cellPadding="2"> <contents> <rowLayout> <contents> <radioButton name="loaderRadioSelection" text="OFF" value="OFF" selected="true" /> </contents> </rowLayout> <rowLayout> <contents> <radioButton name="loaderRadioSelection" text="METADATA" value="metadata" selected="false" /> </contents> </rowLayout> <rowLayout> <contents> <radioButton name="loaderRadioSelection" text="SEVERITY" value="severity" selected="false" /> </contents> </rowLayout> <rowLayout> <contents> <radioButton name="loaderRadioSelection" text="DATA" value="data" selected="false" /> </contents> </rowLayout> <rowLayout> <contents> <radioButton name="loaderRadioSelection" text="ALL" value="ALL" selected="false" /> </contents> </rowLayout> <rowLayout> <contents> <submitButton formName="newLoaderState" event="loaderChange" text="change" value="change"/> </contents> </rowLayout> </contents> </tableLayout> </contents> </form> </contents> </header> </contents> </stackLayout> <spacer height="25"/> <separator/> <spacer height="25"/> <stackLayout> <contents> <header text="Root Cause Analysis System Extended SQL Trace"> <contents> <spacer height="10"/> <form name="newRcaState" method="GET"> <contents> <tableLayout cellPadding="2"> <contents> <rowLayout> <contents> <radioButton name="rcaRadioSelection" text="Disabled" value="OFF" selected="true" /> </contents> </rowLayout> <rowLayout> <contents> <radioButton name="rcaRadioSelection" text="Enabled for Severity GUID (blank for all)" value="ON" data:selected="rcaEnabled@rcaTraceData" /> <textInput name="RcaTraceContext" columns="40" required="no" data:text="rcaContext@rcaTraceData" /> </contents> </rowLayout> <rowLayout> <contents> <submitButton formName="newRcaState" event="rcaChange" text="Submit" value="change"/> </contents> </rowLayout> </contents> </tableLayout> </contents> </form> </contents> </header> </contents> </stackLayout> </contents> </stackLayout> </contents> </dataScope> </contents> </pageLayout> </baja:content> <handlers> <event name="change"> <method class="oracle.sysman.eml.admin.rep.ExtendedSQLTrace" method="doChange"/> </event> <event name="jobChange"> <method class="oracle.sysman.eml.admin.rep.ExtendedSQLTrace" method="doJobChange"/> </event> <event name="pingChange"> <method class="oracle.sysman.eml.admin.rep.ExtendedSQLTrace" method="doPingChange"/> </event> <event name="loaderChange"> <method class="oracle.sysman.eml.admin.rep.ExtendedSQLTrace" method="doLoaderChange"/> </event> <event name="rcaChange"> <method class="oracle.sysman.eml.admin.rep.ExtendedSQLTrace" method="doRcaChange"/> </event> </handlers> </page>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de