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 & Data Warehouse 11g R2: Performance Assessment
Duration
2.5 Days
Course
DBOR-933
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Oracle Database & Data Warehouse 11g R2: Performance Assessment course is designed to provide students with information about database performance statistics, metrics and baselines. This course helps students assess the current performance of the database or the data warehouse, to identify whether or not there is a serious problem, and if so to isolate which areas of the database should be tuned and which tuning techniques might be considered.Objectives
Upon completion of the Oracle Database & Data Warehouse 11g R2: Performance Assessment course, students will be able to:
- Understand 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.
- Analyze 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.
- Understand 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.
- Understand the benefit of database performance statistics, metrics, alerts, thresholds and baselines.
- Utilize the Enterprise Manager real-time performance monitors to immediately assess current database performance.
- Interpret database operational statistics, wait events and time model statistics to assess database performance and identify processing bottlenecks and constraints.
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, and Senior database developers.
Prerequisites
- ORACLE DATABASE 11G R2: ADMINISTRATION I (DBOR-923)
- ORACLE DATABASE 11G R2: ADMINISTRATION II (DBOR-924)
- ORACLE DATA WAREHOUSE 11G R2: WAREHOUSE ADMINISTRATION
Topics
- THE database tuning focus
- COMPARING database applications
- IMPACT of systems infrastructure
- IMPACT of enterprise architecture
- TOP 10 ORACLE database mistakes
- TOP 3 host performance issues
- THE operating system
- HOST system processors
- I/O processing
- ORACLE exadata database platform
- ABOUT database tuning
- PERFORMANCE statistics
- COMPREHENSIVE analysis
- REAL-TIME performance monitors
- DRILL-DOWN real-time monitors
- HOW to monitor instance activity
- CURSOR measures
- TRANSACTION measures
- SESSION measures
- LOGICAL I/O measures
- PHYSCIAL I/O measures
- NET I/O measures
- TABLE measures
- ALL measures
- HOW are the statistics organized?
- CONTROLLING the statistics collection
- STATISTICS_LEVEL parameter
- TIME_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
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