Solved...........RE: CPUs NOT getting consumed ?
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 5 Oct 2005 20:35:23 +0530
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Gogala, Mladen
Sent: Tuesday, October 04, 2005 12:16 PM
To: 'rjamya@xxxxxxxxx'; VIVEK_SHARMA@xxxxxxxxxxx
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@xxxxxxxxx]
Sent: Tuesday, October 04, 2005 1:05 PM
To: VIVEK_SHARMA@xxxxxxxxxxx
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***
Other related posts:
- » Solved...........RE: CPUs NOT getting consumed ?
