Oracle 9i Performance Tuning for DBAs

Name: Oracle 9i Performance Tuning for DBAs
Availability: InStock
Rating: 1 (1 reviews)

Professional Training Solutions Ltd

Add to wishlist

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 5 Days
Call: +971 4 5490356

Course details

This course provides you with the knowledge and hands-on experience of SQL tuning, database tuning and advanced performance design.

Prerequisites:

Oracle Foundation Classes, Oracle DBA I or equivalent experience.

Performance Tuning Duties of the DBA:

DBA`s Performance Tuning Duties
Steps for Tuning
Tuning goals for different types of applications
The Performance tuning Team
Tuning Tools

Tune the Logical Structure of the Database:

Overview
Table/Tablespace Considerations
Free Space Management
Chained and Migrated Rows
Index Types
Materialised Views/Snapshots
Query Rewrite

Tune Database Operations:

SQL Parsing and Execution
Shared SQL Statements
Contents of the SQL Area
Segment Space Management
Automatic Undo Management
Understanding Statement Transformations
Optimising SQL Syntax

SQL Tuning Tools:

Rule Based and Cost Based Optimisation
Table and Index Statistics
Gathering Statistics
Execution Plans
SQL *Plus and AUTOTRACE
SQL_TRACE and TKPROF
Hints
Store Outlines/Plan Stability

DBA Tuning Tools:

SPFILE/Init.Ora
V$ Views
UTLBSTAT / UTLESTAT
STATSPACK

Tuning Memory:

Tune OS Memory
Tune Database Buffer Cache
Memory Subcaches
Tune Redo Log Buffer
Tune Private SQL and PL/SQL Areas
Tune the Shared Pool
Tune Sorts
Tuning the Shared Server
Tuning the Java Pool
SGA/PGA Tuning

Tuning I/O:

RAID
Oracle File 1/O
Partitioning Tables and Indexes
Checkpointing

Tuning Contention and Understanding the Resource Manager:

Shared Server Contention
Tune Lock Contention
Tune Contention for Undo and Temporary Segments, and for Latches
Introduction to the Resource Manager

Tuning the Shared Server:

Issues associated with managing users in a Shared Server environment
Diagnose and resolve performance problems
Configure shared servers to optimise performance

Detecting and tuning lock contention:

Define locking levels
Describe causes of contention
Use Oracle tools to detect lock contention
Emergency lock contention resolution
Prevent locking problems
Recognise deadlocks

PL/SQL Packages for the Tuner:

DBMS_APPLICATION_INFO
DBMS_IOT
DBMS_ORACLE_TRACE_AGENT
DBMS_ORACLE_TRACE_USER
DBMS_PROFILER
DBMS_RESOURCE_MANAGER_PRIVS
DBMS_SESSION
DBMS_SHARED_POOL
DBMS_SPACE
DBMS_STATS
DBMS_TRACE
DBMS_UTILITY

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current Oracle jobs in UAE