Re: Any Info on :- v$detached_Session

Amit,

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.

-Gopal

On Mon, May 26, 2008 at 10:43 AM, Amit Verma <in.amitverma_at_gmail.com> 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:- in.amitverma_at_gmail.com, v.amit_at_hotmail.com
> WebSite:- http://www.linkedin.com/in/vamit
> IM:- verma.labs_at_gmail.com
> Mobile:- (+91) 98910.98927

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
http://www.freelists.org/webpage/oracle-l