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.
migrated from stackoverflow.com Feb 7 '11 at 4:33
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.