Course code Title Language Price # Unit Startdate Hour Enddate Location Signup
OR2402 Oracle Database & Data Warehouse 11g R2: Performance Assessment on your request on your request Contact Us

Oracle Database & Data Warehouse 11g R2: Performance Assessment

Oracle Database & Data Warehouse 11g R2: Performance Assessment

Overview

Course code: 
OR2402
Duration: 
2
Time Unit: 
Day(s)
Overview: 

Among the specific subjects discussed within this textbook are:

- How database performance tuning, SQL statement and application tuning, and the overall systems infrastructure configuration contribute to the performance of database installations.
- Contrast online transaction processing applications with data warehouse activity.
- Consider the systems components that interact with a database installation within multi-tiered systems architectures commonly in use today.
- Review the top 10-database configuration mistakes which contribute towards poor performance.
- Review the top 3 host system performance issues found on database servers.
- Host system components that influence database performance, such as operating systems like Linux, processor capabilities and input/output devices.
- Understanding system read and write internals, such as the difference between small reads and writes versus large reads and writes, asynchronous input/output versus synchronous input/output.
- Review the database performance assessment and performance tuning facilities built into the Oracle database server.
- Understanding the benefit of database performance statistics, metrics, alerts, thresholds and baselines.
- Using the Enterprise Manager real-time performance monitors to immediately assess current database performance.
- Interpreting database operational statistics, wait events and time model statistics to assess database performance and identify processing bottlenecks and constraints.

Topics

Topics: 

PROPERLY FOCUSING DATABASE TUNING EFFORTS
- THE DATABASE TUNING FOCUS
- COMPARING DATABASE APPLICATIONS
- IMPACT OF SYSTEMS INFRASTRUCTURE
- IMPACT OF ENTERPRISE ARCHITECTURE
- TOP 10 ORACLE DATABASE MISTAKES

UNDERSTANDING THE DATABASE HOST SYSTEM
- TOP 3 HOST PERFORMANCE ISSUES
- THE OPERATING SYSTEM
- HOST SYSTEM PROCESSORS
- I/O PROCESSING
- ORACLE EXADATA DATABASE PLATFORM

ASSESSING CURRENT DATABASE PERFORMANCE
- ABOUT DATABASE TUNING
- PERFORMANCE STATISTICS
- COMPREHENSIVE ANALYSIS
- REAL-­‐TIME PERFORMANCE MONITORS

REAL-­‐TIME INSTANCE ACTIVITY MONITORING
- DRILL-­‐DOWN REAL-­‐TIME MONITORS
- HOW TO MONITOR INSTANCE ACTIVITY
- CURSOR MEASURES
- TRANSACTION MEASURES
- SESSION MEASURES
- LOGICAL I/O MEASURES
- PHYSICAL I/O MEASURES
- NET I/O MEASURES
- TABLE MEASURES
- ALL MEASURES

UNDERSTANDING STATISTICS & WAIT EVENTS
- HOW ARE THE STATISTICS ORGANIZED?
- CONTROLLING THE STATISTICS COLLECTION
- STATISTICS_LEVEL Parameter
- TIMED_STATISTICS Parameter
- TIMED_OS_STATISTICS Parameter
- CONTROL_MANAGEMENT_PACK_ACCESS Database Parameter
- USING OPERATING SYSTEM STATISTICS
- USING DATABASE STATISTICS
- USING WAIT EVENTS
- TIME MODEL STATISTICS

Prerequisites

Prerequisites: 

Suggested prerequisites for this Course are the following titles:

• ORACLE DATABASE 11G R2: ADMINISTRATION I
• ORACLE DATABASE 11G R2: ADMINISTRATION II
• ORACLE DATA WAREHOUSE 11G R2: WAREHOUSE ADMINISTRATION

Audience

Audience: 

The target audience for this course is any of the following professionals:

- Database administrators
- Data warehouse administrators and implementation specialists
- Tuning specialists
- Data center support engineers and consultants
- Senior database developers