Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

migrated from Feb 7 '11 at 4:33

This question came from our site for professional and enthusiast programmers.

sounds like you need to bring in a consultant, if you don't have these skills in-house – Mitch Wheat Feb 7 '11 at 2:44
More details would help. Do you have OEM or some third-party monitoring tool. What edition, version, options/packs are you licensed for ? What is the job. howe long does it take. How long do you think it should take. What volume of data is being processed – Gary Feb 7 '11 at 3:29
What platform? Unix based platform have a sar utility which can capture cpu, memory, and disk utilization data. – BillThor Feb 7 '11 at 4:51
What version of Oracle? What edition (enterprise, standard, etc.)? Do you have the performance and tuning packs licensed? – Justin Cave Feb 7 '11 at 5:31

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.