Oracle E-Business Suite Show Active Database Sessions Details (Machine, Program, Module, Username, Action,…… )

You can use the following SQL statement to get the full session information (SID, Serial#, Machine, Program, Module, Username, Responsibility,……….).

SELECT S.AUDSID        "AUDSID"  ,
       S.SID           "SID"     ,
       S.SERIAL#       "SERIAL#" ,
       I.INSTANCE_NAME "Instance",
       S.MACHINE       "Machine" ,
       S.TERMINAL      "Terminal",
       S.PROGRAM       "Program" ,
       S.MODULE        "Module"  ,
       S.USERNAME      "Username",
       S.ACTION        "Action"  ,
       S.OSUSER        "OS User" ,       
       S.PROCESS       "Process" ,
       S.STATUS        "Status",
       S.LOGON_TIME    "Logon Time"
  FROM GV$SESSION  S,
       GV$INSTANCE I
 WHERE S.AUDSID > 0
   AND S.INST_ID = I.INST_ID;
Advertisements