<%-- ================  Period SQL page  =================== 

   MODIFIED    (MM/DD/YY)
      yma       03/09/07 - remove yAxisWidth attribute in chart 
      yfeng     06/24/05 - Fix ADA violation - add summary for oem:table 
      yfeng     05/26/05 - Support show all 
      yfeng     02/02/05 - Fix bug 4155126 - get rid of Generate Top SQL 
                           Report button 
      swexler   12/22/04 - 
      swexler   10/29/04 - 
      yfeng     10/21/04 - Fix bug 3090652 - by removing partialRenderMode
                           in oem:table 
      yfeng     10/15/04 - Show no data when the table is empty
--%>

<db:form name="foo" destination="/console/database/instance/topSqls"
         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="PERIOD_SQL@ResourceBundle@servletRequest"/>

  <uix:switcher childNameBinding="intervalLessThan1Day@waitsBean@servletRequest">
  <uix:case name="false">
    <uix:stackLayout>
      <uix:header size="1"
        textBinding="HIST_INTERVAL_SELECTION@ResourceBundle@servletRequest" />
          <uix:switcher childNameBinding="useSVG@topSqlsBean@servletRequest">
          <uix:case name="true">
            <uix:tableLayout>
              <uix:rowLayout hAlign="left">
                <uix:messagePrompt promptBinding="HIST_PICKER_INSTR_1DAY@DBMsgBundle@servletRequest" />
              </uix:rowLayout>
            </uix:tableLayout>
          </uix:case>
          <uix:case name="false">
            <uix:tableLayout>
              <uix:rowLayout hAlign="left">
                <uix:messagePrompt promptBinding="TIME_BAND_24HOUR_INSTR@DBMsgBundle@servletRequest" />
              </uix:rowLayout>
            </uix:tableLayout> 
          </uix:case>
          </uix:switcher>
       </uix:stackLayout>
    </uix:case>
  </uix:switcher>

  <uix:switcher childNameBinding="showData@waitsBean@servletRequest">
  <uix:case name="true">
   <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"
        xAxisMinBinding="beginDate@waitsBean@servletRequest"
        xAxisMaxBinding="endDate@waitsBean@servletRequest"
        colorPaletteBinding="nonStaticPickerColors@waitsChart@waitsBean@servletRequest"
        axisMaxBinding="maxValue@waitsBean@servletRequest"
        svgHighlightLegend="true"
        svgTimebandTipBinding="WAIT_DETAIL_SELECTOR_TIP@DBMsgBundle@servletRequest"
      >
      <uix:contents>
        <oem:timeSelector
          xAxisMinBinding="beginDate@waitsBean@servletRequest"
          xAxisMaxBinding="endDate@waitsBean@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"
          xAxisScrollDest="scroll_timechart"
          xAxisScrollDestType="JavaScript"
          xAxisScrollPrev="true"
          xAxisScrollPrevAltTextBinding="GO_BACKWARD@DBMsgBundle@servletRequest" 
          xAxisScrollNext="true"
          xAxisScrollNextAltTextBinding="GO_FORWARD@DBMsgBundle@servletRequest" 
          selectionIndicator="shading"
          dynamicTimeSelectorColorBinding="sliderColor@waitsChart@waitsBean@servletRequest"
          dynamicTimeSelectorEdgeColorBinding="sliderEdgeColor@waitsChart@waitsBean@servletRequest"
        >
        </oem:timeSelector>
        <oem:boundChartDataSource 
          chartDataSourceBinding="chartDataSource@waitsBean@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:switcher>

                   
    <%-- Period SQL table --%>
    <uix:switcher childNameBinding="node@topSqlsBean@servletRequest">
    <uix:case name="okNode">

      <uix:tableLayout width="100%">
        <uix:stackLayout>
          <uix:header size="1"
            textBinding="HIST_24HOUR_DETAIL_HDR@DBMsgBundle@servletRequest"/>
          <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="beginSnapshotTime@topSqlsBean@servletRequest"/>
              </uix:cellFormat>
          </uix:rowLayout>
        </uix:stackLayout>
        
        <oem:table name="twoDUIDataSource"
                    summaryBinding="PERIOD_SQL@ResourceBundle@servletRequest"
                    id="theTopSqlTable"
                    blockSize="25"
                    beanKey="dataSourceBean"
                    formSubmitted="true"
                    dataSourceProp="twoDUIDataSource"
                    alternateTextBinding="TABLE_NO_DATA@dbMsg"
                    showAll="yes"
                    width="100%">
          <uix:tableSelection>
              
            <uix:multipleSelection
              selectedBinding="selected"
              shortDescBinding="SELECT@ResourceBundle@servletRequest"
              selectionBinding="selection@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:tableLayout>
        </uix:case>

          <!-- Error message -->
          <uix:case name="errNode">
            <uix:styledText textBinding="noData@topSqlsBean@servletRequest"/>
            <!-- <include baja:node="errMessage" /> -->
          </uix:case>

          <uix:case name="emptyNode">
            <!-- <html:em> -->
            <uix:styledText textBinding="noData@topSqlsBean@servletRequest"/>
            <!-- </html:em> -->
          </uix:case>

        </uix:switcher>
     


   <%@ include file="/database/instance/monitoringLinks.jspf" %>

</db:form>