Re: Any Info on :- v$detached_Session

From: K Gopalakrishnan <>
Date: Mon, 26 May 2008 18:12:38 -0500
Message-ID: <>


In simplest terms,the view v$detached_session shows the server processes without (!) client process. For example when you kill a session (using ALTER SYSTEM), the server processes will not go away unless the client tries to send some request (then it gets the 'your session has been killed' message) to the instance. This also can happen when the server process is not able to detect the death of a client process (during network failures).

I think V$detached_session.pg_name (which is V$PROCESS_GROUP.NAME) is the name of the process group which holds the detached sessions. Look the additional columns in the X$ksupgs for some more info.


On Mon, May 26, 2008 at 10:43 AM, Amit Verma <> wrote:
> All,
> Do you have any info on v$detached_Session the Oracle 11g New Feature!
> Note:- No Details on Oracle Reference Guide 11g
> No On-Line document Detail 11g
> Thanks,
> Amit Verma
> Oracle DBA & System Adminstrator
> E-Mail:-,
> WebSite:-
> IM:-
> Mobile:- (+91) 98910.98927

Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
Received on Mon May 26 2008 - 18:12:38 CDT

Original text of this message