Solved...........RE: CPUs NOT getting consumed ?

Folks

Cause was ENQUEUE Locking.

After 15 minutes of execution of the Benchmark run, One process would Hold a Lock while all the rest would go into WAITING for EXCLUSIVE lock.

Same found from Output of $ORACLE_HOME/rdbms/admin/utllockt.sql

This correspondingly caused CPU Usage to crash down from 50 %(observed from start of run up to 15 minutes) Down to Zero % (post 15 minutes scenario).

Thanks again to all - Mladen, Raj, Jim, Mcdonald, Cary

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Cary Millsap Sent: Tuesday, October 04, 2005 11:40 PM To: 'Oracle-L'
Subject: RE: CPUs NOT getting consumed ?

Detailed discussion is available in Millsap/Holt Optimizing Oracle Performance, pages 141-149 and, perhaps of particular interest to Raj in light of Mladen's comment, pages 161-165.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com <http://www.hotsos.com/> Nullius in verba

Visit www.hotsos.com <http://www.hotsos.com/> for curriculum and schedule details...

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gogala, Mladen Sent: Tuesday, October 04, 2005 12:16 PM To: 'rjamya_at_gmail.com'; VIVEK_SHARMA_at_infosys.com Cc: Oracle-L
Subject: RE: CPUs NOT getting consumed ?

CPU is measured only after the SQL stops executing. CPU consumption is NOT measured in real time.

CPU consumption is meaningful only for the statements that are not being actively executed.

--

Mladen Gogala

Ext. 121



________________________________


From: rjamya [mailto:rjamya_at_gmail.com]
Sent: Tuesday, October 04, 2005 1:05 PM
To: VIVEK_SHARMA_at_infosys.com
Cc: Oracle-L
Subject: Re: CPUs NOT getting consumed ?



I don't suppose your app will be continuously using CPU. If it is, you
have a beast of a problem to handle. Could it be that your processi is
doing I/O and hence not using CPU?

Another minor question, why are you worried that is isn't using the CPU.
Raj



**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--
http://www.freelists.org/webpage/oracle-l