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@xxxxxxxxx> 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 > -- > //www.freelists.org/webpage/oracle-l > > > -- Niall Litchfield Oracle DBA http://www.orawin.info