Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\target.db
<?xml version="1.0" encoding="UTF-8"?> <div element="book" href="toc.htm" number="" targetptr=""> <ttl>Oracle® Database 2 Day + Performance Tuning Guide</ttl> <xreftext><cite>Oracle® Database 2 Day + Performance Tuning Guide</cite></xreftext> <div element="chapter" href="tdppt_intro.htm" number="1" targetptr="TDPPT002"> <ttl>Introduction</ttl> <xreftext>“Introduction”</xreftext> <div element="sect1" href="tdppt_intro001.htm" number="1.1" targetptr="TDPPT005"> <ttl>Tools for Tuning the Database</ttl> <xreftext>“Tools for Tuning the Database”</xreftext> </div> </div> <div element="chapter" href="tdppt_method.htm" number="2" targetptr="TDPPT006"> <ttl>Oracle Database Performance Method</ttl> <xreftext>“Oracle Database Performance Method”</xreftext> <div element="sect1" href="tdppt_method001.htm" number="2.1" targetptr="TDPPT007"> <ttl>Gathering Database Statistics Using the Automatic Workload Repository</ttl> <xreftext>“Gathering Database Statistics Using the Automatic Workload Repository”</xreftext> <div element="sect2" href="tdppt_method002.htm" number="2.1.1" targetptr="TDPPT008"> <ttl>Time Model Statistics</ttl> <xreftext>“Time Model Statistics”</xreftext> <obj element="figure" href="tdppt_method002.htm" number="2-1" targetptr="TDPPT345"> <ttl>DB Time in Overall User Response Time</ttl> <xreftext>“DB Time in Overall User Response Time”</xreftext> </obj> <obj element="figure" href="tdppt_method002.htm" number="2-2" targetptr="TDPPT346"> <ttl>DB Time in User Transaction</ttl> <xreftext>“DB Time in User Transaction”</xreftext> </obj> </div> <div element="sect2" href="tdppt_method003.htm" number="2.1.2" targetptr="TDPPT009"> <ttl>Wait Event Statistics</ttl> <xreftext>“Wait Event Statistics”</xreftext> </div> <div element="sect2" href="tdppt_method004.htm" number="2.1.3" targetptr="TDPPT010"> <ttl>Session and System Statistics</ttl> <xreftext>“Session and System Statistics”</xreftext> </div> <div element="sect2" href="tdppt_method005.htm" number="2.1.4" targetptr="TDPPT011"> <ttl>Active Session History Statistics</ttl> <xreftext>“Active Session History Statistics”</xreftext> <obj element="figure" href="tdppt_method005.htm" number="2-3" targetptr="TDPPT347"> <ttl>Active Session History</ttl> <xreftext>“Active Session History”</xreftext> </obj> <obj element="table" href="tdppt_method005.htm" number="2-1" targetptr="TDPPT348"> <ttl>Active Session History</ttl> <xreftext>“Active Session History”</xreftext> </obj> </div> <div element="sect2" href="tdppt_method006.htm" number="2.1.5" targetptr="TDPPT012"> <ttl>High-Load SQL Statistics</ttl> <xreftext>“High-Load SQL Statistics”</xreftext> </div> </div> <div element="sect1" href="tdppt_method007.htm" number="2.2" targetptr="TDPPT490"> <ttl>Using the Oracle Performance Method</ttl> <xreftext>“Using the Oracle Performance Method”</xreftext> <div element="sect2" href="tdppt_method008.htm" number="2.2.1" targetptr="TDPPT491"> <ttl>Preparing the Database for Tuning</ttl> <xreftext>“Preparing the Database for Tuning”</xreftext> </div> <div element="sect2" href="tdppt_method009.htm" number="2.2.2" targetptr="TDPPT492"> <ttl>Tuning the Database Proactively</ttl> <xreftext>“Tuning the Database Proactively”</xreftext> </div> <div element="sect2" href="tdppt_method010.htm" number="2.2.3" targetptr="TDPPT493"> <ttl>Tuning the Database Reactively</ttl> <xreftext>“Tuning the Database Reactively”</xreftext> </div> <div element="sect2" href="tdppt_method011.htm" number="2.2.4" targetptr="TDPPT494"> <ttl>Tuning SQL Statements</ttl> <xreftext>“Tuning SQL Statements”</xreftext> </div> </div> <div element="sect1" href="tdppt_method012.htm" number="2.3" targetptr="TDPPT018"> <ttl>Common Performance Problems Found in Oracle Databases</ttl> <xreftext>“Common Performance Problems Found in Oracle Databases”</xreftext> </div> </div> <div element="chapter" href="tdppt_auto.htm" number="3" targetptr="TDPPT020"> <ttl>Automatic Database Performance Monitoring</ttl> <xreftext>“Automatic Database Performance Monitoring”</xreftext> <div element="sect1" href="tdppt_auto001.htm" number="3.1" targetptr="TDPPT021"> <ttl>Overview of Automatic Database Diagnostic Monitor</ttl> <xreftext>“Overview of Automatic Database Diagnostic Monitor”</xreftext> <div element="sect2" href="tdppt_auto002.htm" number="3.1.1" targetptr="TDPPT300"> <ttl>ADDM Analysis</ttl> <xreftext>“ADDM Analysis”</xreftext> </div> <div element="sect2" href="tdppt_auto003.htm" number="3.1.2" targetptr="TDPPT301"> <ttl>ADDM Recommendations</ttl> <xreftext>“ADDM Recommendations”</xreftext> </div> <div element="sect2" href="tdppt_auto004.htm" number="3.1.3" targetptr="TDPPT302"> <ttl>ADDM for Oracle Real Application Clusters</ttl> <xreftext>“ADDM for Oracle Real Application Clusters”</xreftext> </div> </div> <div element="sect1" href="tdppt_auto005.htm" number="3.2" targetptr="TDPPT022"> <ttl>Configuring Automatic Database Diagnostic Monitor</ttl> <xreftext>“Configuring Automatic Database Diagnostic Monitor”</xreftext> <div element="sect2" href="tdppt_auto006.htm" number="3.2.1" targetptr="TDPPT023"> <ttl>Setting Initialization Parameters to Enable ADDM</ttl> <xreftext>“Setting Initialization Parameters to Enable ADDM”</xreftext> </div> <div element="sect2" href="tdppt_auto007.htm" number="3.2.2" targetptr="TDPPT024"> <ttl>Setting the DBIO_EXPECTED Parameter</ttl> <xreftext>“Setting the DBIO_EXPECTED Parameter”</xreftext> </div> <div element="sect2" href="tdppt_auto008.htm" number="3.2.3" targetptr="TDPPT025"> <ttl>Managing AWR Snapshots</ttl> <xreftext>“Managing AWR Snapshots”</xreftext> <div element="sect3" href="tdppt_auto009.htm" number="3.2.3.1" targetptr="TDPPT026"> <ttl>Creating Snapshots</ttl> <xreftext>“Creating Snapshots”</xreftext> </div> <div element="sect3" href="tdppt_auto010.htm" number="3.2.3.2" targetptr="TDPPT027"> <ttl>Modifying Snapshot Settings</ttl> <xreftext>“Modifying Snapshot Settings”</xreftext> </div> </div> </div> <div element="sect1" href="tdppt_auto011.htm" number="3.3" targetptr="TDPPT029"> <ttl>Reviewing the Automatic Database Diagnostic Monitor Analysis</ttl> <xreftext>“Reviewing the Automatic Database Diagnostic Monitor Analysis”</xreftext> </div> <div element="sect1" href="tdppt_auto012.htm" number="3.4" targetptr="TDPPT030"> <ttl>Interpretation of Automatic Database Diagnostic Monitor Findings</ttl> <xreftext>“Interpretation of Automatic Database Diagnostic Monitor Findings”</xreftext> </div> <div element="sect1" href="tdppt_auto013.htm" number="3.5" targetptr="TDPPT031"> <ttl>Implementing Automatic Database Diagnostic Monitor Recommendations</ttl> <xreftext>“Implementing Automatic Database Diagnostic Monitor Recommendations”</xreftext> </div> <div element="sect1" href="tdppt_auto014.htm" number="3.6" targetptr="TDPPT032"> <ttl>Viewing Snapshot Statistics</ttl> <xreftext>“Viewing Snapshot Statistics”</xreftext> </div> </div> <div element="chapter" href="tdppt_realtime.htm" number="4" targetptr="TDPPT033"> <ttl>Monitoring Real-Time Database Performance</ttl> <xreftext>“Monitoring Real-Time Database Performance”</xreftext> <div element="sect1" href="tdppt_realtime001.htm" number="4.1" targetptr="TDPPT034"> <ttl>Monitoring User Activity</ttl> <xreftext>“Monitoring User Activity”</xreftext> <div element="sect2" href="tdppt_realtime002.htm" number="4.1.1" targetptr="TDPPT035"> <ttl>Monitoring Top SQL</ttl> <xreftext>“Monitoring Top SQL”</xreftext> </div> <div element="sect2" href="tdppt_realtime003.htm" number="4.1.2" targetptr="TDPPT036"> <ttl>Monitoring Top Sessions</ttl> <xreftext>“Monitoring Top Sessions”</xreftext> </div> <div element="sect2" href="tdppt_realtime004.htm" number="4.1.3" targetptr="TDPPT037"> <ttl>Monitoring Top Services</ttl> <xreftext>“Monitoring Top Services”</xreftext> </div> <div element="sect2" href="tdppt_realtime005.htm" number="4.1.4" targetptr="TDPPT038"> <ttl>Monitoring Top Modules</ttl> <xreftext>“Monitoring Top Modules”</xreftext> </div> <div element="sect2" href="tdppt_realtime006.htm" number="4.1.5" targetptr="TDPPT039"> <ttl>Monitoring Top Actions</ttl> <xreftext>“Monitoring Top Actions”</xreftext> </div> <div element="sect2" href="tdppt_realtime007.htm" number="4.1.6" targetptr="TDPPT303"> <ttl>Monitoring Top Clients</ttl> <xreftext>“Monitoring Top Clients”</xreftext> </div> <div element="sect2" href="tdppt_realtime008.htm" number="4.1.7" targetptr="TDPPT304"> <ttl>Monitoring Top PL/SQL</ttl> <xreftext>“Monitoring Top PL/SQL”</xreftext> </div> <div element="sect2" href="tdppt_realtime009.htm" number="4.1.8" targetptr="TDPPT321"> <ttl>Monitoring Top Files</ttl> <xreftext>“Monitoring Top Files”</xreftext> </div> <div element="sect2" href="tdppt_realtime010.htm" number="4.1.9" targetptr="TDPPT322"> <ttl>Monitoring Top Objects</ttl> <xreftext>“Monitoring Top Objects”</xreftext> </div> </div> <div element="sect1" href="tdppt_realtime011.htm" number="4.2" targetptr="TDPPT040"> <ttl>Monitoring Instance Activity</ttl> <xreftext>“Monitoring Instance Activity”</xreftext> <div element="sect2" href="tdppt_realtime012.htm" number="4.2.1" targetptr="TDPPT325"> <ttl>Monitoring Throughput</ttl> <xreftext>“Monitoring Throughput”</xreftext> </div> <div element="sect2" href="tdppt_realtime013.htm" number="4.2.2" targetptr="TDPPT326"> <ttl>Monitoring I/O</ttl> <xreftext>“Monitoring I/O”</xreftext> <div element="sect3" href="tdppt_realtime014.htm" number="4.2.2.1" targetptr="TDPPT329"> <ttl>Monitoring I/O by Function</ttl> <xreftext>“Monitoring I/O by Function”</xreftext> </div> <div element="sect3" href="tdppt_realtime015.htm" number="4.2.2.2" targetptr="TDPPT330"> <ttl>Monitoring I/O by Type</ttl> <xreftext>“Monitoring I/O by Type”</xreftext> </div> <div element="sect3" href="tdppt_realtime016.htm" number="4.2.2.3" targetptr="TDPPT331"> <ttl>Monitoring I/O by Consumer Group</ttl> <xreftext>“Monitoring I/O by Consumer Group”</xreftext> </div> </div> <div element="sect2" href="tdppt_realtime017.htm" number="4.2.3" targetptr="TDPPT327"> <ttl>Monitoring Parallel Execution</ttl> <xreftext>“Monitoring Parallel Execution”</xreftext> </div> <div element="sect2" href="tdppt_realtime018.htm" number="4.2.4" targetptr="TDPPT328"> <ttl>Monitoring Services</ttl> <xreftext>“Monitoring Services”</xreftext> </div> </div> <div element="sect1" href="tdppt_realtime019.htm" number="4.3" targetptr="TDPPT041"> <ttl>Monitoring Host Activity</ttl> <xreftext>“Monitoring Host Activity”</xreftext> <div element="sect2" href="tdppt_realtime020.htm" number="4.3.1" targetptr="TDPPT042"> <ttl>Monitoring CPU Utilization</ttl> <xreftext>“Monitoring CPU Utilization”</xreftext> </div> <div element="sect2" href="tdppt_realtime021.htm" number="4.3.2" targetptr="TDPPT043"> <ttl>Monitoring Memory Utilization</ttl> <xreftext>“Monitoring Memory Utilization”</xreftext> </div> <div element="sect2" href="tdppt_realtime022.htm" number="4.3.3" targetptr="TDPPT044"> <ttl>Monitoring Disk I/O Utilization</ttl> <xreftext>“Monitoring Disk I/O Utilization”</xreftext> </div> </div> <div element="sect1" href="tdppt_realtime023.htm" number="4.4" targetptr="TDPPT313"> <ttl>Customizing the Database Performance Page</ttl> <xreftext>“Customizing the Database Performance Page”</xreftext> </div> </div> <div element="chapter" href="tdppt_alerts.htm" number="5" targetptr="TDPPT045"> <ttl>Monitoring Performance Alerts</ttl> <xreftext>“Monitoring Performance Alerts”</xreftext> <div element="sect1" href="tdppt_alerts001.htm" number="5.1" targetptr="TDPPT046"> <ttl>Setting Metric Thresholds for Performance Alerts</ttl> <xreftext>“Setting Metric Thresholds for Performance Alerts”</xreftext> </div> <div element="sect1" href="tdppt_alerts002.htm" number="5.2" targetptr="TDPPT047"> <ttl>Responding to Alerts</ttl> <xreftext>“Responding to Alerts”</xreftext> </div> <div element="sect1" href="tdppt_alerts003.htm" number="5.3" targetptr="TDPPT048"> <ttl>Clearing Alerts</ttl> <xreftext>“Clearing Alerts”</xreftext> </div> </div> <div element="chapter" href="tdppt_manual.htm" number="6" targetptr="TDPPT050"> <ttl>Manual Database Performance Monitoring</ttl> <xreftext>“Manual Database Performance Monitoring”</xreftext> <div element="sect1" href="tdppt_manual001.htm" number="6.1" targetptr="TDPPT051"> <ttl>Manually Running ADDM to Analyze Current Database Performance</ttl> <xreftext>“Manually Running ADDM to Analyze Current Database Performance”</xreftext> </div> <div element="sect1" href="tdppt_manual002.htm" number="6.2" targetptr="TDPPT052"> <ttl>Manually Running ADDM to Analyze Historical Database Performance</ttl> <xreftext>“Manually Running ADDM to Analyze Historical Database Performance”</xreftext> </div> <div element="sect1" href="tdppt_manual003.htm" number="6.3" targetptr="TDPPT053"> <ttl>Accessing Previous ADDM Results</ttl> <xreftext>“Accessing Previous ADDM Results”</xreftext> </div> </div> <div element="chapter" href="tdppt_transient.htm" number="7" targetptr="TDPPT064"> <ttl>Resolving Transient Performance Problems</ttl> <xreftext>“Resolving Transient Performance Problems”</xreftext> <div element="sect1" href="tdppt_transient001.htm" number="7.1" targetptr="TDPPT065"> <ttl>Overview of Active Session History</ttl> <xreftext>“Overview of Active Session History”</xreftext> </div> <div element="sect1" href="tdppt_transient002.htm" number="7.2" targetptr="TDPPT066"> <ttl>Running Active Session History Reports</ttl> <xreftext>“Running Active Session History Reports”</xreftext> </div> <div element="sect1" href="tdppt_transient003.htm" number="7.3" targetptr="TDPPT067"> <ttl>Active Session History Reports</ttl> <xreftext>“Active Session History Reports”</xreftext> <div element="sect2" href="tdppt_transient004.htm" number="7.3.1" targetptr="TDPPT068"> <ttl>Top Events</ttl> <xreftext>“Top Events”</xreftext> <div element="sect3" href="tdppt_transient005.htm" number="7.3.1.1" targetptr="TDPPT069"> <ttl>Top User Events</ttl> <xreftext>“Top User Events”</xreftext> </div> <div element="sect3" href="tdppt_transient006.htm" number="7.3.1.2" targetptr="TDPPT070"> <ttl>Top Background Events</ttl> <xreftext>“Top Background Events”</xreftext> </div> </div> <div element="sect2" href="tdppt_transient007.htm" number="7.3.2" targetptr="TDPPT072"> <ttl>Load Profile</ttl> <xreftext>“Load Profile”</xreftext> </div> <div element="sect2" href="tdppt_transient008.htm" number="7.3.3" targetptr="TDPPT076"> <ttl>Top SQL</ttl> <xreftext>“Top SQL”</xreftext> </div> <div element="sect2" href="tdppt_transient009.htm" number="7.3.4" targetptr="TDPPT080"> <ttl>Top Sessions</ttl> <xreftext>“Top Sessions”</xreftext> </div> <div element="sect2" href="tdppt_transient010.htm" number="7.3.5" targetptr="TDPPT085"> <ttl>Top DB Objects</ttl> <xreftext>“Top DB Objects”</xreftext> </div> <div element="sect2" href="tdppt_transient011.htm" number="7.3.6" targetptr="TDPPT086"> <ttl>Top DB Files</ttl> <xreftext>“Top DB Files”</xreftext> </div> <div element="sect2" href="tdppt_transient012.htm" number="7.3.7" targetptr="TDPPT088"> <ttl>Activity Over Time</ttl> <xreftext>“Activity Over Time”</xreftext> <obj element="table" href="tdppt_transient012.htm" number="7-1" targetptr="TDPPT419"> <ttl>Activity Over Time</ttl> <xreftext>“Activity Over Time”</xreftext> </obj> </div> </div> </div> <div element="chapter" href="tdppt_degrade.htm" number="8" targetptr="TDPPT089"> <ttl>Resolving Performance Degradation Over Time</ttl> <xreftext>“Resolving Performance Degradation Over Time”</xreftext> <div element="sect1" href="tdppt_degrade001.htm" number="8.1" targetptr="TDPPT230"> <ttl>Managing Baselines</ttl> <xreftext>“Managing Baselines”</xreftext> <div element="sect2" href="tdppt_degrade002.htm" number="8.1.1" targetptr="TDPPT231"> <ttl>Creating a Baseline</ttl> <xreftext>“Creating a Baseline”</xreftext> <div element="sect3" href="tdppt_degrade003.htm" number="8.1.1.1" targetptr="TDPPT232"> <ttl>Creating a Single Baseline</ttl> <xreftext>“Creating a Single Baseline”</xreftext> </div> <div element="sect3" href="tdppt_degrade004.htm" number="8.1.1.2" targetptr="TDPPT233"> <ttl>Creating a Repeating Baseline</ttl> <xreftext>“Creating a Repeating Baseline”</xreftext> </div> </div> <div element="sect2" href="tdppt_degrade005.htm" number="8.1.2" targetptr="TDPPT234"> <ttl>Deleting a Baseline</ttl> <xreftext>“Deleting a Baseline”</xreftext> </div> <div element="sect2" href="tdppt_degrade006.htm" number="8.1.3" targetptr="TDPPT235"> <ttl>Computing Threshold Statistics for Baselines</ttl> <xreftext>“Computing Threshold Statistics for Baselines”</xreftext> </div> <div element="sect2" href="tdppt_degrade007.htm" number="8.1.4" targetptr="TDPPT332"> <ttl>Setting Metric Thresholds for Baselines</ttl> <xreftext>“Setting Metric Thresholds for Baselines”</xreftext> <div element="sect3" href="tdppt_degrade008.htm" number="8.1.4.1" targetptr="TDPPT333"> <ttl>Setting Metric Thresholds for the Default Moving Baseline</ttl> <xreftext>“Setting Metric Thresholds for the Default Moving Baseline”</xreftext> </div> <div element="sect3" href="tdppt_degrade009.htm" number="8.1.4.2" targetptr="TDPPT334"> <ttl>Setting Metric Thresholds for Selected Baselines</ttl> <xreftext>“Setting Metric Thresholds for Selected Baselines”</xreftext> </div> </div> </div> <div element="sect1" href="tdppt_degrade010.htm" number="8.2" targetptr="TDPPT091"> <ttl>Running the AWR Compare Periods Reports</ttl> <xreftext>“Running the AWR Compare Periods Reports”</xreftext> <div element="sect2" href="tdppt_degrade011.htm" number="8.2.1" targetptr="TDPPT137"> <ttl>Comparing a Baseline to Another Baseline or Pair of Snapshots</ttl> <xreftext>“Comparing a Baseline to Another Baseline or Pair of Snapshots”</xreftext> </div> <div element="sect2" href="tdppt_degrade012.htm" number="8.2.2" targetptr="TDPPT138"> <ttl>Comparing Two Pairs of Snapshots</ttl> <xreftext>“Comparing Two Pairs of Snapshots”</xreftext> </div> </div> <div element="sect1" href="tdppt_degrade013.htm" number="8.3" targetptr="TDPPT092"> <ttl>Using the AWR Compare Periods Reports</ttl> <xreftext>“Using the AWR Compare Periods Reports”</xreftext> <div element="sect2" href="tdppt_degrade014.htm" number="8.3.1" targetptr="TDPPT093"> <ttl>Summary of the AWR Compare Periods Report</ttl> <xreftext>“Summary of the AWR Compare Periods Report”</xreftext> <div element="sect3" href="tdppt_degrade015.htm" number="8.3.1.1" targetptr="TDPPT094"> <ttl>Snapshot Sets</ttl> <xreftext>“Snapshot Sets”</xreftext> </div> <div element="sect3" href="tdppt_degrade016.htm" number="8.3.1.2" targetptr="TDPPT096"> <ttl>Load Profile</ttl> <xreftext>“Load Profile”</xreftext> </div> <div element="sect3" href="tdppt_degrade017.htm" number="8.3.1.3" targetptr="TDPPT097"> <ttl>Top Timed Events</ttl> <xreftext>“Top Timed Events”</xreftext> </div> <div element="sect3" href="tdppt_degrade018.htm" number="8.3.1.4" targetptr="TDPPT095"> <ttl>Host Configuration Comparison</ttl> <xreftext>“Host Configuration Comparison”</xreftext> </div> <div element="sect3" href="tdppt_degrade019.htm" number="8.3.1.5" targetptr="TDPPT314"> <ttl>System Configuration Comparison</ttl> <xreftext>“System Configuration Comparison”</xreftext> </div> </div> <div element="sect2" href="tdppt_degrade020.htm" number="8.3.2" targetptr="TDPPT315"> <ttl>Details of the AWR Compare Periods Report</ttl> <xreftext>“Details of the AWR Compare Periods Report”</xreftext> </div> <div element="sect2" href="tdppt_degrade021.htm" number="8.3.3" targetptr="TDPPT319"> <ttl>Supplemental Information in the AWR Compare Periods Report</ttl> <xreftext>“Supplemental Information in the AWR Compare Periods Report”</xreftext> </div> </div> </div> <div element="chapter" href="tdppt_sqlid.htm" number="9" targetptr="TDPPT140"> <ttl>Identifying High-Load SQL Statements</ttl> <xreftext>“Identifying High-Load SQL Statements”</xreftext> <div element="sect1" href="tdppt_sqlid001.htm" number="9.1" targetptr="TDPPT141"> <ttl>Identification of High-Load SQL Statements Using ADDM Findings</ttl> <xreftext>“Identification of High-Load SQL Statements Using ADDM Findings”</xreftext> </div> <div element="sect1" href="tdppt_sqlid002.htm" number="9.2" targetptr="TDPPT142"> <ttl>Identifying High-Load SQL Statements Using Top SQL</ttl> <xreftext>“Identifying High-Load SQL Statements Using Top SQL”</xreftext> <div element="sect2" href="tdppt_sqlid003.htm" number="9.2.1" targetptr="TDPPT143"> <ttl>Viewing SQL Statements by Wait Class</ttl> <xreftext>“Viewing SQL Statements by Wait Class”</xreftext> </div> <div element="sect2" href="tdppt_sqlid004.htm" number="9.2.2" targetptr="TDPPT144"> <ttl>Viewing Details of SQL Statements</ttl> <xreftext>“Viewing Details of SQL Statements”</xreftext> <div element="sect3" href="tdppt_sqlid005.htm" number="9.2.2.1" targetptr="TDPPT497"> <ttl>Viewing SQL Statistics</ttl> <xreftext>“Viewing SQL Statistics”</xreftext> <div element="sect4" href="tdppt_sqlid006.htm" number="9.2.2.1.1" targetptr="TDPPT499"> <ttl>SQL Statistics Summary</ttl> <xreftext>“SQL Statistics Summary”</xreftext> </div> <div element="sect4" href="tdppt_sqlid007.htm" number="9.2.2.1.2" targetptr="TDPPT500"> <ttl>General SQL Statistics</ttl> <xreftext>“General SQL Statistics”</xreftext> </div> <div element="sect4" href="tdppt_sqlid008.htm" number="9.2.2.1.3" targetptr="TDPPT501"> <ttl>Activity by Wait Statistics and Activity by Time Statistics</ttl> <xreftext>“Activity by Wait Statistics and Activity by Time Statistics”</xreftext> </div> <div element="sect4" href="tdppt_sqlid009.htm" number="9.2.2.1.4" targetptr="TDPPT502"> <ttl>Elapsed Time Breakdown Statistics</ttl> <xreftext>“Elapsed Time Breakdown Statistics”</xreftext> </div> <div element="sect4" href="tdppt_sqlid010.htm" number="9.2.2.1.5" targetptr="TDPPT503"> <ttl>Shared Cursors Statistics and Execution Statistics</ttl> <xreftext>“Shared Cursors Statistics and Execution Statistics”</xreftext> </div> <div element="sect4" href="tdppt_sqlid011.htm" number="9.2.2.1.6" targetptr="TDPPT504"> <ttl>Other SQL Statistics</ttl> <xreftext>“Other SQL Statistics”</xreftext> </div> </div> <div element="sect3" href="tdppt_sqlid012.htm" number="9.2.2.2" targetptr="TDPPT505"> <ttl>Viewing Session Activity</ttl> <xreftext>“Viewing Session Activity”</xreftext> </div> <div element="sect3" href="tdppt_sqlid013.htm" number="9.2.2.3" targetptr="TDPPT506"> <ttl>Viewing the SQL Execution Plan</ttl> <xreftext>“Viewing the SQL Execution Plan”</xreftext> </div> <div element="sect3" href="tdppt_sqlid014.htm" number="9.2.2.4" targetptr="TDPPT507"> <ttl>Viewing the Plan Control</ttl> <xreftext>“Viewing the Plan Control”</xreftext> </div> <div element="sect3" href="tdppt_sqlid015.htm" number="9.2.2.5" targetptr="TDPPT508"> <ttl>Viewing the Tuning History</ttl> <xreftext>“Viewing the Tuning History”</xreftext> </div> </div> </div> </div> <div element="chapter" href="tdppt_sqltune.htm" number="10" targetptr="TDPPT160"> <ttl>Tuning SQL Statements</ttl> <xreftext>“Tuning SQL Statements”</xreftext> <div element="sect1" href="tdppt_sqltune001.htm" number="10.1" targetptr="TDPPT161"> <ttl>Tuning SQL Statements Using SQL Tuning Advisor</ttl> <xreftext>“Tuning SQL Statements Using SQL Tuning Advisor”</xreftext> <div element="sect2" href="tdppt_sqltune002.htm" number="10.1.1" targetptr="TDPPT310"> <ttl>Tuning SQL Manually Using SQL Tuning Advisor</ttl> <xreftext>“Tuning SQL Manually Using SQL Tuning Advisor”</xreftext> </div> <div element="sect2" href="tdppt_sqltune003.htm" number="10.1.2" targetptr="TDPPT311"> <ttl>Viewing Automatic SQL Tuning Results</ttl> <xreftext>“Viewing Automatic SQL Tuning Results”</xreftext> </div> </div> <div element="sect1" href="tdppt_sqltune004.htm" number="10.2" targetptr="TDPPT164"> <ttl>Managing SQL Tuning Sets</ttl> <xreftext>“Managing SQL Tuning Sets”</xreftext> <div element="sect2" href="tdppt_sqltune005.htm" number="10.2.1" targetptr="TDPPT162"> <ttl>Creating a SQL Tuning Set</ttl> <xreftext>“Creating a SQL Tuning Set”</xreftext> <div element="sect3" href="tdppt_sqltune006.htm" number="10.2.1.1" targetptr="TDPPT165"> <ttl>Creating a SQL Tuning Set: Options</ttl> <xreftext>“Creating a SQL Tuning Set: Options”</xreftext> </div> <div element="sect3" href="tdppt_sqltune007.htm" number="10.2.1.2" targetptr="TDPPT166"> <ttl>Creating a SQL Tuning Set: Load Method</ttl> <xreftext>“Creating a SQL Tuning Set: Load Method”</xreftext> <div element="sect4" href="tdppt_sqltune008.htm" number="10.2.1.2.1" targetptr="TDPPT167"> <ttl>Loading Active SQL Statements Incrementally from the Cursor Cache</ttl> <xreftext>“Loading Active SQL Statements Incrementally from the Cursor Cache”</xreftext> </div> <div element="sect4" href="tdppt_sqltune009.htm" number="10.2.1.2.2" targetptr="TDPPT168"> <ttl>Loading SQL Statements from the Cursor Cache</ttl> <xreftext>“Loading SQL Statements from the Cursor Cache”</xreftext> </div> <div element="sect4" href="tdppt_sqltune010.htm" number="10.2.1.2.3" targetptr="TDPPT169"> <ttl>Loading SQL Statements from AWR Snapshots</ttl> <xreftext>“Loading SQL Statements from AWR Snapshots”</xreftext> </div> <div element="sect4" href="tdppt_sqltune011.htm" number="10.2.1.2.4" targetptr="TDPPT155"> <ttl>Loading SQL Statements from AWR Baselines</ttl> <xreftext>“Loading SQL Statements from AWR Baselines”</xreftext> </div> <div element="sect4" href="tdppt_sqltune012.htm" number="10.2.1.2.5" targetptr="TDPPT156"> <ttl>Loading SQL Statements from a User-Defined Workload</ttl> <xreftext>“Loading SQL Statements from a User-Defined Workload”</xreftext> </div> </div> <div element="sect3" href="tdppt_sqltune013.htm" number="10.2.1.3" targetptr="TDPPT157"> <ttl>Creating a SQL Tuning Set: Filter Options</ttl> <xreftext>“Creating a SQL Tuning Set: Filter Options”</xreftext> </div> <div element="sect3" href="tdppt_sqltune014.htm" number="10.2.1.4" targetptr="TDPPT158"> <ttl>Creating a SQL Tuning Set: Schedule</ttl> <xreftext>“Creating a SQL Tuning Set: Schedule”</xreftext> </div> </div> <div element="sect2" href="tdppt_sqltune015.htm" number="10.2.2" targetptr="TDPPT195"> <ttl>Dropping a SQL Tuning Set</ttl> <xreftext>“Dropping a SQL Tuning Set”</xreftext> </div> <div element="sect2" href="tdppt_sqltune016.htm" number="10.2.3" targetptr="TDPPT159"> <ttl>Transporting SQL Tuning Sets</ttl> <xreftext>“Transporting SQL Tuning Sets”</xreftext> <div element="sect3" href="tdppt_sqltune017.htm" number="10.2.3.1" targetptr="TDPPT193"> <ttl>Exporting a SQL Tuning Set</ttl> <xreftext>“Exporting a SQL Tuning Set”</xreftext> </div> <div element="sect3" href="tdppt_sqltune018.htm" number="10.2.3.2" targetptr="TDPPT194"> <ttl>Importing a SQL Tuning Set</ttl> <xreftext>“Importing a SQL Tuning Set”</xreftext> </div> </div> </div> <div element="sect1" href="tdppt_sqltune019.htm" number="10.3" targetptr="TDPPT163"> <ttl>Managing SQL Profiles</ttl> <xreftext>“Managing SQL Profiles”</xreftext> </div> <div element="sect1" href="tdppt_sqltune020.htm" number="10.4" targetptr="TDPPT335"> <ttl>Managing SQL Execution Plans</ttl> <xreftext>“Managing SQL Execution Plans”</xreftext> </div> </div> <div element="chapter" href="tdppt_sqlopt.htm" number="11" targetptr="TDPPT170"> <ttl>Optimizing Data Access Paths</ttl> <xreftext>“Optimizing Data Access Paths”</xreftext> <div element="sect1" href="tdppt_sqlopt001.htm" number="11.1" targetptr="TDPPT171"> <ttl>Running SQL Access Advisor</ttl> <xreftext>“Running SQL Access Advisor”</xreftext> <div element="sect2" href="tdppt_sqlopt002.htm" number="11.1.1" targetptr="TDPPT172"> <ttl>Running SQL Access Advisor: Initial Options</ttl> <xreftext>“Running SQL Access Advisor: Initial Options”</xreftext> </div> <div element="sect2" href="tdppt_sqlopt003.htm" number="11.1.2" targetptr="TDPPT173"> <ttl>Running SQL Access Advisor: Workload Source</ttl> <xreftext>“Running SQL Access Advisor: Workload Source”</xreftext> <div element="sect3" href="tdppt_sqlopt004.htm" number="11.1.2.1" targetptr="TDPPT174"> <ttl>Using SQL Statements from the Cache</ttl> <xreftext>“Using SQL Statements from the Cache”</xreftext> </div> <div element="sect3" href="tdppt_sqlopt005.htm" number="11.1.2.2" targetptr="TDPPT175"> <ttl>Using an Existing SQL Tuning Set</ttl> <xreftext>“Using an Existing SQL Tuning Set”</xreftext> </div> <div element="sect3" href="tdppt_sqlopt006.htm" number="11.1.2.3" targetptr="TDPPT177"> <ttl>Using a Hypothetical Workload</ttl> <xreftext>“Using a Hypothetical Workload”</xreftext> </div> </div> <div element="sect2" href="tdppt_sqlopt007.htm" number="11.1.3" targetptr="TDPPT178"> <ttl>Running SQL Access Advisor: Filter Options</ttl> <xreftext>“Running SQL Access Advisor: Filter Options”</xreftext> <div element="sect3" href="tdppt_sqlopt008.htm" number="11.1.3.1" targetptr="TDPPT179"> <ttl>Defining Filters for Resource Consumption</ttl> <xreftext>“Defining Filters for Resource Consumption”</xreftext> </div> <div element="sect3" href="tdppt_sqlopt009.htm" number="11.1.3.2" targetptr="TDPPT180"> <ttl>Defining Filters for Users</ttl> <xreftext>“Defining Filters for Users”</xreftext> </div> <div element="sect3" href="tdppt_sqlopt010.htm" number="11.1.3.3" targetptr="TDPPT181"> <ttl>Defining Filters for Tables</ttl> <xreftext>“Defining Filters for Tables”</xreftext> </div> <div element="sect3" href="tdppt_sqlopt011.htm" number="11.1.3.4" targetptr="TDPPT182"> <ttl>Defining Filters for SQL Text</ttl> <xreftext>“Defining Filters for SQL Text”</xreftext> </div> <div element="sect3" href="tdppt_sqlopt012.htm" number="11.1.3.5" targetptr="TDPPT183"> <ttl>Defining Filters for Modules</ttl> <xreftext>“Defining Filters for Modules”</xreftext> </div> <div element="sect3" href="tdppt_sqlopt013.htm" number="11.1.3.6" targetptr="TDPPT184"> <ttl>Defining Filters for Actions</ttl> <xreftext>“Defining Filters for Actions”</xreftext> </div> </div> <div element="sect2" href="tdppt_sqlopt014.htm" number="11.1.4" targetptr="TDPPT185"> <ttl>Running SQL Access Advisor: Recommendation Options</ttl> <xreftext>“Running SQL Access Advisor: Recommendation Options”</xreftext> </div> <div element="sect2" href="tdppt_sqlopt015.htm" number="11.1.5" targetptr="TDPPT186"> <ttl>Running SQL Access Advisor: Schedule</ttl> <xreftext>“Running SQL Access Advisor: Schedule”</xreftext> </div> </div> <div element="sect1" href="tdppt_sqlopt016.htm" number="11.2" targetptr="TDPPT187"> <ttl>Reviewing the SQL Access Advisor Recommendations</ttl> <xreftext>“Reviewing the SQL Access Advisor Recommendations”</xreftext> <div element="sect2" href="tdppt_sqlopt017.htm" number="11.2.1" targetptr="TDPPT188"> <ttl>Reviewing the SQL Access Advisor Recommendations: Summary</ttl> <xreftext>“Reviewing the SQL Access Advisor Recommendations: Summary”</xreftext> </div> <div element="sect2" href="tdppt_sqlopt018.htm" number="11.2.2" targetptr="TDPPT189"> <ttl>Reviewing the SQL Access Advisor Recommendations: Recommendations</ttl> <xreftext>“Reviewing the SQL Access Advisor Recommendations: Recommendations”</xreftext> </div> <div element="sect2" href="tdppt_sqlopt019.htm" number="11.2.3" targetptr="TDPPT190"> <ttl>Reviewing the SQL Access Advisor Recommendations: SQL Statements</ttl> <xreftext>“Reviewing the SQL Access Advisor Recommendations: SQL Statements”</xreftext> </div> <div element="sect2" href="tdppt_sqlopt020.htm" number="11.2.4" targetptr="TDPPT191"> <ttl>Reviewing the SQL Access Advisor Recommendations: Details</ttl> <xreftext>“Reviewing the SQL Access Advisor Recommendations: Details”</xreftext> </div> </div> <div element="sect1" href="tdppt_sqlopt021.htm" number="11.3" targetptr="TDPPT192"> <ttl>Implementing the SQL Access Advisor Recommendations</ttl> <xreftext>“Implementing the SQL Access Advisor Recommendations”</xreftext> </div> </div> </div>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de