Course Outline
The Oracle Database Performance Tuning class offers delegates the opportunity to discuss and examine potential tuning bottlenecks that may impact performance of an Oracle database. The class focuses on the tuning required for a production level database instance and describes memory, disk and process tuning in detail.
Course Content
Course content has been developed for real-world, commercial scenarios by our expert. if you have a technical query email sales@jbinternational.co.uk.
What you will learn
At the end of the course the delegate should be able to:
- Understand the Oracle Architecture from a tuning perspective.
- Monitor, Anaylize database performance.
- Make adjustments to database parameters and adjust structures for optimumperformance.
Oracle Database 10g/11g Performance & Tuning Training Course
Oracle RDBMS Architecture
Memory, Process and Disk Structure, Disk Structure, Parameter File, Control File, Data Files, Redo Log Files, Password File, Logical / Physical Structures, Segments, Extents, Blocks, Memory Structure, Shared Pool, Buffer Cache, Redo Log Buffer, Process Structure, User and Shadow Processes, Database Writer, Log Writer, System Monitor, Process Monitor, Archiver, Processing a query, Processing an Update, Processing a transaction.
Approach to Tuning
Planning to Tune, What is to be tuned?, What is needed?, What is the tuning target?, How to achieve your goals.
Tuning Tools and Utilities
Tools Overview, Oracle Enterprise Manager, OEM Packs, Alert Log, Trace Files, Static Dictionary Tables, Dynamic Performance Views, UTLBSTAT/UTLESTAT, Statspack, Advisor Central, awrrpt reports,addmrpt
Understanding Statistics
Table and Index Statistics, System Statistics, Statistics Gathering Mechanisms, DBMS_STATS Package, DBMS_STATS Procedures, System Statistics Procedures, Executing System Stats Procedures, Dictionary Statistics Procedures
Tuning Memory
Shared Pool Tuning, Cache Tuning, Redo Log Buffer Tuning, Automating Memory Settings, Parameters settings, Dynamic Memory Management.
Disk File Tuning
Data Files, Processes and Data Files, Data File Tuning Goals, Optimise disk I/O by tablespaces, Using Tablespaces Effectively, Separate busy tables from each other, Tablespace Types, Extent Management, Segment Space Management, Setting Up ASSM, Checking Tablespace Usage, Plan UNDO/ROLLBACK tablespace usage, Redo Log File Tuning Goals, Checkpoints.
Undo Segment Tuning
Rollback Segments v Automatic Undo Management.
Data Block Tuning
Block Tuning Guidelines, Tablespace types, Dynamic extent allocation, Database Block Sizing, Block Packing Factor, Chaining and Migration, High Water Mark, Space Recovery Mechanisms, Index Reorganisation, Index Reorganisation Views.
Automating Disk Usage
ASM Automatic Storage Management, Architecture, Setting Parameters, Configuring ASM.
Process Tuning
Sorting Overview, Sorting Mechanisms, Sort Operations, Sort Tuning Goals, Measuring Sorts, Oracle Latches, Investigating Latches, Latch Issue Resolution, Locking Overview, Lock Types, Locking Issues, Locking Diagnostics, Resolving Locking Issues.
