Since this morning, I have put for only onle process(Procedure). The status for this session in the V$session shows as inactive. The process (Number) as shown in v$session is 248:268, while no such pid exist if I issue
ps -ef command;
Can someone explain to me, What An Inactive session means and how to link a session to a process
select s.sid , s.serial#,
p.spid server_pid, s.username, s.program,
decode(s.process, NULL, s.machine, s.machine || ' PID: ' || to_char(s.process)) "MACHINE/PID" ,
from v$session s, v$process p
where s.username is not null
and s.paddr = p.addr
order by to_number(p.spid)
SID SVR_PID MACHINE /PID STATUS
14, 2000 , REI\6038fhgzc464 PID199:70 ,ACTIVE
16, 9205 , REI\6038fhgzc464 PID248:268 ,ACTIVE
9, 9215 , REI\6038fhgzc464 PID258:256 ,INACTIVE
What does Status Inactive mean ?
Also which id here should I check on ps -ef? is that
svr_pid (2000) or PID (199:80)
ps -ef does not list any of these pid (199,248,258)
The server_pid is the Process ID on the server. You will see this process with ps -ef. The "machine/pid" is the PID of the client process on the client machine. If you do a ps -ef on "machine", then that PID will show up.
INACTIVE means that this session is connected, but is not making any requests against the database at the moment the query was run.
Click Here to Expand Forum to Full Width