Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\database\sqlaccess\revsumminc.jspf
<%-- -- Page: revsumminc.jspf -- Included by: reviewRec.jsp -- Controller: oracle.sysman.db.util.SqlAccessController -- -- Description: Displays summary of task results -- -- MODIFIED (MM/DD/YY) -- misun 03/06/07 - fix SQL Access Advisor UI Exit Review bugs. -- misun 01/05/07 - XbranchMerge misun_bug-5675432 from main -- misun 12/14/06 - fix bug 5675432 -- misun 11/20/06 - add the partitioned summary for tables -- misun 09/29/06 - fix bug 5485765 -- misun 07/31/06 - Add new features: 17610 SQL Advisor - SAA -- Enhancement 11gR1. -- mpawelko 05/16/05 - bug 4372883: show sql not associated with recs -- mpawelko 03/28/05 - add PPR for Hide/Show headers -- mpawelko 10/16/04 - don't hardcode url prefix in images -- mpawelko 08/07/04 - use 2 bars on wkld io graph -- mpawelko 07/31/04 - add latest server team adjustments -- mpawelko 07/24/04 - impl new charts (after server review) -- mpawelko 07/10/04 - make server team edits -- mpawelko 07/05/04 - mpawelko_add_aa_summary_page -- mpawelko 05/24/04 - created --%> <uix:stackLayout> <uix:header textBinding= "SUMM_WKLDPERF@AAMsgs"> <uix:spacer height="10"/> <%-- OVERALL WORKLOAD PERFORMANCE --%> <uix:rowLayout> <uix:switcher childNameBinding ="summStatusIndicator@objectBean@servletRequest" renderedBinding="isNotEvalOnly@objectBean@servletRequest" > <uix:case name="0" > <uix:flowLayout> <uix:image id="icon0" shortDescBinding="SUMM_SUCCESS@AAMsgs" sourceBinding="successIcon@objectBean@servletRequest" /> <uix:spacer width="5"/> <uix:styledText textBinding= "SUMM_WKLDGREEN@AAMsgs" styleClass="OraInstructionTextStrong" /> </uix:flowLayout> </uix:case> <uix:case name="1" > <uix:flowLayout> <uix:image id="icon1" shortDescBinding="SUMM_WARNING@AAMsgs" sourceBinding="infoIcon@objectBean@servletRequest" /> <uix:spacer width="5"/> <uix:styledText textBinding= "SUMM_WKLDYELLOW@AAMsgs" styleClass="OraInstructionTextStrong" /> </uix:flowLayout> </uix:case> <uix:case name="2" > <uix:flowLayout> <uix:image id="icon2" shortDescBinding="SUMM_FAILURE@AAMsgs" sourceBinding="failureIcon@objectBean@servletRequest" /> <uix:spacer width="5"/> <uix:styledText textBinding= "SUMM_WKLDRED@AAMsgs" styleClass="OraInstructionTextStrong" /> </uix:flowLayout> </uix:case> </uix:switcher> <uix:messageStyledText styleClass="OraDataText" messageType="info" textBinding="EVAL_ONLY_MODE@AAMsgs" renderedBinding="isEvalOnly@objectBean@servletRequest" /> </uix:rowLayout> </uix:header> <uix:spacer height="10" /> <uix:tableLayout> <uix:rowLayout> <uix:cellFormat vAlign="top" hAlign="left" width="50%"> <oem:chart titleBinding="SUMM_WKLD_IO_COST@AAMsgs" shortDescBinding="SUMM_WKLD_IO_COST@AAMsgs" chartType="barChart" width="150" height="150" showXAxisLabels="false" shadowEffect="3d" legendVisible="external" externalLegendOrientation="vertical" legendPosition="south" > <oem:boundChartDataSource chartDataSourceBinding="sqlBreakdownDataSource@objectBean@servletRequest" /> <oem:imageMap defaultLabel="false" /> <oem:chartColumn displayLabelBinding="origCostLabel@objectBean@servletRequest" sourceIndex="0" itemColor="red" /> <oem:chartColumn displayLabelBinding="newCostLabel@objectBean@servletRequest" sourceIndex="1" itemColor="blue" /> </oem:chart> </uix:cellFormat> <uix:cellFormat vAlign="top" hAlign="right" width="50%"> <oem:chart titleBinding="SUMM_QUERY_RESP_IMPR@AAMsgs" chartType="barChart" width="450" height="150" axisMax="100" shadowEffect="3d" stacked="true" legendVisible="external" externalLegendOrientation="vertical" legendPosition="south" xAxisLabelBinding="SUMM_QUERY_SPEEDUP@AAMsgs" yAxisLabelBinding="SUMM_PERC_WORKLOAD@AAMsgs" > <oem:boundChartDataSource chartDataSourceBinding="sqlRangeDataSource@objectBean@servletRequest" /> <oem:imageMap defaultLabel="true" /> <oem:chartColumn isKey="true" displayLabelBinding="SUMM_QUERY_SPEEDUP@AAMsgs" sourceIndex="0" /> <oem:chartColumn displayLabelBinding="SUMM_SQLIMPR@AAMsgs" sourceIndex="1" itemColor="blue" /> <oem:chartColumn displayLabelBinding="SUMM_NO_IMPR@AAMsgs" sourceIndex="2" itemColor="gray" /> </oem:chart> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout > <uix:tableLayout> <uix:rowLayout> <uix:cellFormat vAlign="top" hAlign="left" width="50%"> <uix:header textBinding= "REVREC_REC@AAMsgs"> <uix:labeledFieldLayout width="50%" labelWidth="25%"> <uix:messagePrompt vAlign="top" promptBinding="SUMM_RECTOTAL@AAMsgs" /> <db:link textBinding="summRecCount@objectBean@servletRequest" shortDescBinding="SUMM_RECTOTAL@AAMsgs" onClick="submitForm('review', true, {event:'recViewChange2'})" copyParams="target,type,advisoryCentralURL,dbPageNum" /> <%-- <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_AVG_COST_REC@AAMsgs" vAlign="top" textBinding="summRecImprovement@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_AVG_COST_WKLD@AAMsgs" vAlign="top" textBinding="summWorkloadImprovement@objectBean@servletRequest" /> --%> <uix:messageStyledText styleClass="OraDataText" promptBinding="summStorageChangeLabel@objectBean@servletRequest" vAlign="top" textBinding="summStorageChange@objectBean@servletRequest" /> <uix:styledText textBinding="SUMM_USER_SPACE_REQ@AAMsgs" renderedBinding="isNotEvalOnly@objectBean@servletRequest" styleClass="OraInlineInfoText" /> <uix:styledText textBinding="storageSizeMsg@objectBean@servletRequest" renderedBinding="isNotEvalOnly@objectBean@servletRequest" styleClass="OraInlineInfoText" /> </uix:labeledFieldLayout> <uix:hideShow id="recCountHideShow" undisclosedTextBinding="SUMM_SHOW_REC_BKDWN@AAMsgs" disclosedTextBinding="SUMM_HIDE_REC_BKDWN@AAMsgs" disclosedBinding="showRecBreakdown@objectBean@servletRequest" formName="review" partialRenderMode="self" formSubmitted="true" > <uix:labeledFieldLayout width="50%" labelWidth="20%" columns="4"> <uix:messageStyledText styleClass="OraDataText" promptBinding="ACTION_TYPES_INDEX@AAMsgs" text=":" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_CREATE@AAMsgs" textBinding="summICreates@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_DROP@AAMsgs" textBinding="summIDrops@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_RETAIN@AAMsgs" textBinding="summIRetains@objectBean@servletRequest" /> <%--uix:messageStyledText styleClass="OraDataText" prompt="" text="" /--%> <uix:messageStyledText styleClass="OraDataText" promptBinding="ACTION_TYPES_MVS@AAMsgs" text=":" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_CREATE@AAMsgs" textBinding="summMVCreates@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_DROP@AAMsgs" textBinding="summMVDrops@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_RETAIN@AAMsgs" textBinding="summMVRetains@objectBean@servletRequest" /> <%--uix:messageStyledText styleClass="OraDataText" prompt="" text="" /--%> <uix:messageStyledText styleClass="OraDataText" promptBinding="ACTION_TYPES_MV_LOGS@AAMsgs" text=":" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_CREATE@AAMsgs" textBinding="summMVLCreates@objectBean@servletRequest" /> <%--uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_DROP@AAMsgs" textBinding="summMVLDrops@objectBean@servletRequest" /--%> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_RETAIN@AAMsgs" textBinding="summMVLRetains@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_ALTER@AAMsgs" textBinding="summMVLAlters@objectBean@servletRequest" /> <%--uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_REPARTITION@AAMsgs" renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest" text=":" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_TABLES@AAMsgs" renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest" textBinding="summRepartitionTables@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_INDEXES@AAMsgs" renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest" textBinding="summRepartitionIndexes@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_MVS@AAMsgs" renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest" textBinding="summRepartitionMVs@objectBean@servletRequest" /--%> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_PARTITIONS@AAMsgs" renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest" text=":" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_TABLES@AAMsgs" renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest" textBinding="summRepartitionTables@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_INDEXES@AAMsgs" renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest" textBinding="summPartitionedIndexes@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_MVS@AAMsgs" renderedBinding="versionEqualOrHigher11g@objectBean@servletRequest" textBinding="summPartitionedMVs@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" prompt="" text="" /> </uix:labeledFieldLayout> </uix:hideShow> </uix:header> </uix:cellFormat> <uix:cellFormat vAlign="top" hAlign="right" width="35%"> <uix:header textBinding= "REVREC_VIEWSQL@AAMsgs"> <%-- SQL STATEMENT BREAKDOWN --%> <uix:stackLayout> <uix:flowLayout> <uix:messagePrompt vAlign="top" promptBinding="REVREC_VIEWSQL@AAMsgs" /> <uix:spacer width="10" height="0" /> <db:link textBinding="summStmtTotal@objectBean@servletRequest" shortDescBinding="REVREC_VIEWSQL@AAMsgs" onClick="submitForm('review', true, {event:'recViewChange3AllSQL'})" copyParams="target,type,advisoryCentralURL,dbPageNum" /> </uix:flowLayout> <uix:flowLayout> <uix:spacer width="8" height="0" /> <uix:styledText textBinding="SUMM_SQLPROCTIP@AAMsgs" styleClass="OraInlineInfoText" /> </uix:flowLayout> <uix:hideShow id="stmtHideShow" undisclosedTextBinding="SUMM_SHOW_STMT_BKDWN@AAMsgs" disclosedTextBinding="SUMM_HIDE_STMT_BKDWN@AAMsgs" disclosedBinding="showStmtBreakdown@objectBean@servletRequest" formName="review" partialRenderMode="self" formSubmitted="true" > <uix:labeledFieldLayout width="75%" labelWidth="20%"> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_INSERT@AAMsgs" textBinding="summStmtInsert@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_SELECT@AAMsgs" textBinding="summStmtSelect@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_UPDATE@AAMsgs" textBinding="summStmtUpdate@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_DELETE@AAMsgs" textBinding="summStmtDelete@objectBean@servletRequest" /> <uix:messageStyledText styleClass="OraDataText" promptBinding="SUMM_MERGE@AAMsgs" textBinding="summStmtMerge@objectBean@servletRequest" /> <%--uix:messageStyledText styleClass="OraDataText" renderedBinding="is10gR2OrHigher@objectBean@servletRequest" promptBinding="SUMM_SKIP_NO_STATS@AAMsgs" textBinding="summStmtSkipStats@objectBean@servletRequest" /--%> <uix:messageStyledText styleClass="OraDataText" renderedBinding="is10gR2OrHigher@objectBean@servletRequest" promptBinding="SUMM_SKIP_NO_PRIVS@AAMsgs" textBinding="summStmtSkipPrivs@objectBean@servletRequest" /> </uix:labeledFieldLayout> </uix:hideShow> </uix:stackLayout> </uix:header> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout > </uix:stackLayout>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de