WE have a job running very slowly. And I required to produce the analysis of CPU/ memory utilization during that backup.Also need statustics around the database performance for that batch job.
How to do this, please help me on this.
This question came from our site for professional and enthusiast programmers.
Well, you can start here:
Besides that the Oracle Enterprise Manager provides the quickest way to monitor a running process. The most common problem is missing an index and the tuning advisor will point that out quickly.