title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Oracle Database 11g R2: SQL Tuning, Architecture & Internals
Duration
5 Days
Course
DBOR-930
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Oracle Database 11g R2: SQL Tuning, Architecture & Internals course is designed to provide students with an understanding of the underlying architecture of the Oracle database environment. It is also intended to help information technology (IT) managers and executives who require an understanding of the technology upon which they and their staff rely. This course module will frequently show the component as it is actually rendered by the Enterprise Manager graphical interface for database administrators. At other times this course will use the SQL command-line interface to explain the characteristics of the architectural component being discussed.The 'SQL Tuning' volume will equip database administrators and application developers to build efficient SQL statements and to tune database applications. When this effort is complemented by database server and PL/SQL application tuning, then a highly efficient application execution environment is created. One will learn about the internals of SQL statement execution, how to monitor the performance of such execution, and how one can influence the behavior of the database to achieve performance gains.
This course covers information relevant for the certification test EXAM 1Z0-054: ORACLE DATABASE 11G R2: PERFORMANCE TUNING.
Objectives
Upon completion of the Oracle Database 11g R2: SQL Tuning, Architecture & Internals course, students will be able to:
- Understand the component as it is actually rendered by the Enterprise Manger graphical interface for database administrators.
- Use the SQL command-line interface to explain the characteristics of the architectural component being discussed.
- Build efficient SQL statements and tune database applications.
- Learn about and monitor the performance of SQL statement execution.
- Influence the behavior of the database to achieve performance gains.
Audience
- The primary target audiences for this course are: Senior application designers and database developers, PL/SQL developer, Database administrators, Web server administrators, System administrators, Implementation specialists and Data center support engineers.
Prerequisites
- Data Modeling: Logical Database Design
- Oracle Database 11g R2: SQL Fundamentals - Complete Library (DBOR-917)
- Oracle Virtualization & Linux Administration QuickStart (DBOR-963)
Topics
ARCHITECTURE & INTERNALS
THE BROADER ORACLE ENTERPRISE ARCHITECTURE
EXPLORING THE ORACLE DATABASE INSTANCE
EXPLORING THE INSTANCE PROCESSES
EXPLORING LOGISTICAL STORAGE: DATABASE OBJECTS
EXPLORING PHYSICAL STORAGE: DATABSE FILES
EXPLORING PHYSICAL STORAGE: TABLESPACES
SQL TUNING
TUNING & THE ORACLE DATABASE ADVISORY FRAMEWORK
VIEWING & MONITORING THE EXECUTION PLAN
UNDERSTANDING THE OPTIMIZER
EXECUTION PLAN METHODS & OPERATIONS
MANAGING OPTIMIZER STATISTICS
ENHANCED OPTIMIZER STATISTICS
HISTOGRAMS & EXTENDED STATISTICS
APPLICATION TRACING
ADDM & THE SQL TUNING ADVISOR
THE SQL ACCESS ADVISOR
PLAN MANAGEMENT
MANAGING CURSOR SHARING
OPTIMIZER HINTS
- ABOUT enterprise
- ABOUT parallelization
- SMP
- THE database server stack
- THE database server software
- V$VERSION
- DATABASE instance configurations
- ABOUT the SGA
- USING V$SGA_DYNAMIC_COMPONENTS
- ABOUT the PGA
- MANAGING instance memory
- INSTANCE background processes
- SQL execution processes
- USING V$SESSION
- ABOUT the PGA
- SQL statement execution
- APPLICATION database objects
- SCHEMA & ownership context
- EDITIONS context & redefinition
- ABOUT the database files
- DATABSE server parameter file
- CONTROL files
- ALERT log & trace files
- TABLES & data files
- AUTOEXTEND options
- ABOUT temporary segments
- ABOUT index segments
- THE challenges of tuning
- PERFORMANCE metrics
- MANAGEMENT & advisory framework
- ADDM & AWR
- SQL tuning privileges
- ABOUT the execution plan
- COLLECTING performance statistics
- VIEWING the execution plan
- REAL-TIME SQL monitoring
- OPTIMIZATION methods
- OPTIMIZATION goals
- OPTIMIZER_MODE
- OPTIMIZER_FEATURES_ENABLE
- OPTIMIZER components
- EXECUTION plan operations
- TABLE access methods
- JOIN methods
- INDEX operations
- DATA operations
- MORE about optimizer statistics
- AUTOMATIC maintenance tasks
- MANUALLY gathering statistics
- GATHER_TABLE_STATS()
- GATHER_INDEX_STATS()
- GATHER_SCHEMA_STATS()
- GATHER_DATABASE_STATS()
- USING historical statistics
- DYNAMIC sampling
- LOCKING statistics
- ABOUT optimizer system statistics
- MANAGE system statistics
- CREATE_STAT_TABLE(), DROP_STAT_TABLE()
- CREATE_STAT_TABLE()
- DROP_STAT_TABLE()
- GATHER_SYSTEM_STATS()
- GET_SYSTEM_STATS()
- SET_SYSTEM_STATS()
- IMPORT_SYSTEM_STATS(), EXPORT_SYSTEM_STATS()
- IMPORT_SYSTEM_STATS()
- EXPORT_SYSTEM_STATS()
- DELETE_SYSTEM_STATS()
- PENDING & PUBLISHED STATISTICS
- WHY are histograms needed?
- HISTOGRAMS internal structure
- MANUALLY managing histograms
- EXPRESSION statistics
- MULTICOLUMN STATISTICS
- APPLICATION tracing packages
- SET_SQL_TRACE()
- TRACE_ENABLE()
- SET_IDENTIFIER()
- EM application monitoring & tuning
- REAL-TIME monitoring
- USING TRCSESS & TKPROF
- ADDM performance analysis
- USING the SQL tuning advisor
- AUTOMATIC SQL tuning
- CONFIGURING automatic SQL tuning
- USING the SQL access advisor
- SQL access advisor templates
- PERFORMING a quick tune task
- INDEX database parameters
- OPTIMIZER_INDEX_COST_ADJ
- OPTIMIZER_INDEX_CACHING
- SKIP_UNUSABLE_INDEXES
- SQL management base architecture
- LOAD_PLANS_FROM_SQLSET()
- LOAD_PLANS_FROM_CURSOR_CACHE()
- USING plan baselines
- PLAN management using EM
- ABOUT cursor sharing
- BIND variables & cursor sharing
- THE cursor_sharing parameter
- FINDING candidates for rewrite
- WHAT are hints?
- HINT explanations
Related Courses
-
Oracle Database 11g R2 SQL Complete
DBOR-917- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 3,500.00 USD
-
Oracle Database 11g: Advanced PL/SQL Programming & Tuning
DBOR-922- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 3,500.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart