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