Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Database & Data Warehouse 11g R2: Performance Assessment
Oracle Training Overview

This textbook is the first volume of a two-volume set devoted to the subject of Oracle database server and Oracle data warehouse performance tuning.

This first volume provides crucial background information about database performance statistics, metrics and baselines. An enormous amount of performance data is generated and presented by the self-monitoring Oracle database, but the meaning and usefulness of the data is not always obvious. Common questions are: What exactly should I be looking for in amongst all this data? What is the meaning of the performance statistics presented? What conclusions should one reach based upon what is observed and what specific tuning actions should be considered?

Therefore, this first volume helps one to 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. This textbook will at times include an in-depth discussion of some internal database operations where these are relevant to assessing database performance.


Oracle Training Objectives

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.
The second volume of this textbook set then provides tuning techniques and remedies that can be applied to address specific problems commonly found, such as the performance bottlenecks demonstrated in this textbook.


Oracle Training Audience

The target audience for this course is any of the following professionals:
  • Data architects
  • Database administrators
  • Data warehouse administrators and implementation specialists
  • Tuning specialists
  • Data center support engineers and consultants
  • Senior database developers
Oracle Training Prerequisites

Suggested prerequisites for this textbook are the following titles:
  • ORACLE DATABASE 11G R2: ADMINISTRATION I
  • ORACLE DATABASE 11G R2: ADMINISTRATION II
  • ORACLE DATA WAREHOUSE 11G R2: WAREHOUSE ADMINISTRATION
Suggested Next Courses

The second volume of this textbook set should be considered next, which is entitled ORACLE DATABASE & DATA WAREHOUSE 11G R2: PERFORMANCE TUNING.

Ideally one will address application performance tuning issues at the same time as database performance and database server configuration issues. But if you have not already completed the following textbooks, we would recommend these next as well:
  • ORACLE DATABASE 11G R2: SQL TUNING
  • ORACLE DATABASE 11G R2: ADVANCED PL/SQL PROGRAMMING & TUNING ORACLE BI 11G: ADVANCED ANALYSES FOR POWER USERS.
Oracle Training Course duration

2 Days

Oracle Training Course outline

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

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved