Process and Session (PSEUDO)
PID SPID SID SERIAL# PADDR
-------------------------------------------------------------------------------------------------------------
28 305 70 335 0000000091E348F828
Now I killed the session using 'ALTER SYSTEM KILL SESSION '
session details become :
SADDR SID SERIAL# USERNAME STATUS SERVER PADDR
====================================================================================================
0000000091ECD228 70 335 BT_GIS KILLED PSEUDO 0000000091E681F8
Corresponding server process details become:
ADDR PID SPID SID SERIAL# USERNAME SECONDS_IN_WAIT PROGRAM BACKGROUND
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0000000091E348F8 28 305 oracle@gwl09072dat06
Questions :
1) While killing any sessions waiting on 'SQL*Net message from client' will it always marked as 'KILLED' and server will be 'PSUEDO' .(I have seen some which gets 'KILLED' immediately!!)