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; ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 9:21 PM > You can see process threads in NT Performance Monitor. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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).
