Performance issue in oracle database

Asked By rocky esparza 0 points N/A Posted on - 03/07/2012

Hi

If a job is running daily for 10 mins and same job runs for hours one day.how we check the performance issue.which are the things we should check.Pls advice.

• Status: Open
• Question Views: 851
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Franks good

Go To Solution

Answered By aishkarwa 0 points N/A #102790

Performance issue in oracle database

Hi,

On a particular day there could be multiple reasons for the same job to run for longer time.

 1) Number of transactions/data processing could be more.

 2) Low database connectivity:

 3) Broken database objects like indexes on table.

 4) Lock on some related database objects.

 

Thanks

About aishkarwa

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 03/25/2012
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By Franks good 15 points N/A #102791

Performance issue in oracle database

Hi.

You can check the performance of a long term job by placing a target and check on it every time possible.

There should always be update report on daily basis or if too importance may be every hours.

See its transaction daily and use low connectivity database so it won’t make load on system.

 Lock on some related database objects which will help you getting updates regarding performance.

About Franks good

Questions
4

Answers
60

Best Answers
34

• Vote Up 0 Vote Down

• Posted on - 12/11/2012
• Question Category: Oracle Database