I have configured MTS on my database .Its showing SERVER "SHARED" STATUS IS "ACTIVE" when query at individual sessions example if connect to dayabase using system account .
SQL> select username,server,status from v$session;

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



If connect to some other user account called perfstat and query from perfstat its showing SYSTEM STATUS IS NONE.Its suppose to show STATUS IS "ACTIVE" because running a query under those accounts (sys,system) and ran the the long running query at system sessions it took me aroud 20 min . Why it showing "INACTIVE " status of SYSTEM

SQL>conn perfstat/perfstat@mm

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


USERNAME SERVER STATUS
------------------------------ --------- --------
PERFSTAT SHARED ACTIVE
SYSTEM NONE INACTIVE
SYS SHARED INACTIVE


This is my configuration files as i followed

Add parametrs for connection pooling In Init.ora file
================================================== ====
db_name = "demo"
instance_name = demo
service_names = demo
mts_service="demo"

mts_dispatchers =
"(protocol=TCP)(disp=4)(conn=500)(host=mohan-2k)(list=MOHAN)(pool=on)(tick=1)
(sessions=4000)"

MTS_MAX_DISPATCHERS =16
MTS_SERVERS =2
MTS_MAX_SERVERS =10

Tnsnames.ora
=============
(The below netservice name used at server where database resides)

MTS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.62)(PORT = 1528))
)
(CONNECT_DATA =
(SERVICE_NAME = demo)
(SRVR = SHARED)
)
)





(The below netservice name used at Client side )

MM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mohan-2k)(PORT = 1528))
)
(CONNECT_DATA =
(SERVICE_NAME = demo)
(SRVR = SHARED)
)
)

Listener.ora
============:


MOHAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mohan-2k)(PORT = 1528))
)

SID_LIST_MOHAN =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DEMO)
(ORACLE_HOME = D:\ORACLE\ORA81)
(SID_NAME = DEMO)
)
)

Status of dispatchers
=====================:
LSNRCTL> services mohan
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mohan-2k)(PORT=1528)))
Services Summary...
Service "DEMO" has 2 instances.
Instance "DEMO"
Status: READY Total handlers: 1 Relevant handlers: 1
Class: ORACLE
DEDICATED established:0 refused:0 current:0 max:0 state:ready
(ADDRESS=(PROTOCOL=beq)(PROGRAM=oracle)(ENVS=)(ARG V0=oracleDEMO)(ARGS='(
LOCAL=NO)'))
Instance "demo"
Status: READY Total handlers: 4 Relevant handlers: 4
Class: ORACLE
D003 established:0 refused:0 current:0 max:4000 state:ready
(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(PORT=1272))
Session: NS
D002 established:0 refused:0 current:0 max:4000 state:ready
(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(PORT=1271))
Session: NS
D001 established:0 refused:0 current:0 max:4000 state:ready
(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(PORT=1270))
Session: NS
D000 established:0 refused:0 current:0 max:4000 state:ready
(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(PORT=1269))
Session: NS
The command completed successfully
LSNRCTL>


Thanks in advance
mohan