|
(703)246-9100 Northern Virginia (804)285-5830 Central Virginia (757)420-3810 Tidewater Area (800)294-7497 Toll Free (804)285-3722 Fax |
ORACLE 10g SQL Tuning for Developers
Duration: 3 days
|
(703)246-9100 Northern Virginia (804)285-5830 Central Virginia (757)420-3810 Tidewater Area (800)294-7497 Toll Free (804)285-3722 Fax |
ORACLE 10g SQL Tuning for Developers
Duration: 3 days
Write faster, more efficient code by optimizing SQL statements and the Oracle architecture.
This course will introduce the developer to techniques used to provide minimize response times in and Oracle database.
Who Needs to Attend:
Application Developers and Database Administrators who need a fundamental understanding of tuning the Oracle architecture and SQL statements.
Prerequisites:
Oracle 10g SQL or equivalent experience.
Course Content:
Where Clause Subqueries
From Clause Subqueries
Correlated Subqueries
Scalar Subqueries
Exists Subqueries
Tree-Structured queries
Performance Tuning Duties
Steps For Tuning
Tuning Methodology
The Tuning Team
Tuning Tools
SQL Parsing And Execution
Shared SQL Statements
The SQL Area
Automatic Segment Space Management
Statement Transformation
Using SQL Syntax
Tuning Overview
Tablespace Considerations
Table Considerations
Free Space Management
Chaining And Migrated Data
Choosing The Right Index
Index Usage Monitoring
Materialized Views
Optimizer Overview
Execution Plans
Rule-Based Optimization (Desupported)
Cost-Based Optimization
Table And Index Statistics
DBMS_STATS
Execution Plans
Autotrace
SQL_TRACE And TKPROF
Using Hints
Stored Outlines And Plan Stability
Memory Tuning Goals
Tuning The Buffer Cache
Memory Subcaches
Partitioned Tables And Indexes
DBMS_PROFILER
DBMS_SESSION
DBMS_TRACE
DBMS_STATS
Data Model Review
Object Management
Architectural Issues
Shared Pool
Buffer Cache
File I/O
Redo Log Buffer And Checkpoints
Sort Activity
Course Labs:
Subqueries
SQL Statement Processing
Logical Structures
Statistics And Execution Plans
SQL_TRACE, TKPROF, Stored Outlines And Hints
Application Memory Use