Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\database\instance\sqltune\sqlPlan.jsp
<%@ include file="/sdk/oemTop.jspf" %> <%@ include file="/oemNoscript.jspf" %> <%-- ================ SQL Page =================== MODIFIED (MM/DD/YY) manaraya 03/29/09 - Bug 7707453 ezeng 02/21/08 - add plan hash value nachen 04/11/07 - fix desc for new plan misun 01/05/07 - XbranchMerge misun_bug-5675432 from main misun 12/14/06 - fix bug 5675432 hxlin 04/11/06 - Cut over to sharable execution plan component ychan 07/14/06 - Change destination binding nachen 06/22/05 - add summary for hgrid nachen 04/18/05 - add graphical new plans nachen 01/18/05 - add blue dot nachen 11/16/04 - fix legend url nachen 10/15/04 - add graphical explain plan nachen 04/16/04 - fix bug 3153000 nachen 09/10/03 - change the text in original plan page nachen 08/08/03 - add nls string nachen 08/06/03 - add line id hsu 07/25/03 - change global nachen 07/02/03 - add advisoryCentralURL yfeng 06/12/03 - yfeng_sql_6_10 yfeng 06/11/03 - Created --%> <%@ 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="dbMsg" class="oracle.sysman.db.rsc.inst.DBMsg"/> <uix:bundle name="sqlMsg" class="oracle.sysman.db.rsc.inst.SQLMsg"/> <uix:bundle name="sdkMessageBundle" class="oracle.sysman.emSDK.eml.SDKUIMsg"/> <oem:setURLEncoder id="renderingContext"/> <uix:document> <%@ include file="/oemTitle.jspf" %> <uix:body> <uix:pageLayout> <%@ include file="/database/global.jspf" %> <db:form name="tsForm" destination="/console/database/instance/sqltune" copyParams="target,type,planType,execID,taskUser,taskName,task_id,objectId,execID,advisoryCentralURL,dbPageNum,planType,state,_root,node"> <uix:formValue name="event"/> <uix:formValue name="pageName" value="/database/instance/sqltune/sqlPlan.jsp"/> <uix:header textBinding="header@servletRequest" > <uix:rowLayout width="80%"> <uix:labeledFieldLayout labelWidth="15%"> <uix:styledText styleClass="OraPromptText" textBinding="PLAN_HASH_VALUE@dbMsg"/> <uix:switcher childNameBinding="planType@servletRequest"> <uix:case name="original"> <uix:styledText styleClass="OraDataText" textBinding="origPlanHashValue@servletRequest"/> </uix:case> <uix:case name="indexPlan"> <uix:styledText styleClass="OraDataText" textBinding="newPlanHashValue@servletRequest"/> </uix:case> <uix:case name="hintsetPlan"> <uix:styledText styleClass="OraDataText" textBinding="newPlanHashValue@servletRequest"/> </uix:case> <uix:case name="hintsetPXPlan"> <uix:styledText styleClass="OraDataText" textBinding="newPlanHashValue@servletRequest"/> </uix:case> <uix:case name="newAlternativePlan"> <uix:flowLayout> <uix:styledText styleClass="OraDataText" textBinding="newPlanHashValue@servletRequest"/> <uix:formValue name="planHashValue" valueBinding="newPlanHashValue@servletRequest"/> </uix:flowLayout> </uix:case> </uix:switcher> </uix:labeledFieldLayout> </uix:rowLayout> <uix:switcher childNameBinding="displayTypeForOrigPlan@sresultObj@servletRequest"> <uix:case name="tabular"> <uix:switcher childNameBinding="isOriginalWithAdjusted@servletRequest"> <uix:case name="true"> <uix:switcher childNameBinding="planType@servletRequest"> <uix:case name="original"> <uix:rowLayout> <uix:image sourceBinding="changedItemIcon@servletRequest"/> <uix:styledText styleClass="OraPromptText" textBinding="KEY_NOTATION_MSG@sqlMsg"/> </uix:rowLayout> </uix:case> </uix:switcher> </uix:case> </uix:switcher> </uix:case> </uix:switcher> <uix:switcher childNameBinding="usingSVG@servletRequest"> <uix:case name="true"> <uix:tableLayout> <uix:rowLayout> <uix:messagePrompt promptBinding="VIEW_DETAIL@dbMsg"/> <uix:switcher childNameBinding="planType@servletRequest"> <uix:case name="original"> <uix:flowLayout> <uix:contents childDataBinding="displayTypesListForOrigPlan@sresultObj@servletRequest"> <uix:radioButton name="displayTypeForOrigPlan" textBinding="text" valueBinding="val" onClickBinding="onclick" selectedBinding="selected"/> </uix:contents> </uix:flowLayout> </uix:case> <uix:case name="indexPlan"> <uix:flowLayout> <uix:contents childDataBinding="displayTypesListForIndexPlan@sresultObj@servletRequest"> <uix:radioButton name="displayTypeForIndexPlan" textBinding="text" valueBinding="val" onClickBinding="onclick" selectedBinding="selected"/> </uix:contents> </uix:flowLayout> </uix:case> <uix:case name="hintsetPlan"> <uix:flowLayout> <uix:contents childDataBinding="displayTypesListForHintsetPlan@sresultObj@servletRequest"> <uix:radioButton name="displayTypeForHintsetPlan" textBinding="text" valueBinding="val" onClickBinding="onclick" selectedBinding="selected"/> </uix:contents> </uix:flowLayout> </uix:case> <uix:case name="hintsetPXPlan"> <uix:flowLayout> <uix:contents childDataBinding="displayTypesListForHintsetPlan@sresultObj@servletRequest"> <uix:radioButton name="displayTypeForHintsetPlan" textBinding="text" valueBinding="val" onClickBinding="onclick" selectedBinding="selected"/> </uix:contents> </uix:flowLayout> </uix:case> <uix:case name="newAlternativePlan"> <uix:flowLayout> <uix:contents childDataBinding="displayTypesListForAlternativePlan@sresultObj@servletRequest"> <uix:radioButton name="displayTypeForAlternativePlan" textBinding="text" valueBinding="val" onClickBinding="onclick" selectedBinding="selected"/> </uix:contents> </uix:flowLayout> </uix:case> </uix:switcher> </uix:rowLayout> </uix:tableLayout> </uix:case> </uix:switcher> <uix:tableLayout width="100%"> <uix:rowLayout> <uix:cellFormat height="100%" width="100%"> <uix:switcher childNameBinding="displayType@servletRequest"> <uix:case name="graphical"> <oem:topology topoPageType="sqlPlanTopoPageType" keyParameters="target, type, objectId, task_id, planType,taskName,taskUser" width="100%" height="100%"/> </uix:case> <uix:case name="tabular"> <%@ include file="/database/instance/executionPlanTable.jspf" %> </uix:case> </uix:switcher> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> <uix:switcher childNameBinding="displayType@servletRequest"> <uix:case name="graphical"> <uix:tip> <uix:styledText textBinding="LEGEND_TEXT@sdkMessageBundle"/> <uix:link textBinding="ICON_LEGEND_HEADER@sqlMsg" destinationBinding="iconLegendUrl@servletRequest"/> </uix:tip> </uix:case> </uix:switcher> </uix:header> </db:form> </uix:pageLayout> </uix:body> </uix:document> </uix:renderingContext>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de