Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple sessions for same process

baskar.lJul 31 2009 — edited Aug 1 2009

hi all,

the connections coming from development team's pc are still generating 8 processes per connection. For 5 connections, there are 40 processes generated at the backend.

SPID         PROCESS      STATUS   USERNAME        MACHINE              LOGON_TIME        LAST_CALL_ET ACTION                              MODULE
------------ ------------ -------- --------------- -------------------- ----------------- ------------ ----------------------------------- ---------------------------------
      SID    SNO
---------- ------

5589         1234         INACTIVE baskar            app4      07-30-09 10:34:15   .740277778
      841  42309

5587         1234         INACTIVE baskar          app4       07-30-09 10:34:15   .759166667
      669   8131

5585         1234         INACTIVE baskar            app4       07-30-09 10:34:15   .759166667
      541   8816

5583         1234         INACTIVE baskar            app4       07-30-09 10:34:15   .759166667
      703  13085

5591         1234         INACTIVE baskar           app4       07-30-09 10:34:15   .721944444
      619   7052

5581         1234         INACTIVE baskar            app4       07-30-09 10:34:15   .759166667
      521   6696

what might be the issue as a single process as so many session?

thanks,
baskar.l

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2009

Added on Jul 31 2009

#general-database-discussions

7 comments

1,670 views