Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

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

4  
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
1  
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

1 Answer 1

Well, you can start here:

http://download.oracle.com/docs/cd/E11882_01/server.112/e16638/part4.htm#g996847

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

 
discard

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