List of Examples

• 6-1 Example ADDM Report
• 7-1 Calculating the Buffer Cache Hit Ratio
• 7-2 Initial Setting of PGA_AGGREGATE_TARGET
• 7-3 Calculating Cache Hit Percentage
• 7-4 Querying V$SQL_WORKAREA_HISTOGRAM: Non-empty Buckets
• 7-5 Querying V$SQL_WORKAREA_HISTOGRAM: Percent Optimal
• 7-6 Querying V$SQL_WORKAREA_ACTIVE
• 7-7 Querying V$SQL_WORKAREA
• 7-8 Querying V$PGA_TARGET_ADVICE
• 7-9 Querying V$PGA_TARGET_ADVICE_HISTOGRAM
• 7-10 Using the RESULT_CACHE Hint in a Query
• 7-11 Querying Statistics for Cached Results
• 7-12 Using the RESULT_CACHE Hint in a WITH Clause View
• 7-13 RESULT_CACHE Hint
• 7-14 NO_RESULT_CACHE Hint
• 7-15 RESULT_CACHE Hint Specified in Inline View
• 7-16 RESULT_CACHE Hint Specified in WITH View
• 7-17 DEFAULT Table Annotation
• 7-18 FORCE Table Annotation
• 8-1 Mytest Sample Data Points
• 8-2 Sample Data Points with 12 Small Reads and No Large Reads
• 8-3 Sample CSV file with 12 Small Reads and No Large Reads
• 10-1 Sample SQL Monitor Report
• 11-1 Bind Peeking
• 11-2 Bind-Sensitive Cursors
• 11-3 Bind-Aware Cursors
• 11-4 Effects of Clustering Factor on Cost
• 11-5 Index Range Scan
• 11-6 Composite Index Entries
• 11-7 Sample Table Scan
• 11-8 Hash Joins
• 11-9 Hash Join Outer Joins
• 11-10 Outer Join to a Multitable View
• 11-11 Full Outer Join
• 11-12 Execution Plan for a Full Outer Join
• 11-13 Using EXPLAIN PLAN
• 11-14 EXPLAIN PLAN Output
• 12-1 Looking for Throw-Away in an Explain Plan
• 12-2 Using EXPLAIN PLAN with the STATEMENT ID Clause
• 12-3 Using EXPLAIN PLAN with the INTO Clause
• 12-4 Statement to display the EXPLAIN PLAN
• 12-5 EXPLAIN PLAN for Statement ID ex_plan1
• 12-6 EXPLAIN PLAN for Statement ID ex_plan2
• 12-7 Parallel Query Explain Plan
• 12-8 EXPLAIN PLAN with Bitmap Indexes
• 12-9 Partial Partition-Wise Join with Range Partition
• 12-10 Partial Partition-Wise Join with Composite Partition
• 12-11 Full Partition-Wise Join
• 13-1 Viewing Height-Balanced Histogram Statistics
• 13-2 Viewing Frequency Histogram Statistics
• 17-1 Alternative Plan Finding
• 17-2 Alternative Plans Section
• 17-3 Sample SQL Profile Finding
• 17-4 Parallel Query Recommendation
• 18-1 Optimizing the Defining Query for Fast Refresh
• 18-2 Access IMPLEMENTATION Output Through USER_TUNE_MVIEW View
• 18-3 Save IMPLEMENTATION Output in a Script File
• 18-4 Enable Query Rewrite by Creating Multiple Materialized Views
• 18-5 Access IMPLEMENTATION Output Through USER_TUNE_MVIEW View
• 18-6 Save IMPLEMENTATION Output in a Script File
• 18-7 Optimized Sub-Materialized View for Fast Refresh
• 19-1 Explain Plan for Query with /*+ PARALLEL(employees 3) */ Hint
• 19-2 Specifying a Full Set of Hints
• 19-3 Using Global Hints Example
• 19-4 Using Global Hints with NO_MERGE