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_at_ora-600.net>
Date: Tue, 3 Jul 2007 07:48:31 -0700
Message-ID: <002401c7bd81$3a0a68a0$0501a8c0@flbp7000a>

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?

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 03 2007 - 09:48:31 CDT