Home

Public Courses

Oracle Courses

Microsoft Courses

Java Courses

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

Synopsis

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

Suggested Further Course(s)
9i Network Administration

---

This intensive training course has a dynamic face to face, tutor led learning framework and is delivered by an experienced Oracle professional. In-depth course notes are provided in a presentation file for the delegate to use, and this becomes a valuable reference guide following the course.

On completion all delegates receive a certificate.

---

On Site or Off Site ?

On Site

All that we require is a private room with tables and chairs, that is large enough to comfortably hold your delegates and a tutor. We will provide each delegate with an individual laptop and all other equipment that is required.

Off Site

If you prefer instead of delivering on site we can deliver the course off site at Seer House, Swansea or we will be happy to arrange a neutral venue that is convenient for you (please be aware this will incur additional costs).

---

This course has the provision to be delivered over the weekend.
Ideal for your company, if you are working on projects with tight timescales or need to train employees with incredibly busy working weeks.

---

Standard or Customised ?

If you feel that this is not entirely suitable for your company requirements we offer the service of creating bespoke training packages. We can either customise this training to your exact company requirements or work with you to build a completely new one (please be aware this will incur additional costs).

---

Contact Details

Please contact us on
+44 (0) 800 157 7519 or email at training@seercomputing.com

---