RE: How do I find top CPU consumers on a windows machine running Oracle 9i (9.2.0.4 Enterprise Edition)?
- From: "Jeremiah Wilton" <jeremiah@xxxxxxxxxxx>
- To: <WLJohnson@xxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 3 Jul 2007 07:48:31 -0700
Oracle tracks the CPU usage of its own sessions and presents it in
gv$sesstat. It may not be accurate, but the inaccurate data of one session
is somewhat accurately relative to that of others. So a serious offender
should stand out. Gv$sesstat joins to gv$session by SID and INST_ID for
the session info and to gv$statname by STATISTIC# and INST_ID to restrict by
statistic. You can start with 'CPU used by this session'.
Remember this data is cumulative from the last startup, so it is best if you
query the data twice separated by an interval, then find the delta for each
INST_ID,SID,SERIAL# pair. That way you are looking at current data. It is
a little like 'top' for Oracle.
You can ignore INST_ID and just use v$ views if there is only one instance,
or you are only interested in one instance.
Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net
________________________________________
From: Johnson, William L (TEIS)
Does anyone have a utility to find the top CPU consumers on a windows
machine?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
