Re: High number of Oracle thread on Windows

From: Norman Dunbar <Norman_at_Dunbar-it.co.uk.REMOVETHIS>
Date: Tue, 15 Feb 2005 18:52:37 +0100
Message-ID: <cutg4i$of9$2$8300dec7@news.demon.co.uk>

Andras Kovacs wrote:
<SNIP>
>
> v$process count is 90 and v$session count is 88. Usually the server
> runs on 80-100 threads. Anybody knows how to trace back the source of
> these threads ?

Here's a script I used in my last contract. We had Oracle.exe running as a single process with each session and background running as a thread (each) off of the main process - it was Windows 2000 and 9201 of Oracle.

The output from the script could be used to trace a user session on Oracle back to a thread ID on Windows by using the Performance utility.

Might help - maybe.

Cheers,
Norm.

/*-------------------------------------------------------------------
  * this script lists NT thread IDs and who they are connected to etc.

Can be used to identify runaway processes on NT using the Performance
Manager utility under start | programs | admin tools. -------------------------------------------------------------------*/ set lines 250 set trimspool on

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;

<END SCRIPT> Received on Tue Feb 15 2005 - 11:52:37 CST