Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\database\em2go\instance\sql\sqlStatistics.jsp

<%@ include file="/sdk/oemTop.jspf" %>
<%@ taglib uri="http://xmlns.oracle.com/uix/ui" prefix="uix" %>
<%@ taglib uri="http://xmlns.oracle.com/oem/jsp/tag" prefix="oem" %>
<%@ taglib uri="http://xmlns.oracle.com/oem/jsp/tag/db" prefix="db" %>

<uix:renderingContext id="renderingContext">

<uix:bundle name="sqlMsg"
            class="oracle.sysman.db.rsc.inst.SQLMsg"/>
  <oem:setURLEncoder id="renderingContext"/>
<%@ include file="/em2go/em2goHrGlobal.jspf" %>  
  <uix:document>

<uix:body>

<%@ include file="/em2go/em2goBreadCrumbs.jspf" %>

<uix:header textBinding="header@sqlObjectBean@servletRequest" >

<uix:stackLayout>

<uix:tableLayout width="100%">
              <uix:rowLayout hAlign="left">
                <uix:cellFormat>
                  <uix:rowLayout>
                    <uix:spacer height="10"/>
                  </uix:rowLayout>
                </uix:cellFormat>
              </uix:rowLayout>                        
              <uix:rowLayout hAlign="left">
                <uix:cellFormat>
                  <uix:rowLayout>
                    <uix:styledText styleClass="OraHeaderSubSub" 
                    text="SQL Statistics"/>          
                  </uix:rowLayout>
                </uix:cellFormat>
              </uix:rowLayout>            
              <uix:rowLayout hAlign="left">
                <uix:cellFormat>
                  <uix:rowLayout>
                    <uix:styledText styleClass="OraInlineInfoText"
                          textBinding="lastUpdatedTime@sqlObjectBean@servletRequest"/>
                  </uix:rowLayout>
                </uix:cellFormat>
              </uix:rowLayout>
            </uix:tableLayout>

<uix:tableLayout width="100%">
            
              <uix:rowLayout>
                <uix:cellFormat hAlign="left">
                  <uix:textInput name="sqlText"
                                 textBinding="formatedSqlText@sqlObjectBean@servletRequest"
                                 readOnly="true"
                                 columns="120"
                                 rows="10"
                                 />

</uix:cellFormat>
              </uix:rowLayout>
            </uix:tableLayout>

<%--          <uix:tableLayout>
             <uix:rowLayout>       
          
             <uix:switcher childNameBinding="statisticsExisted@sqlObjectBean@servletRequest">
                         <uix:case name="true">
                           
    --%>
             <uix:tableLayout width="100%" cellSpacing="2">

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                       <uix:styledText styleClass="OraHeaderSubSub" 
			textBinding="GENERAL@DBMsgBundle@servletRequest"/>
                       </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                      </uix:cellFormat>
                      </uix:rowLayout>

<uix:switcher childNameBinding="8i@sqlObjectBean@servletRequest">
                                
                                <uix:case name="false">
                                <uix:rowLayout>
                                  <uix:cellFormat hAlign="right" wrappingDisabled="true">
                                      <uix:styledText styleClass="OraPromptText"
                                        textBinding="NUMBER_OF_PLANS@sqlMsg"/>
                                  </uix:cellFormat>
                                  <uix:spacer width="8"/>
                                  <uix:cellFormat hAlign="left" wrappingDisabled="true">
                                    <uix:styledText styleClass="OraDataText"
                                      textBinding="numberOfPlans@sqlBean@servletRequest"/>
                                  </uix:cellFormat>
                                </uix:rowLayout>
                                </uix:case>
                                
                                <uix:case name="true">
                                <uix:rowLayout>
                                  <uix:cellFormat hAlign="right" wrappingDisabled="true">
                                      <uix:styledText styleClass="OraPromptText"
                                        textBinding="NUMBER_CHILD_CUROSR@sqlMsg"/>
                                  </uix:cellFormat>
                                  <uix:spacer width="8"/>
                                  <uix:cellFormat hAlign="left" wrappingDisabled="true">
                                    <uix:styledText styleClass="OraDataText"
                                      textBinding="numberOfChildCursors@sqlBean@servletRequest"/>
                                  </uix:cellFormat>
                                </uix:rowLayout>
                                </uix:case>
                                
                        </uix:switcher>

<uix:switcher childNameBinding="SWRF@sqlObjectBean@servletRequest">
                         <uix:case name="true">
                                <uix:rowLayout>
                                  <uix:cellFormat hAlign="right" wrappingDisabled="true">
                                      <uix:styledText styleClass="OraPromptText"
                                        textBinding="PROGRAM_NAME_LINE_NUM@sqlMsg"/>
                                  </uix:cellFormat>
                        
                                  <uix:spacer width="8"/>
                                  
                                  <uix:cellFormat hAlign="left" wrappingDisabled="true">
                                    <uix:switcher childNameBinding="programNameAndLineNumberExisted@sqlObjectBean@servletRequest">
                                     <uix:case name="true">
                                       <uix:styledText styleClass="OraDataText"
                                           textBinding="programNameAndLineNumber@sqlObjectBean@servletRequest"/>
                                     </uix:case>
                                     <uix:case name="false">
                                       <uix:styledText styleClass="OraDataText"
                                           textBinding="programNameAndLineNumber@sqlObjectBean@servletRequest"/>
                                     </uix:case>
                                   </uix:switcher>
                                  </uix:cellFormat>
                                  
                                </uix:rowLayout>
                        </uix:case>
                       </uix:switcher>

<uix:spacer width="8"/>
                                  <uix:cellFormat hAlign="left" wrappingDisabled="true">
                            <uix:switcher childNameBinding="sqlProfileFound@sqlObjectBean@servletRequest">
                                <uix:case name="true">
                                <uix:submitButton textBinding="DROP@DBMsgBundle@servletRequest"
                                          name="event"
                                          value="dropSqlProfile" />
                                 </uix:case>
                            </uix:switcher>
                                  </uix:cellFormat>
                                </uix:rowLayout>
                        </uix:case>
                       </uix:switcher>

<uix:spacer width="8"/>
                                  <uix:cellFormat hAlign="left" wrappingDisabled="true">
                            <uix:switcher childNameBinding="sqlProfileStatus@sqlBean@servletRequest">
                                <uix:case name="ENABLED">
                                <uix:submitButton textBinding="DISABLE@DBMsgBundle@servletRequest"
                                          name="event"
                                          value="disableSqlProfile" />
                                 </uix:case>
                                <uix:case name="DISABLED">
                                <uix:submitButton textBinding="ENABLE@DBMsgBundle@servletRequest"
                                          name="event"
                                          value="enableSqlProfile" />
                                 </uix:case>
                            </uix:switcher>
                                  </uix:cellFormat>
                            </uix:rowLayout>
                        </uix:case>
                       </uix:switcher>

<uix:spacer width="8"/>
                          </uix:rowLayout>
                        </uix:case>
                       </uix:switcher>

<%--
                     </uix:rowLayout>
                     </uix:tableLayout>
                 </uix:stackLayout>
               </uix:cellFormat>
             </uix:rowLayout>  
                     --%>

<%--

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                      <uix:styledText styleClass="OraHeaderSubSub" 
			textBinding="GENERAL@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="PARSE_SCHEMA@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="parsingSchema@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="MODULE@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="module@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="ACTION@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="action@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="OPTIMIZER_MODE@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="optimizerMode@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="SQL_PROFILE@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="hintsetApplied@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

--%>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="false">
                      <uix:styledText styleClass="OraHeaderSubSub" 
			textBinding="TIME_MODEL@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="false">
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="false">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="ELAPSED_TIME_PER_EXEC@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="false">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="elapsedTimeInSecPerExec@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="false">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="CPU_TIME_PER_EXEC@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="false">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="cpuTimeInSecPerExec@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="WAIT_RATIO@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="waitRatio@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                      <uix:styledText styleClass="OraHeaderSubSub" 
			textBinding="EXECUTION_STATISTICS@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="EXECUTIONS@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="executions@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="TSQL_PARSE_CALLS@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="parseCalls@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="ROWS_PER_FETCH@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="rowsPerFetch@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="ROWS_PER_EXEC@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="rowsPerExec@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="false">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="EXEC_PER_PARSE@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="false">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="execPerParse@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="false">
                      <uix:styledText styleClass="OraHeaderSubSub" 
			textBinding="SHARED_POOL_STATISTICS@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="false">
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="false">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="TSQL_SHARE_MEM@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="false">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="sharableMem@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="TSQL_LOADS@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="loads@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="LAST_LOAD_TIME@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="lastLoadTime@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

<uix:rowLayout>
                      <uix:cellFormat hAlign="right" wrappingDisabled="true">
                          <uix:styledText styleClass="OraPromptText"
                            textBinding="SQL_INVALIDATIONS@DBMsgBundle@servletRequest"/>
                      </uix:cellFormat>
                      <uix:spacer width="8"/>
                      <uix:cellFormat hAlign="left" wrappingDisabled="true">
                        <uix:styledText styleClass="OraDataText"
                          textBinding="invalidations@sqlBean@servletRequest"/>
                      </uix:cellFormat>
                    </uix:rowLayout>

</uix:tableLayout>

</uix:stackLayout>

</uix:header>

</uix:body>
  </uix:document>

<%@ include file="/em2go/em2goThinFooter.jspf" %>

</uix:renderingContext>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de