Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\database\instance\sql\sqlExecActHT.jspf

<%-- ================  Historical Statistics tab of SQL Details Page ===================

MODIFIED    (MM/DD/YY)
      yma       05/24/05 - bug 4122171 
      yfeng     10/14/04 - Make label view vAlign=middle
--%>
<uix:stackLayout>
<uix:tableLayout width="100%">
	<uix:rowLayout width="100%"> 
    <uix:cellFormat hAlign="left">         
      <uix:styledText styleClass="OraInstructionText"
                      textBinding="EXEC_STATS_DESC2@sqlMsg" />
    </uix:cellFormat>
    <uix:cellFormat  hAlign="right">
    
    <uix:tableLayout  cellSpacing="3">
  	  <uix:rowLayout  hAlign="right"> 
        <uix:cellFormat hAlign="right" >         
          <uix:spacer width="12" />
        </uix:cellFormat> 
        <uix:cellFormat hAlign="right" >         
          <uix:messagePrompt promptBinding="VIEW@dbMsg" labeledNodeId="viewChart"/> 
        </uix:cellFormat> 
        <uix:cellFormat hAlign="right" >         
          <uix:spacer width="6" />
        </uix:cellFormat> 
        <uix:cellFormat hAlign="right" >
            <uix:choice id="viewChart" name="viewChart"
                        onChange="submitForm('sqlForm', true, {'event':'changeViewChart'})"
                        selectedValueBinding="viewChart@sqlDetailUI@servletRequest"                                
                         shortDescBinding="VIEW@dbMsg">
              <uix:contents childDataBinding="viewChartList@sqlDetailUI@servletRequest">
                <uix:option textBinding="stext"
                           valueBinding="sval"/>
              </uix:contents>
            </uix:choice>      
        </uix:cellFormat>         
	    </uix:rowLayout> 
    </uix:tableLayout>  
    
    </uix:cellFormat>
  </uix:rowLayout> 
</uix:tableLayout>          
       
   
<uix:switcher childNameBinding="viewChart@sqlDetailUI@servletRequest">
  <uix:case name="userExec">               
    <oem:chart 
        chartType="timeSeriesChart"
        width="850"
        height="150"
        timeGranularity="SECOND" 
        orientation="vertical"
        seriesColorsAutomatic="true"
        legendPosition="east" 
        legendVisible="true"    
        yAxisLabelBinding="USER_EXEC@sqlMsg"
        titleBinding="USER_EXEC@sqlMsg"
        titleVisible="false"
        xAxisMinBinding="beginDate@execActivityBean@servletRequest"
        xAxisMaxBinding="endDate@execActivityBean@servletRequest"
        format="svg"        
        svgHighlightLegend="true"
      >
      <uix:contents>
        <oem:timeSelector
          intervalTimeSec="1800"
          height="20"
          selectionDest="svgIconClicked"
          selectionDestType="JavaScript"
          position="south"
          timebandDataSourceBinding="timebands@execActivityBean@servletRequest"
          xAxisScrollDest="scroll_timechart"
          xAxisScrollDestType="JavaScript"
          xAxisScrollPrev="true"
          xAxisScrollPrevAltTextBinding="GO_BACKWARD@dbMsg"
          xAxisScrollNext="true"
          xAxisScrollNextAltTextBinding="GO_FORWARD@dbMsg"
        >
        </oem:timeSelector>
        <oem:boundChartDataSource 
          chartDataSourceBinding="chartDataSource@execActivityBean@servletRequest"/>               
        <oem:imageMap imageMapDataSourceBinding="execActivityImageMap@servletRequest"/>
        <oem:chartColumn                                   
            isKey="true" 
            displayLabel=""
            sourceIndex="0" />
        <oem:chartColumn
            isTimeColumn="true"
            displayLabel="Time"
            sourceIndex="1"  />
        <oem:chartColumn                                   
            displayLabel=""
            sourceIndex="2" />
      </uix:contents>      
    </oem:chart>
<%--
          selectionAltTextBinding="CLICK_TO_SELECT_RUNS@HDMMsgBundle@servletRequest"
 --%>
 
  </uix:case>
  <uix:case name="elapsedTime">
  
    <uix:switcher childNameBinding="isVer10Higher@sqlDetailUI@servletRequest">
      <uix:case name="true">                           
	
    <uix:switcher childNameBinding="statChartShowEach@sqlDetailUI@servletRequest">
      <uix:case name="true">                           
    <oem:chart 
        chartType="timeSeriesBarChart"
        width="850"
        height="150"
        timeGranularity="SECOND" 
        orientation="vertical"
        legendPosition="east" 
        legendVisible="true"    
        yAxisLabelBinding="ELAPSED_EXEC@sqlMsg"
        titleBinding="ELAPSED_EXEC@sqlMsg"
        titleVisible="false"
        xAxisMinBinding="beginDate@execActivityBean@servletRequest"
        xAxisMaxBinding="endDate@execActivityBean@servletRequest"
        format="svg"        
        barWidthFraction="1.0"
        stacked="true"
      >
      <uix:contents>
        <oem:timeSelector
          intervalTimeSec="1800"
          height="20"
          selectionDest="svgIconClicked"
          selectionDestType="JavaScript"
          position="south"
          timebandDataSourceBinding="timebands@execActivityBean@servletRequest"
          xAxisScrollDest="scroll_timechart"
          xAxisScrollDestType="JavaScript"
          xAxisScrollPrev="true"
          xAxisScrollPrevAltTextBinding="GO_BACKWARD@dbMsg"
          xAxisScrollNext="true"
          xAxisScrollNextAltTextBinding="GO_FORWARD@dbMsg"
        >
        </oem:timeSelector>
        <oem:boundChartDataSource 
          chartDataSourceBinding="chartDataSource@execActivityBean@servletRequest"/>

<oem:chartColumn                                   
            isKey="true" 
            displayLabel=""
            sourceIndex="0" />
        <oem:chartColumn
            isTimeColumn="true"
            displayLabel="Time"
            sourceIndex="1"  />
        <oem:chartColumn                                   
            displayLabel=""
            sourceIndex="2" />
         
      </uix:contents>      
    </oem:chart>  
    </uix:case>
      <uix:case name="false">

<oem:chart
        chartType="timeSeriesBarChart"
        width="850"
        height="150"
        timeGranularity="SECOND"
        orientation="vertical"
        legendPosition="east"
        legendVisible="true"
        yAxisLabelBinding="ELAPSED_EXEC@sqlMsg"
        titleBinding="ELAPSED_EXEC@sqlMsg"
        titleVisible="false"
        xAxisMinBinding="beginDate@execActivityBean@servletRequest"
        xAxisMaxBinding="endDate@execActivityBean@servletRequest"
        format="svg"
        barWidthFraction="1.0"
        stacked="true"
      >
      <uix:contents>
        <oem:timeSelector
          intervalTimeSec="1800"
          height="20"
          selectionDest="svgIconClicked"
          selectionDestType="JavaScript"
          position="south"
          timebandDataSourceBinding="timebands@execActivityBean@servletRequest"
          xAxisScrollDest="scroll_timechart"
          xAxisScrollDestType="JavaScript"
          xAxisScrollPrev="true"
          xAxisScrollPrevAltTextBinding="GO_BACKWARD@dbMsg"
          xAxisScrollNext="true"
          xAxisScrollNextAltTextBinding="GO_FORWARD@dbMsg"
        >
        </oem:timeSelector>
        <oem:boundChartDataSource
          chartDataSourceBinding="chartDataSource@execActivityBean@servletRequest"/>
        <oem:chartColumn
            isTimeColumn="true"
            displayLabel="Time"
            sourceIndex="0" />
        <oem:chartColumn
            displayLabelBinding="CPU_HDR@dbMsg"
            itemColor="#00cc00"
            sourceIndex="1"  />
        <oem:chartColumn
                displayLabelBinding="IO_HDR@dbMsg"
                itemColor="#660066"
                sourceIndex="2"  />
        <oem:chartColumn
                displayLabelBinding="WAIT_HDR@dbMsg"
                itemColor="#999900"
                sourceIndex="3"  />
      </uix:contents>
    </oem:chart>
    </uix:case>
    </uix:switcher>
  </uix:case>

<uix:default>
    <oem:chart 
        chartType="timeSeriesBarChart"
        width="850"
        height="150"
        timeGranularity="SECOND" 
        orientation="vertical"
        legendPosition="east" 
        legendVisible="true"    
        yAxisLabelBinding="ELAPSED_EXEC@sqlMsg"
        titleBinding="ELAPSED_EXEC@sqlMsg"
        titleVisible="false"
        xAxisMinBinding="beginDate@execActivityBean@servletRequest"
        xAxisMaxBinding="endDate@execActivityBean@servletRequest"
        format="svg"        
        barWidthFraction="1.0"
        stacked="true"
      >
      <uix:contents>
        <oem:timeSelector
          intervalTimeSec="1800"
          height="20"
          selectionDest="svgIconClicked"
          selectionDestType="JavaScript"
          position="south"
          timebandDataSourceBinding="timebands@execActivityBean@servletRequest"
          xAxisScrollDest="scroll_timechart"
          xAxisScrollDestType="JavaScript"
          xAxisScrollPrev="true"
          xAxisScrollPrevAltTextBinding="GO_BACKWARD@dbMsg"
          xAxisScrollNext="true"
          xAxisScrollNextAltTextBinding="GO_FORWARD@dbMsg"
        >
        </oem:timeSelector>
        <oem:boundChartDataSource 
          chartDataSourceBinding="chartDataSource@execActivityBean@servletRequest"/>               
         
        <oem:chartColumn                                   
            isTimeColumn="true" 
            displayLabel="Time"
            sourceIndex="0" />
        <oem:chartColumn
            displayLabelBinding="CPU_HDR@dbMsg"
            itemColor="#00cc00"
            sourceIndex="1"  />
        <oem:chartColumn
                displayLabelBinding="WAIT_HDR@dbMsg"
                itemColor="#999900"
                sourceIndex="2"  />            
      </uix:contents>      
    </oem:chart>      
    </uix:default>
    </uix:switcher>
  </uix:case>  
  
  <uix:case name="exec"> 
    <uix:switcher childNameBinding="statChartShowEach@sqlDetailUI@servletRequest">
      <uix:case name="true">
    <oem:chart
        chartType="timeSeriesBarChart"
        width="850"
        height="150"
        timeGranularity="SECOND"
        orientation="vertical"
        legendPosition="east"
        legendVisible="true"
        yAxisLabelBinding="NUM_EXEC@sqlMsg"
        titleBinding="NUM_EXEC@sqlMsg"
        titleVisible="false"
        xAxisMinBinding="beginDate@execActivityBean@servletRequest"
        xAxisMaxBinding="endDate@execActivityBean@servletRequest"
        format="svg"
        barWidthFraction="1.0"
        stacked="true"
      >
      <uix:contents>
        <oem:timeSelector
          intervalTimeSec="1800"
          height="20"
          selectionDest="svgIconClicked"
          selectionDestType="JavaScript"
          position="south"
          timebandDataSourceBinding="timebands@execActivityBean@servletRequest"
          xAxisScrollDest="scroll_timechart"
          xAxisScrollDestType="JavaScript"
          xAxisScrollPrev="true"
          xAxisScrollPrevAltTextBinding="GO_BACKWARD@dbMsg"
          xAxisScrollNext="true"
          xAxisScrollNextAltTextBinding="GO_FORWARD@dbMsg"
        >
        </oem:timeSelector>
        <oem:boundChartDataSource
          chartDataSourceBinding="chartDataSource@execActivityBean@servletRequest"/>

</uix:contents>
    </oem:chart>
    </uix:case>
      <uix:case name="false">
 
   <oem:chart 
        chartType="timeSeriesBarChart"
        width="850"
        height="150"
        timeGranularity="SECOND" 
        orientation="vertical"
        seriesColorsAutomatic="true"
        legendPosition="east" 
        legendVisible="false"    
        yAxisLabelBinding="NUM_EXEC@sqlMsg"
        titleBinding="NUM_EXEC@sqlMsg"
        titleVisible="false"
        xAxisMinBinding="beginDate@execActivityBean@servletRequest"
        xAxisMaxBinding="endDate@execActivityBean@servletRequest"
        format="svg"        
        barWidthFraction="1.0"
      >
      <uix:contents>
        <oem:timeSelector
          intervalTimeSec="1800"
          height="20"
          selectionDest="svgIconClicked"
          selectionDestType="JavaScript"
          position="south"
          timebandDataSourceBinding="timebands@execActivityBean@servletRequest"
          xAxisScrollDest="scroll_timechart"
          xAxisScrollDestType="JavaScript"
          xAxisScrollPrev="true"
          xAxisScrollPrevAltTextBinding="GO_BACKWARD@dbMsg"
          xAxisScrollNext="true"
          xAxisScrollNextAltTextBinding="GO_FORWARD@dbMsg"
        >
        </oem:timeSelector>
        <oem:boundChartDataSource 
          chartDataSourceBinding="chartDataSource@execActivityBean@servletRequest"/>               
        <oem:chartColumn                                   
            isTimeColumn="true" 
            displayLabel="Time"
            sourceIndex="0" />
        <oem:chartColumn
            displayLabel=""
            sourceIndex="1"  />
      </uix:contents>      
    </oem:chart>
    </uix:case>
    </uix:switcher>
    
  </uix:case> 
  
  <uix:case name="diskReads"> 
    <uix:switcher childNameBinding="statChartShowEach@sqlDetailUI@servletRequest">
      <uix:case name="true">
    <oem:chart  
        chartType="timeSeriesBarChart"
        width="850"
        height="150"
        timeGranularity="SECOND"
        orientation="vertical"
        legendPosition="east" 
        legendVisible="true" 
        yAxisLabelBinding="BLOCKS@sqlMsg"
        titleBinding="DISK_READS_EXEC@sqlMsg"
        titleVisible="false"
        xAxisMinBinding="beginDate@execActivityBean@servletRequest"
        xAxisMaxBinding="endDate@execActivityBean@servletRequest"
        format="svg"
        barWidthFraction="1.0"
        stacked="true"
      >
      <uix:contents>
        <oem:timeSelector
          intervalTimeSec="1800"
          height="20"
          selectionDest="svgIconClicked"
          selectionDestType="JavaScript"
          position="south"
          timebandDataSourceBinding="timebands@execActivityBean@servletRequest"
          xAxisScrollDest="scroll_timechart"
          xAxisScrollDestType="JavaScript"
          xAxisScrollPrev="true"
          xAxisScrollPrevAltTextBinding="GO_BACKWARD@dbMsg"
          xAxisScrollNext="true"
          xAxisScrollNextAltTextBinding="GO_FORWARD@dbMsg"
        >
        </oem:timeSelector>
        <oem:boundChartDataSource
          chartDataSourceBinding="chartDataSource@execActivityBean@servletRequest"/>

</uix:contents>
    </oem:chart>
    </uix:case>
      <uix:case name="false">
 
   <oem:chart 
        chartType="timeSeriesBarChart"
        width="850"
        height="150"
        timeGranularity="SECOND" 
        orientation="vertical"
        seriesColorsAutomatic="true"
        legendPosition="east" 
        legendVisible="false"    
        yAxisLabelBinding="BLOCKS@sqlMsg"
        titleBinding="DISK_READS_EXEC@sqlMsg"
        titleVisible="false"
        xAxisMinBinding="beginDate@execActivityBean@servletRequest"
        xAxisMaxBinding="endDate@execActivityBean@servletRequest"
        format="svg"        
        barWidthFraction="1.0"
      >
      <uix:contents>
        <oem:timeSelector
          intervalTimeSec="1800"
          height="20"
          selectionDest="svgIconClicked"
          selectionDestType="JavaScript"
          position="south"
          timebandDataSourceBinding="timebands@execActivityBean@servletRequest"
          xAxisScrollDest="scroll_timechart"
          xAxisScrollDestType="JavaScript"
          xAxisScrollPrev="true"
          xAxisScrollPrevAltTextBinding="GO_BACKWARD@dbMsg"
          xAxisScrollNext="true"
          xAxisScrollNextAltTextBinding="GO_FORWARD@dbMsg"
        >
        </oem:timeSelector>
        <oem:boundChartDataSource 
          chartDataSourceBinding="chartDataSource@execActivityBean@servletRequest"/>               
        <oem:chartColumn                                   
            isTimeColumn="true" 
            displayLabel="Time"
            sourceIndex="0" />
        <oem:chartColumn
            displayLabel=""
            sourceIndex="1"  />
      </uix:contents>      
    </oem:chart>
    </uix:case>
    </uix:switcher>
    
  </uix:case>  
  
  <uix:case name="bufGets"> 
    <uix:switcher childNameBinding="statChartShowEach@sqlDetailUI@servletRequest">
      <uix:case name="true">    
    <oem:chart 
        chartType="timeSeriesBarChart"
        width="850"
        height="150"
        timeGranularity="SECOND" 
        orientation="vertical"
        legendPosition="east" 
        legendVisible="true"    
        yAxisLabelBinding="BLOCKS@sqlMsg"
        titleBinding="BUF_GETS_EXEC@sqlMsg"
        titleVisible="false"
        xAxisMinBinding="beginDate@execActivityBean@servletRequest"
        xAxisMaxBinding="endDate@execActivityBean@servletRequest"
        format="svg"
        barWidthFraction="1.0"
        stacked="true"
      >
      <uix:contents>
        <oem:timeSelector
          intervalTimeSec="1800"
          height="20"
          selectionDest="svgIconClicked"
          selectionDestType="JavaScript"
          position="south"
          timebandDataSourceBinding="timebands@execActivityBean@servletRequest"
          xAxisScrollDest="scroll_timechart"
          xAxisScrollDestType="JavaScript"
          xAxisScrollPrev="true"
          xAxisScrollPrevAltTextBinding="GO_BACKWARD@dbMsg"
          xAxisScrollNext="true"
          xAxisScrollNextAltTextBinding="GO_FORWARD@dbMsg"
        >
        </oem:timeSelector>
        <oem:boundChartDataSource
          chartDataSourceBinding="chartDataSource@execActivityBean@servletRequest"/>

</uix:contents>
    </oem:chart>
    </uix:case>
      <uix:case name="false">
 
   <oem:chart 
        chartType="timeSeriesBarChart"
        width="850"
        height="150"
        timeGranularity="SECOND" 
        orientation="vertical"
        seriesColorsAutomatic="true"
        legendPosition="east" 
        legendVisible="false"    
        yAxisLabelBinding="BLOCKS@sqlMsg"
        titleBinding="BUF_GETS_EXEC@sqlMsg"
        titleVisible="false"
        xAxisMinBinding="beginDate@execActivityBean@servletRequest"
        xAxisMaxBinding="endDate@execActivityBean@servletRequest"
        format="svg"        
        barWidthFraction="1.0"
      >
      <uix:contents>
        <oem:timeSelector
          intervalTimeSec="1800"
          height="20"
          selectionDest="svgIconClicked"
          selectionDestType="JavaScript"
          position="south"
          timebandDataSourceBinding="timebands@execActivityBean@servletRequest"
          xAxisScrollDest="scroll_timechart"
          xAxisScrollDestType="JavaScript"
          xAxisScrollPrev="true"
          xAxisScrollPrevAltTextBinding="GO_BACKWARD@dbMsg"
          xAxisScrollNext="true"
          xAxisScrollNextAltTextBinding="GO_FORWARD@dbMsg"
        >
        </oem:timeSelector>
        <oem:boundChartDataSource 
          chartDataSourceBinding="chartDataSource@execActivityBean@servletRequest"/>               
        <oem:chartColumn                                   
            isTimeColumn="true" 
            displayLabel="Time"
            sourceIndex="0" />
        <oem:chartColumn
            displayLabel=""
            sourceIndex="1"  />
      </uix:contents>      
    </oem:chart>
    </uix:case>
    </uix:switcher>
    
  </uix:case>  
</uix:switcher>  
</uix:stackLayout>
	<uix:stackLayout renderedBinding="selectedIcon@execActivityBean@servletRequest">
<%--
        <uix:cellFormat hAlign="right" >
          <uix:messagePrompt promptBinding="SNAP_DETAILS@sqlMsg"/>
        </uix:cellFormat>
          <uix:styledText styleClass="OraDataText" 
                              textBinding="selectedSnapshotTime@sqlDetailUI@servletRequest" />
--%>
	<uix:tableLayout width="80%">
	  <uix:rowLayout>
	    <uix:cellFormat>
		<uix:spacer width="25"/>
	    </uix:cellFormat> 
	    <uix:cellFormat vAlign="top">
	  	<uix:header textBinding="SNAP_DETAILS@sqlMsg" size="2">
          	  <uix:tableLayout >    
            <uix:rowLayout >       
              <uix:cellFormat wrappingDisabled="true" hAlign="right" vAlign="top">
                <uix:messagePrompt promptBinding="SNAP_TIME@sqlMsg"/>
              </uix:cellFormat>
               <uix:cellFormat>
                            <uix:spacer width="5"/>
               </uix:cellFormat>
              <uix:cellFormat wrappingDisabled="true" hAlign="left">         
               <uix:styledText styleClass="OraDataText" 
                              textBinding="selectedSnapshotTime@sqlDetailUI@servletRequest" />
              </uix:cellFormat>
            </uix:rowLayout>
          </uix:tableLayout>
          </uix:header>
	</uix:cellFormat>
	</uix:rowLayout>
	</uix:tableLayout>
  </uix:stackLayout>                    
 
  <uix:stackLayout renderedBinding="isStatsNotFound@sqlDetailUI@servletRequest">
     <uix:styledText styleClass="OraInstructionText"
                    textBinding="NO_DATA_FOUND@sqlMsg" />    
  </uix:stackLayout>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de