Hai

I have configured MTS.I opend two sessions one session as system/manager@n1,another session as mohan/mohan@n1.
1 st Session (system/manager@n1)is idle(he is not doing anything)

second session(mohan/mohan@n1) is performing some operations such as executing queries etc..


Afterthat i had the below query AT session 1, because mohan user as a normal user he donnot have dba privileges, its showing "session 2 status is INACTIVE"(mohan/mohan@n) .Why it showing the status is inactive of sesion 2 ?.



SQL> select username,server,status from v$session;


USERNAME SERVER STATUS
------------------------------ --------- --------
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE

USERNAME SERVER STATUS
------------------------------ --------- --------
SYSTEM SHARED ACTIVE

MOHAN NONE INACTIVE

14 rows selected.



Thanks in advance
mohan