Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Number of threads is twice the number of sessions with 10.2 on Windows platform
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-lReceived on Thu Feb 23 2006 - 14:53:37 CST
![]() |
![]() |