Re: 100% CPU utilization, urgent

From: Thomas Day <tday6_at_csc.com>
Date: Mon, 20 Jan 2003 09:34:25 -0800
Message-ID: <F001.00534D71.20030120093425@fatcity.com>

Does this help?

select

  p.spid "ID_THREAD"


, p.background "BACKGROUND"

, b.name "NAME"

, s.sid "SID"
, s.serial# "SERIAL#"
, NVL(S.USERNAME, 'SYS') "USERNAME"
, s.status "STATUS"
, s.osuser "OSUSER"
, s.program "PROGRAM"
, S.TYPE
, T.VALUE "CPU"

from sys.v_$process p
, sys.v_$bgprocess b
, sys.v_$session s
, V$SESSTAT T,

  V$STATNAME N
where N.NAME = 'CPU used by this session'

and s.paddr = p.addr
and b.paddr(+) = p.addr
AND T.STATISTIC# = N.STATISTIC#
AND S.SID = T.SID

order by s.sid
/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Day
  INET: tday6_at_csc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jan 20 2003 - 11:34:25 CST