Performance issue in oracle database

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Franks good
Answered By 0 points N/A #102790

Performance issue in oracle database

qa-featured

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

Best Answer
Best Answer
Answered By 15 points N/A #102791

Performance issue in oracle database

qa-featured

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.

Related Questions