Performance issue in oracle database
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.
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.
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
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.