Hi
You can use the top command to resolve your problem.
-----Original Message-----
From: Mahesh Sawant
[mailto:oracledba-ezmlmshield-x31586174.[Email address protected]
Sent: Thursday, August 31, 2006 6:29 PM
To: LazyDBA Discussion
Subject: CPU utilization is 100 %
Hi All,
My have server utilization is 100 %.
Can any one guide me how to fine the root cause.
How to find which session is utilize how much resources?
Also i need to know which query cause for the same.
Thanks & Regards
Mahesh Sawant
________________________________
Tech Mahindra Limited, Pune
* +0091 20 56018100, Extn: 3845
* (Mob) 9869263680
========================================================================
====================================================
Tech Mahindra, formerly Mahindra-British Telecom.
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.
========================================================================
====================================================
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
============================================================================================================================
Tech Mahindra, formerly Mahindra-British Telecom.
Disclaimer:
This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
============================================================================================================================
Oracle LazyDBA home page