<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>
