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
