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!

Same process different sessions

baskar.lJul 30 2010 — edited Aug 24 2010

Hi,

DB version is 10.2.0.1

I could see same process having four different sessions and all are inactive..why is that so ?

SQL> /

SPID         PROCESS      STATUS   USERNAME        MACHINE              LOGON_TIME        LAST_CALL_ET ACTION     MODULE            SID    SNO
------------ ------------ -------- --------------- -------------------- ----------------- ------------ ---------- ---------- ---------- ------
13359        1234         INACTIVE ELOG               vm01       07-30-10 10:37:59   .098333333                              572     34
13841        1234         INACTIVE ELOG               vm01       07-30-10 10:42:07   .029166667                              573     47
13853        1234         INACTIVE ELOG               vm01       07-30-10 10:42:28        .0025                              570    111
13851        1234         INACTIVE ELOG               vm01       07-30-10 10:42:28   .023333333                              583    123

thanks,
baskar.l

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 21 2010

Added on Jul 30 2010

#general-database-discussions

15 comments

2,185 views