ORACLE-L Digest -- Volume 2002, Number 122 > ------------------------------ > > From: "Yechiel Adar" <[EMAIL PROTECTED]> > Date: Wed, 1 May 2002 13:14:18 +0200 > Subject: Re: CPU Pegged at 100% > > Hello Igor > > Thank you for the info. > > I got the following script from one of the articals that Thomas Day point > to in the message With subject Oracle & windows. It shows the threads that > oracle is using. The first column has a call to some function that > probably did some formating but I deleted it. > > create or replace view > NT_threads > as > select > p.spid "ID_THREAD", > p.background "BACKGROUND", > b.name "NAME", > s.sid "SID", > s.serial# "SERIAL#", > s.username "USERNAME", > s.status "STATUS", > s.osuser "OSUSER", > s.program "PROGRAM" > from > v$process p, > v$bgprocess b, > v$session s > where > s.paddr = p.addr > and > b.paddr(+) = p.addr; > >
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).