Home
Public Courses
Oracle Courses
Microsoft Courses
Java Courses
Consultancy
Home
Contact Us
About Us
Download
FAQ
Public Courses
London
Edinburgh
Birmingham
Manchester
Dublin
Leeds
Cardiff
Newcastle
Belfast
Swansea
Oracle Courses
SQL
SQL for Users Part 1
Query Builder
Essential SQL
10G SQL
9i SQL
Using SQL with SQL Developer
SQL Developer Part 1
SQL Developer Part 2
PLSQL
PLSQL 1
PLSQL 2
PLSQL 10g
PLSQL 9i
9i New Features
8i New Features
Discoverer
10g Administration
10g Desktop
10g Plus
9i
Administration
Desktop
4i
Administration
Desktop
3.1
Administration
User
Forms
Forms 10g
Forms 9i
Forms 6i
Forms 6i New Features
Reports
Reports 10g
Reports 9i
Reports 6i
Reports 6i New Features
Graphics 6i
DBA
10g DBA 1
10g DBA 2
10g New Features
9i
New Features for DBAs
DBA 1
DBA 2
Database Tuning
Network Administration
AS Basic Administration
8i
New Features for DBAs
DBA 1
DBA 2
Database Tuning
Network Administration
Microsoft Courses
Word
Excel
Access
Powerpoint
Frontpage
Project
Java Courses
Fundamentals of Java
Java Programming
Java Swing
Consultancy
Discoverer Consultancy
Data Consultancy
Oracle Consultancy
Contents
This course deals with tuning the 9i Database to get the most efficient storage configuration as well as the best performance times.
The course includes the following aspects:
Avoiding locking and contention problems
Tune and troubleshoot SGA buffers
Tune and troubleshoot the shared pool
Tune and troubleshoot data file configuration problems
Use utlBstat and utlEsts and/or statspack
Exercises
There are practical and comprehensive exercises scheduled throughout the course to ensure delegates leave with a sound theoretical and practical knowledge.
Duration
Three Days
© Copyright
Seer Computing Ltd.
This course presents techniques for finding and solving performance or configuration problems within the Oracle 9i database.
Manual techniques as well as those employing speciality packs within Oracle Enterprise Manager are considered
Pre-Requisite Course(s)
9i DBA I
Next Course(s)
9i Network Administration
Search the Site