Scribd
Upload
57 views

Introduction To Oracle Database Performance Tuning

Uploaded by

Mohammed Ali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
57 views

Introduction To Oracle Database Performance Tuning

Uploaded by

Mohammed Ali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 11

Introduction to Oracle Database

Performance Tuning

By Ahmed Baraka

Oracle© Database Performance Tuning - a course by Ahmed Baraka


Objectives
In this lecture, you should learn how to perform the following:
• Describe Oracle database performance tuning areas
• Describe performance issue attributes
• Describe Oracle performance tuning methodology
• Describe a typical system workload

Oracle© Database Performance Tuning - a course by Ahmed Baraka


Oracle Database Performance Tuning Areas

Performance
Tuning Tools

Instance
SQL Tuning Tuning

Oracle© Database Performance Tuning - a course by Ahmed Baraka


Oracle Database Performance Tuning Areas

Performance
Tuning Tools

Instance
SQL Tuning Tuning

Oracle© Database Performance Tuning - a course by Ahmed Baraka


Oracle Database Performance Tuning Areas

Performance
Tuning Tools

Instance
SQL Tuning Tuning

Oracle© Database Performance Tuning - a course by Ahmed Baraka


Oracle Database Performance Tuning Areas

Performance
Tuning Tools

Instance
SQL Tuning Tuning

Oracle© Database Performance Tuning - a course by Ahmed Baraka


Oracle Database Performance Tuning Areas

Performance
Tuning Tools

Instance
SQL Tuning Tuning

Oracle© Database Performance Tuning - a course by Ahmed Baraka


Performance Issue Attributes
• Scope: entire system or part of it (specific functionality, session, user,
batch, action, ... etc)
• Very slow or hang
• Permanent or intermittent
• Is it reproducible
• Specific Errors, examples:
- ORA-00257: archiver error. Connect internal only, until freed
- ORA-04031: unable to allocate n bytes of shared memory

Oracle© Database Performance Tuning - a course by Ahmed Baraka


Performance Tuning Methodology

1 Set a measurable target

2 Discover the symptoms

3 Determine possible causes

4 Develop a trial solution

Target NO
5 Test the solution
Hit?
YES
End

Oracle© Database Performance Tuning - a course by Ahmed Baraka


A Typical System Workload Example
Dimension Value
Number of users 100
Transaction rate 1 trx per 5 minutes per user
Business hours 8 hours in 5 working days (5x8)
Calculated rate 20 trx per minute, 9,600 transactions daily.
Peak rate 120 trx per minute

Oracle© Database Performance Tuning - a course by Ahmed Baraka


Summary
In this lecture, you should have learnt how to perform the following:
• Describe Oracle database performance tuning areas
• Describe performance issue attributes
• Describe Oracle performance tuning methodology
• Describe a typical system workload

Oracle© Database Performance Tuning - a course by Ahmed Baraka

You might also like