Re: Number of threads is twice the number of sessions with 10.2 on Windows platform

Do you dead connection detection turned on. With DCD on you get an extra thread per connection - at least in 8 and 9i.  

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

>>> "Niall Litchfield" <niall.litchfield_at_gmail.com> 2/23/06 4:49:56 PM
>>>

If you can wait until tomorrow, I'll test this out (linux at home see). In the mean time is this a curious question or an aaarrgggh all my resources have been eaten question?

On 2/23/06, Paolo Desalvo <paolo.desalvo_at_gmail.com> wrote: Hi all.

I have noticed too many threads in the Task Manager related to the ORACLE.EXE process for 10.2.

So I run a simple testcase program on a test server with no activity and I fired 10 SQLPLUS connections to the 10.2 database; the number of threads increased from 31 to 51, so 2 threads for each session connected
to the
database.

Then I run the same program on the same test server directing the connections to a 9.2 database; the number of threads increased from 12 to 22, so 1
thread for each session, as expected.

Is there anybody with the same problem?

Thanks
Paolo

--
http://www.freelists.org/webpage/oracle-l 





-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info 
 

--
http://www.freelists.org/webpage/oracle-l