Are your results consistent? I also appeared to get the same behaviour using XE (which is 10.2 based), but not 10.1 or 9.2. However when I reran I discovered that Oracle appeared to be more proactive in managing threads on 10.2 than it was in earlier versions and that I didn't apparently always get two threads per foreground session. I didn't have sqlnet.expire_time enabled. So right now I'm just confused as usual. Niall On 2/24/06, Giovanni Cuccu <giovanni.cuccu@xxxxxxxxx> wrote: > > Hi Paolo, > I can confirm the issue on 10.2, I also checked the RAM allocated > for a single sqplus and it's 3MB, my next question is if the > additional thread is given the 1mb stack. > Giovanni > > > > -- > -------------------------------------------------------------------- > Another free oracle resource profiler > http://sourceforge.net/projects/oraresprof/ > Now version 0.9 > -- > //www.freelists.org/webpage/oracle-l > > > -- Niall Litchfield Oracle DBA http://www.orawin.info