Oracle Database 11g

Oracle Database 11g: Architecture, SQL Tuning, and Optimization

• Recognize Oracle database structures
• Recognize how to manage memory and database structures
• Identify SQL statements that cause poor performance
• Identify tools and tasks in SQL tuning
• Recognize how SQL statement execution works
• Recognize the basic features of the optimizer
• Avoid common SQL mistakes
• Recognize optimizer decisions in a given scenario

Oracle Database 11g: Indexes, Access Paths, and Join Operations

• Identify the functions of table scans in the optimizer
• Recognize types of indexes and how index scans work
• Recognize the features of index-organized tables and bitmap and composite indexes
• Use different access paths
• Recognize how clusters and sorting operators work
• Recognize how joins and N-array operations work
• Recognize how to cache query results in the SGA

Oracle Database 11g: Execution Plans and Star Transformations

• Recognize how to gather execution plans
• Recognize how to display execution plans
• Recognize the views containing execution plan information
• Recognize how to use the AWR
• Recognize how to perform SQL monitoring
• Interpret execution plans
• Extract an execution plan used by the optimizer to execute a query
• Recognize how to use star transformation
• Use star transformation and access the benefits of using this optimizer technique

Oracle Database 11g: Optimizer Statistics, Hints, and Cursor Sharing

• Recognize how to gather optimizer statistics
• Recognize how to gather system statistics
• Use dynamic sampling
• Use system statistics
• Identify the features of bind variables
• Use cursor sharing
• Use optimizer hints
• Use hints and views
• Recognize how adaptive cursor sharing, the CURSOR_SHARING initialization parameter, and hints are used

Oracle Database 11g: Application Tracing and Automatic SQL Tuning

• Recognize how to configure the SQL trace facility
• Recognize how to use the trcsess utility
• Recognize how to use the tkprof utility
• Perform application tracing
• Recognize how statement profiling works
• Recognize how to use the SQL Tuning Advisor
• Recognize the features of the SQL Access Advisor
• Recognize the features of Automatic SQL Tuning
• Perform SQL tuning and use the SQL Access Advisor

Oracle Database 11g: Configuring OSB and Security

• Recognize the basic principles of OSB
• Recognize how the OSB backup hierarchy works
• Recognize how OSB enables secondary storage devices, tape libraries, and tape drives to be used for backup and restore operations
• Recognize how to manage and secure data with OSB and RMAN
• Recognize how to install OSB
• Recognize how to install and configure OSB on Windows
• Install and configure OSB

Oracle Database 11g: Securing Domain and Data in Oracle Secure Backup

• Recognize how to manage OSB users
• Recognize the OS permissions for an OSB user
• Recognize how to preauthorize OSB users
• Recognize how authentication works with OSB
• Recognize how OSB encryption works
• Configure an OSB user
• Configure a host encryption policy