Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\database\instance\executionPlanTable.jspf
<%-- You need to set the following attributes in servlet request when including this execution plan jspf file in your page: - execPlanSummary, e.g. "Execution Plan" - execPlanColHeaderData,a DataObjectList that defines the header - execPlanColFormatData,a DataObjectList that defines the header format - execPlanTreeData, a DataObject that contains data for the hGrid - execPlanProxy, a ClientStateHGridDataProxy - execPlanShowStepID, whether or not to show step id - execPlanShowObj, whether or not to show object - execPlanShowObjType, whether or not to show object type - execPlanShowObjNode, whether or not to show object node - execPlanShowOrder, whether or not to show order - execPlanShowCard, whether or not to show cardinality/rows - execPlanShowBytes, whether or not to show bytes - execPlanShowOrigIcon, whether or not to show original icon (for original plan in plan diff only) - execPlanShowTempSpace whether or not to show temp space - execPlanShowCost, whether or not to show cost - execPlanShowPctCpuCost, whether or not to show pct cpu cost - execPlanShowTime, whether or not to show time - execPlanShowCPUCost, whether or not to show CPU cost - execPlanShowIOCost, whether or not to show IO cost - execPlanShowPStart, whether or not to show pstart - execPlanShowPStop, whether or not to show pstop - execPlanShowTq, whether or not to show tq - execPlanShowInOut, whether or not show in out - execPlanShowPqDist, whether or not show pq distribution - execPlanShowQbnOa, whether or not show qbnoa - execPlanShowPredicate, whether or not show predicate - execPlanShowFilter, whether or not show filter - execPlanShowProjection, whether or not show projection Also you need to set oracle.sysman.db.rsc.inst.DBMsg bundle using name dbMsg in your calling jsp or jspf file --%> <uix:hGrid id="explainPlans" summaryBinding="execPlanSummary@servletRequest" width="100%" formSubmitted="true" alternateTextBinding="NO_EXPLAIN_PLAN@dbMsg" columnHeaderDataBinding="execPlanColHeaderData@servletRequest" columnFormatsBinding="execPlanColFormatData@servletRequest" treeDataBinding="execPlanTreeData@servletRequest" proxyBinding="execPlanProxy@servletRequest"> <uix:nodeStamp> <uix:column> <uix:columnFormat width="300"/> <uix:columnHeader> <uix:styledText textBinding="XP_OPERATION@dbMsg"/> </uix:columnHeader> </uix:column> </uix:nodeStamp> <uix:columnHeaderStamp> <uix:styledText textBinding="text"/> </uix:columnHeaderStamp> <%-- id --%> <uix:styledText textBinding="xp_id" renderedBinding="execPlanShowStepID@servletRequest"/> <%-- object --%> <uix:link textBinding="xp_object" destinationBinding="objURL" renderedBinding="execPlanShowObj@servletRequest" targetFrame="_top"/> <%-- object type --%> <uix:styledText textBinding="xp_object_type" renderedBinding="execPlanShowObjType@servletRequest"/> <%-- object node --%> <uix:styledText textBinding="xp_object_node" renderedBinding="execPlanShowObjNode@servletRequest"/> <%-- order --%> <uix:styledText textBinding="xp_order" renderedBinding="execPlanShowOrder@servletRequest"/> <%-- card --%> <uix:styledText textBinding="xp_cardinality" renderedBinding="execPlanShowCard@servletRequest"/> <%-- bytes --%> <uix:styledText textBinding="xp_bytes" renderedBinding="execPlanShowBytes@servletRequest"/> <%-- temp space --%> <uix:styledText textBinding="xp_temp_space" renderedBinding="execPlanShowTempSpace@servletRequest"/> <%-- cost --%> <uix:switcher childNameBinding="execPlanShowOrigIcon@servletRequest" renderedBinding="execPlanShowCost@servletRequest"> <uix:case name="true"> <uix:flowLayout> <uix:image sourceBinding="xp_orig_cost_icon" shortDescBinding="xp_orig_cost"/> <uix:styledText textBinding="xp_cost"/> </uix:flowLayout> </uix:case> <uix:case name="false"> <uix:styledText textBinding="xp_cost"/> </uix:case> </uix:switcher> <%-- pct cpu cost --%> <uix:styledText textBinding="xp_pect_cpu_cost" renderedBinding="execPlanShowPctCpuCost@servletRequest"/> <%-- time --%> <uix:styledText textBinding="xp_time" renderedBinding="execPlanShowTime@servletRequest"/> <%-- CPU cost --%> <uix:switcher childNameBinding="execPlanShowOrigIcon@servletRequest" renderedBinding="execPlanShowCPUCost@servletRequest"> <uix:case name="true"> <uix:flowLayout> <uix:image sourceBinding="xp_orig_cost_icon" shortDescBinding="xp_orig_cpu_cost"/> <uix:styledText textBinding="xp_cpu_cost"/> </uix:flowLayout> </uix:case> <uix:case name="false"> <uix:styledText textBinding="xp_cpu_cost"/> </uix:case> </uix:switcher> <%-- IO cost --%> <uix:switcher childNameBinding="execPlanShowOrigIcon@servletRequest" renderedBinding="execPlanShowIOCost@servletRequest"> <uix:case name="true"> <uix:flowLayout> <uix:image sourceBinding="xp_orig_cost_icon" shortDescBinding="xp_orig_io_cost"/> <uix:styledText textBinding="xp_io_cost"/> </uix:flowLayout> </uix:case> <uix:case name="false"> <uix:styledText textBinding="xp_io_cost"/> </uix:case> </uix:switcher> <%-- pstart --%> <uix:styledText textBinding="xp_pstart" renderedBinding="execPlanShowPStart@servletRequest"/> <%-- pstop --%> <uix:styledText textBinding="xp_pstop" renderedBinding="execPlanShowPStop@servletRequest"/> <%-- tq --%> <uix:styledText textBinding="xp_tq" renderedBinding="execPlanShowTq@servletRequest"/> <%-- in out --%> <uix:styledText textBinding="xp_in_out" renderedBinding="execPlanShowInOut@servletRequest"/> <%-- pq distribution --%> <uix:styledText textBinding="xp_pq_distribution" renderedBinding="execPlanShowPqDist@servletRequest"/> <%-- query block name/object alias --%> <uix:styledText textBinding="xp_qbn_oa" renderedBinding="execPlanShowQbnOa@servletRequest"/> <%-- predicate --%> <uix:styledText textBinding="xp_predicate" shortDescBinding="xp_predicate_full" renderedBinding="execPlanShowPredicate@servletRequest"/> <%-- filter --%> <uix:styledText textBinding="xp_filter" shortDescBinding="xp_filter_full" renderedBinding="execPlanShowFilter@servletRequest"/> <%-- projection --%> <uix:styledText textBinding="xp_projection" shortDescBinding="xp_projection_full" renderedBinding="execPlanShowProjection@servletRequest"/> </uix:hGrid>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de