Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> oracle nt threads sql / Re: ORACLE-L Digest -- Volume 2002, Number 122

oracle nt threads sql / Re: ORACLE-L Digest -- Volume 2002, Number 122

From: Eric D. Pierce <PierceED_at_csus.edu>
Date: Thu, 02 May 2002 18:53:20 -0800
Message-ID: <F001.004570D2.20020502185320@fatcity.com>


ORACLE-L Digest -- Volume 2002, Number 122
> ------------------------------
>
> From: "Yechiel Adar" <adaryechiel_at_hotmail.com>
> 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: PierceED_at_csus.edu

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: 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 Thu May 02 2002 - 21:53:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US