Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\database\em2go\instance\sql\sqlStats.jsp
<%-- ================ SQL Statistics tab of SQL Details Page =================== MODIFIED (MM/DD/YY) yma 03/09/05 - update to 10.2 version yfeng 10/18/05 - use dbMsg instead of DBMsgBundle --%> <%@ 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"> <oem:setURLEncoder id="renderingContext"/> <uix:bundle name="dbMsg" class="oracle.sysman.db.rsc.inst.DBMsg"/> <uix:bundle name="sqlMsg" class="oracle.sysman.db.rsc.inst.SQLMsg"/> <%@ include file="/em2go/em2goHrGlobal.jspf" %> <uix:document> <uix:body> <%-- uix:pageLayout --%> <%@ include file="/em2go/em2goBreadCrumbs.jspf" %> <oem:messageBox messageType="error" errorTableBinding="errors@servletRequest" titleTextKey="titleText" mainTextKey="mainText"/> <oem:messageBox messageType="info" errorTableBinding="info@servletRequest" titleTextKey="titleText" mainTextKey="mainText"/> <oem:messageBox messageType="warning" errorTableBinding="intervalWarning@servletRequest" mainTextKey="exceptionText"/> <oem:messageBox messageType="error" errorTableBinding="intervalError@servletRequest" mainTextKey="exceptionText"/> <uix:rowLayout> <uix:contents> <uix:styledText styleClass="OraHeaderSubSub" textBinding="SQL_STATISTICS@dbMsg" /> </uix:contents> </uix:rowLayout> <uix:tableLayout width="100%" > <uix:rowLayout> <uix:cellFormat hAlign="right" vAlign = "top"> <uix:flowLayout> <uix:link textBinding="HDR_SQL_TEXT@dbMsg" destinationBinding="sqlTextDest@servletRequest"/> </uix:flowLayout> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> <uix:stackLayout renderedBinding="isStatsFound@sqlDetailUI@servletRequest" > <uix:tableLayout width="100%"> <uix:rowLayout width="100%"> <uix:cellFormat vAlign="top"> <%-- <uix:header textBinding="GENERAL@sqlMsg" size="2"> --%> <uix:tableLayout> <uix:rowLayout> <uix:contents> <uix:styledText styleClass="OraHeaderSubSub" textBinding="GENERAL@sqlMsg" /> </uix:contents> </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="MODULE@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="module@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout renderedBinding="isRT10@sqlDetailUI@servletRequest" > <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="ACTION@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="action@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout renderedBinding="isRT10@sqlDetailUI@servletRequest"> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="PARSING_SCHEMA@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="parsingSchema@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout renderedBinding="showUser@sqlDetailUI@servletRequest"> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="USER@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="parsingUser@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout renderedBinding="showPlsql@sqlDetailUI@servletRequest"> <uix:cellFormat wrappingDisabled="false" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="PLSQL_SOURCE@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="false" hAlign="left"> <uix:switcher childNameBinding="programNameAndLineNumberExisted@sqlDetailUI@servletRequest"> <uix:case name="true"> <uix:styledText styleClass="OraDataText" textBinding="programNameAndLineNumber@sqlDetailUI@servletRequest" /> </uix:case> <uix:case name="false"> <uix:styledText styleClass="OraDataText" textBinding="programNameAndLineNumber@sqlDetailUI@servletRequest" /> </uix:case> </uix:switcher> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout width="100%" renderedBinding="isVer90Higher@sqlDetailUI@servletRequest"> <uix:cellFormat vAlign="top"> <uix:tableLayout> <uix:rowLayout width="100%"> <uix:spacer height="5"/> </uix:rowLayout> <uix:rowLayout > <uix:contents> <uix:styledText styleClass="OraHeaderSubSub" textBinding="ACT_TIME@sqlMsg" /> </uix:contents> </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="ELAPSED_TIME@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="elapsedTime@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="CPU_TIME@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="cpuTime@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout > <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="WAIT_TIME@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="waitTime@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout width="100%" renderedBinding="isVer10Higher@sqlDetailUI@servletRequest"> <uix:cellFormat vAlign="top"> <uix:tableLayout> <uix:rowLayout width="100%"> <uix:spacer height="5"/> </uix:rowLayout> <uix:rowLayout > <uix:contents> <uix:styledText styleClass="OraHeaderSubSub" textBinding="ELAPSED_TIME_BD@sqlMsg" /> </uix:contents> </uix:rowLayout> <uix:rowLayout > <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="SQL_TIME@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="sqlExecTime@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout > <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="PLSQL_TIME@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="plsqlExecTime@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="JAVA_TIME@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="javaExecTime@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout width="100%"> <uix:cellFormat vAlign="top"> <%-- <uix:header textBinding="SD_CURSORS_STAT@sqlMsg" size="2"> --%> <uix:tableLayout> <uix:rowLayout width="100%"> <uix:spacer height="5"/> </uix:rowLayout> <uix:rowLayout> <uix:contents> <uix:styledText styleClass="OraHeaderSubSub" textBinding="SD_CURSORS_STAT@sqlMsg" /> </uix:contents> </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="TOT_PARSES@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="parseCalls@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="HARD_PARSES@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="hardParse@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="CHILD_CURSORS@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="numberOfChildCursors@sqlDetailUI@servletRequest" /> </uix:cellFormat > </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="CURSORS_LOADED@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="loadedVersions@sqlDetailUI@servletRequest" /> </uix:cellFormat > </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="INVALIDATIONS@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="invalidations@sqlDetailUI@servletRequest" /> </uix:cellFormat > </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="LARGEST_CURSOR_SIZE@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="sharableMem@sqlDetailUI@servletRequest" /> </uix:cellFormat > </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="ALL_CURSOR_SIZE@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="totalSharableMem@sqlDetailUI@servletRequest" /> </uix:cellFormat > </uix:rowLayout> <uix:rowLayout renderedBinding="isRealTime@sqlDetailUI@servletRequest"> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="FIRST_LOAD_TIME@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="false" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="firstLoadTime@sqlDetailUI@servletRequest" /> </uix:cellFormat > </uix:rowLayout> <uix:rowLayout renderedBinding="isRTand90@sqlDetailUI@servletRequest"> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="LAST_LOAD_TIME@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="false" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="lastLoadTime@sqlDetailUI@servletRequest" /> </uix:cellFormat > </uix:rowLayout> </uix:tableLayout> </uix:cellFormat > </uix:rowLayout> <uix:rowLayout width="100%"> <uix:cellFormat vAlign="top"> <%-- <uix:header textBinding="EXEC_STATS_SECTION@sqlMsg" size="2"> --%> <uix:tableLayout > <uix:rowLayout width="100%"> <uix:spacer height="5"/> </uix:rowLayout> <uix:rowLayout> <uix:contents> <uix:styledText styleClass="OraHeaderSubSub" textBinding="EXEC_STATS_SECTION@sqlMsg" /> </uix:contents> </uix:rowLayout> <uix:rowLayout > <uix:table width="100%" name="history" columnFormatsBinding="execStatColFormats@sqlDetailUI@pageContext" columnHeaderDataBinding="execStatColHeader@sqlDetailUI@servletRequest" tableDataBinding="execStatData@sqlDetailUI@servletRequest"> <uix:tableFormat tableBanding="rowBanding"/> <uix:columnHeaderStamp> <uix:styledText textBinding="text" /> </uix:columnHeaderStamp> <uix:contents> <uix:styledText textBinding="name" /> <uix:styledText textBinding="total" /> <uix:styledText textBinding="per execute"/> <uix:styledText textBinding="per row"/> </uix:contents> </uix:table> </uix:rowLayout> </uix:tableLayout> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout width="100%" renderedBinding="isRT10@sqlDetailUI@servletRequest"> <uix:cellFormat vAlign="top"> <%-- <uix:header textBinding="OTHER_STATS@sqlMsg" size="2"> --%> <uix:tableLayout> <uix:rowLayout width="100%"> <uix:spacer height="5"/> </uix:rowLayout> <uix:rowLayout> <uix:contents> <uix:styledText styleClass="OraHeaderSubSub" textBinding="OTHER_STATS@sqlMsg" /> </uix:contents> </uix:rowLayout> <uix:rowLayout> <uix:switcher childNameBinding="isRealTime@sqlDetailUI@servletRequest"> <uix:case name="true"> <uix:tableLayout> <uix:rowLayout renderedBinding="isVer10Higher@sqlDetailUI@servletRequest"> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="FETCHED_ALL_ROWS@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="fetchedAllRows@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="AVG_PERSIST_MEM@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="persistentMem@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="AVG_RUNTIME_MEM@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="runtimeMem@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="SERIAL_ABORTS@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="serialAborts@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout renderedBinding="isVer90Higher@sqlDetailUI@servletRequest"> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="REMOTE@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="isRemote@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout renderedBinding="isVer90Higher@sqlDetailUI@servletRequest"> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="IS_OBSOLETE@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="isObsolete@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout renderedBinding="isVer92Higher@sqlDetailUI@servletRequest"> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="CHILD_LATCH@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="childLatch@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> </uix:case> <uix:default> <uix:tableLayout> <uix:rowLayout renderedBinding="isVer10Higher@sqlDetailUI@servletRequest"> <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top"> <uix:messagePrompt promptBinding="FETCHED_ALL_ROWS@sqlMsg"/> </uix:cellFormat> <uix:cellFormat> <uix:spacer width="5"/> </uix:cellFormat> <uix:cellFormat wrappingDisabled="true" hAlign="left"> <uix:styledText styleClass="OraDataText" textBinding="fetchedAllRows@sqlDetailUI@servletRequest" /> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> </uix:default> </uix:switcher> </uix:rowLayout> </uix:tableLayout> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> </uix:stackLayout> </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