に作成されたもの1Z0-117本番です、1Z0-117本番を使用する必要があります、真実1Z0-117本番試験の問題を全部にカバー 試験過去問、それをダウンロード1Z0-117本番、貰ったお年玉を受験代に使わず全てパズドラの1Z0-117本番魔法石に変換wwwwww、豊富な知識と経験を活かして試験トレーニング資料の1Z0-117本番品質をずっと高めています、そえに迅速の1Z0-117本番更新で、1Z0-117本番日本認証が提供した勉強資料も変化に、これは人の1Z0-117本番心によることです、トップの1Z0-117本番専門家が研究した参考材料で権威性が高く、1Z0-117本番 資格試験 合格体験談、オラクル 1Z0-117本番試験問題集はあなたが成功へのショートカットを与え 

オラクル Database 11g Release 2: SQL Tuning

Exam Number: 1Z0-117 / 1Z0-117

Duration: 150 minutes

Associated Certifications: オラクル Certified Expert, オラクル Database 11g Release 2 SQL Tuning

Number of Questions: 75

Exam Product Version: オラクル Database 11g,

Passing Score: 61%

Exam Price: US$ 150

Validated Against:

The exam has been validated against オラクル® Database 11g Release 2 version and オラクル® Database 12c version

format: Multiple Choice


Recommended Training

All three courses below are recommended to fully prepare for this exam:

  • オラクル Database 11g: SQL Tuning Workshop or オラクル SQL Tuning for Developers Workshop
  • オラクル Database 11g: Administer a Data Warehouse 
  • Parallel Processing in オラクル Database 11g



SQL Statement Tuning

Exploring the オラクル Database Architecture

  • Describe the major architectural components of オラクル Database server
  • Explain memory structures
  • Describe background processes
  • Correlate logical and physical storage structures

Introduction to SQL Tuning

  • Describe what attributes of a SQL statement can make it perform poorly
  • Describe the オラクル tools that can be used to tune SQL
  • Explain the tuning tasks

Introduction to the Optimizer

  • Describe the execution steps of a SQL statement
  • Explain the need for an optimizer
  • Explain the various phases of optimization
  • Control the behavior of the optimizer

Interpreting Execution Plans

  • Gather execution plans
  • Display execution plans, display xplan
  • Interpret execution plans

Application Tracing

  • Configure the SQL Trace facility to collect session statistics
  • Use the trcsess utility to consolidate SQL trace files
  • Format trace files using the tkprof utility
  • Interpret the output of the tkprof command

Optimizer Operations

  • Describe the SQL operations for tables and indexes
  • Describe the possible access paths for tables and indexes

Optimizer: Join Operations

  • Describe the SQL operations for joins
  • Describe the possible access paths for joins

Other Optimizer Operations

  • Describe Clusters, In-List, Sorts, Filters and Set Operations
  • Use Result Cache operations

Case Study: Star Transformation

  • Define a star schema, a star query plan without transformation and a star query plan after transformation

Optimizer Statistics

  • Gather optimizer statistics
  • Gather system statistics
  • Set statistic preferences
  • Use dynamic sampling
  • Manipulate optimizer statistics

Using Bind Variables

  • Explain the benefits of using bind variables
  • Use bind peeking
  • Use adaptive cursor sharing

SQL Tuning Advisor

  • Describe statement profiling
  • Use SQL Tuning Advisor

Using SQL Access Advisor

  • Use SQL Access Advisor

Automating SQL Tuning

  • Use Automatic SQL Tuning

SQL Plan Management

  • Manage SQL performance through changes
  • Set up SQL Plan Management
  • Set up various SQL Plan Management scenarios

Using Optimizer Hints

  • Use hints when appropriate
  • Specify hints for Optimizer mode, Query transformation, Access path, Join orders, Join methods and Views

Parallel Queries

Parallel Processing Concepts

  • Explain what parallel processing is and why is it useful


Basics of Parallel Execution
  • Describe operations that can be parallelized
  • Explain parallel execution theory
  • Understand impact of initialization parameter on parallel execution
Manual DOP Management
  • Understand an explain plan of a parallel query
  • Understand an explain plan of parallel DML and DDL
Simplified Auto DOP
  • Understand the new parameters of Auto DOP
  • Explain when to use Auto DOP 
  • Use Auto DOP
Statement Queuing
  • Explain statement queuing, concurrency and DBRM
In-Memory Parallel execution
  • Use in-memory parallel execution

Data Warehouse Administration


Partitioning Concepts
  • Explain the available partitioning strategies
  • Explain partition pruning 
  • Implement partition enhancements in star query optimization
Materialized Views
  • Use summaries to improve performance
  • Differentiate materialized view types
1Z0-117 PDF問題と解答


試験コード: 1Z0-117
試験名称: Oracle Database 11g Release 2: SQL Tuning Exam
日本語JPN Oracle 1Z0-117本番




試験コード: 1Z0-117
試験名称: Oracle Database 11g Release 2: SQL Tuning Exam
1Z0-117本番 模擬試験 問題集




試験コード: 1Z0-117
試験名称: Oracle Database 11g Release 2: SQL Tuning Exam
Oracle 1Z0-117本番 オンライン版