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

<db:form name="foo" destination="/console/database/instance/topSqls"
         method="get" copyParams="target,type,refreshChoice">
    <uix:formValue name="t1" value=""/>
    <uix:formValue name="t2" value=""/>
    <uix:formValue name="direction" value="" />
    <uix:formValue name="event" />

<uix:header textBinding="TOP_SQL_HEADER@ResourceBundle@servletRequest" />
    <uix:subTabLayout>
        <uix:subTabs>
            <uix:subTabBar
                 selectedIndex="0">
                <uix:link textBinding="SPOT_SQL@ResourceBundle@servletRequest"
                    destinationBinding="spotSqlDest@servletRequest"/>
                <uix:link textBinding="PERIOD_SQL@ResourceBundle@servletRequest"
                    destinationBinding="periodSqlDest@servletRequest"/>
            </uix:subTabBar>
        </uix:subTabs>

<%-- View Data Choices --%>
        <uix:tableLayout width="100%">
            <uix:rowLayout hAlign="left" >
                <uix:messagePrompt promptBinding="SPOT_SQL_INSTRUCTION@DBMsgBundle@servletRequest" />
            </uix:rowLayout>
            <uix:rowLayout hAlign="right">
                <uix:flowLayout>
                    <uix:styledText styleClass="OraInstructionText"
                            textBinding="VIEW_DATA_LABEL@ResourceBundle@servletRequest" 
                            labeledNodeId="ViewLabel" />
                            
                     <uix:choice name="refreshChoice" id="ViewLabel"
                        onChange="submitForm('foo', true, {'event':'updateRefreshChoice'})"
                        selectedValueBinding="refreshChoice@servletRequest">
                      <uix:option textBinding="REAL_TIME_AUTO_15_SEC@DBMsgBundle@servletRequest"
                        value="2"/>
                      <uix:option textBinding="REAL_TIME_1_MIN@DBMsgBundle@servletRequest"
                        value="3"/> 
                      <uix:option textBinding="REAL_TIME_MANUAL@DBMsgBundle@servletRequest"
                        value="0"/>
                    </uix:choice>
                    
                </uix:flowLayout>
            </uix:rowLayout>
        </uix:tableLayout>

<%-- Instruction text --%>
        <uix:header textBinding="SPOT_SQL_INTERVAL_HEADER@DBMsgBundle@servletRequest" size="1">
          <uix:switcher childNameBinding="useSVG@topSqlsBean@servletRequest">
          <uix:case name="true">
            <uix:tableLayout>
              <uix:rowLayout hAlign="left">
                <uix:messagePrompt promptBinding="SPOT_SQL_INTERVAL_INSTR@DBMsgBundle@servletRequest" />
              </uix:rowLayout>
            </uix:tableLayout>
          </uix:case>
          <uix:case name="false">
            <uix:tableLayout>
              <uix:rowLayout hAlign="left">
                <uix:messagePrompt promptBinding="WAIT_DETAIL_GIF_TIP@DBMsgBundle@servletRequest" />
              </uix:rowLayout>
            </uix:tableLayout> 
          </uix:case>
          </uix:switcher>
        </uix:header>

<oem:chart 
            chartType="timeSeriesChart"
            width="850"
            height="200"
            timeGranularity="SECOND" 
            orientation="vertical"
            fill="cumulative"  
            yAxisLabelBinding="ACTIVE_SESSIONS@DBMsgBundle@servletRequest"  
            legendPosition="east"
            legendVisible="true"
            titleBinding="ACTIVE_SESSIONS@DBMsgBundle@servletRequest"
            titleVisible="false"
            seriesColorsAutomatic="true"
            format="svg"
            svgUpdateFrequencyBinding="svgUpdateRate@servletRequest"
            xAxisMinBinding="beginDate@waitAreaChart@topSqlsBean@servletRequest"
            xAxisMaxBinding="endDate@waitAreaChart@topSqlsBean@servletRequest"
            colorPaletteBinding="pickerColors@waitAreaChart@topSqlsBean@servletRequest"
            svgHighlightLegend="true"
          >
          <uix:contents>
            <oem:timeSelector
              xAxisMinBinding="beginDate@waitAreaChart@topSqlsBean@servletRequest"
              xAxisMaxBinding="endDate@waitAreaChart@topSqlsBean@servletRequest"
              intervalTimeSecBinding="intervalTimeSec@servletRequest"
              height="20"
              selectedMaxDateBinding="selectedMaxDate@servletRequest"
              selectedMinDateBinding="selectedMinDate@servletRequest"
              numBandsSelectedBinding="numBandsSelected@servletRequest"
              selectionDest="my_goto_band"
              selectionDestType="JavaScript"
              selectionAltTextBinding="SELECT_PERIOD_RANGE@DBMsgBundle@servletRequest" 
              position="south"
              dynamicTimeSelector="true"
              selectionIndicator="shading"
              dynamicTimeSelectorColorBinding="sliderColor@waitAreaChart@topSqlsBean@servletRequest"
              dynamicTimeSelectorEdgeColorBinding="sliderEdgeColor@waitAreaChart@topSqlsBean@servletRequest"
            >
            </oem:timeSelector>
            <oem:boundChartDataSource 
              dataClass="oracle.sysman.db.adm.inst.TopSqlsController"
              dataMethod="updateChartData" />
            <oem:chartColumn                                   
                isKey="true" 
                displayLabel=""
                sourceIndex="0" />
            <oem:chartColumn
                isTimeColumn="true"
                displayLabel="Time"
                sourceIndex="1"  />
            <oem:chartColumn                                   
                displayLabel=""
                sourceIndex="2" />
          </uix:contents>
        </oem:chart>

<%-- Detail Section --%>      
        <uix:tableLayout width="100%">
            <uix:rowLayout>
                <uix:header
                    textBinding="SPOT_SQL_DETAIL_HEADER@DBMsgBundle@servletRequest" size="1"/>
            </uix:rowLayout>
            <uix:rowLayout>
                <uix:cellFormat hAlign="left" wrappingDisabled="true">
                    <uix:spacer width="8"/>
                    <uix:styledText styleClass="OraPromptText"
                        textBinding="SPOT_SQL_DETAIL_TEXT@DBMsgBundle@servletRequest"/>
                    <uix:spacer width="8"/>
                    <uix:styledText styleClass="OraDataText"
                      textBinding="startTime@topSqlsBean@servletRequest"/>
                </uix:cellFormat>
            </uix:rowLayout>
        </uix:tableLayout>
                        
        <uix:tableLayout width="100%">
           <uix:rowLayout vAlign="top" width="100%">  
                <%-- All SQL table --%>
                <cellFormat vAlign="top" width="50%">
                    <uix:header textBinding="SPOT_SQL_ALL_SQL@DBMsgBundle@servletRequest" size="2">
                        <oem:table name="twoDUIDataSource"
                            summaryBinding="TOP_SQL_HEADER@ResourceBundle@servletRequest"
                            id="theSpotSqlTable"
                            blockSize="10"
                            beanKey="dataSourceBean" 
                            destination="/console/database/instance/topSqls"
                            formSubmitted="true"
                            dataSourceProp="twoDUIDataSource" 
                            width="100%">
                          <uix:tableSelection>
              
                          <uix:multipleSelection
                              selectedBinding="selected"
                              shortDescBinding="SELECT@ResourceBundle@servletRequest"
                              selectionBinding="selection@tableDataSource@topSqlsBean@servletRequest"
                              > 
                            <uix:pageButtonBar>
                              <uix:submitButton
                                textBinding="RUN_TUNING_ADVISOR@ResourceBundle@servletRequest"
                                name="event"
                                value="sqlTuning"
                              />
                              <uix:submitButton
                                textBinding="CREATE_STS@ResourceBundle@servletRequest"
                                name="event"
                                value="createSTS"
                              />
                            </uix:pageButtonBar>                          
                          </uix:multipleSelection>

</uix:tableSelection>

</oem:table>
                    </uix:header>
                </uix:cellFormat>

<%-- Top SQL Pie Chart --%>
                <uix:switcher childNameBinding="showPieChart@topSqlsBean@servletRequest">
                    <uix:case name="true">
                        <cellFormat vAlign="top" width="50%">
                            <uix:header textBinding="chartHeader@topSqlPie@topSqlsBean@servletRequest" size="2">
                                <oem:chart
                                        chartType="pieChart"
                                        width="350"
                                        height="200"
                                        pieValuesInLegend="percent"
                                        legendPosition="south"
                                        showSlicePercentLabels="true"
                                        hideZeroSlices="true"
                                        legendWidthFraction="0.2">
                                    <oem:boundChartDataSource
                                        chartDataSourceBinding="pieDataSource@topSqlPie@topSqlsBean@servletRequest"/>
                                    <oem:imageMap
                                        imageMapDataSourceBinding="imageMap@topSqlPie@topSqlsBean@servletRequest"/>
                                    <oem:chartColumn isKey="true"
                                        displayLabel="Label 1"
                                        sourceIndex="0" />
                                    <oem:chartColumn displayLabel="Label 2"
                                        itemColor="blue"
                                        sourceIndex="1"/>
                                </oem:chart>
                            </uix:header>
                        </cellFormat>
                    </uix:case>
                    <uix:case name="false">
                        <cellFormat vAlign="top" width="50%">
                            <uix:styledText styleClass="OraPromptText"
                                textBinding="SPOT_SQL_NO_PIE_CHART@DBMsgBundle@servletRequest"/>
                        </cellFormat>
                    </uix:case>
                </uix:switcher>
            </uix:rowLayout>
        </uix:tableLayout>
    </uix:subTabLayout>
</db:form>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de