Re: Any Info on :- v$detached_Session
- From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
- To: in.amitverma@xxxxxxxxx
- Date: Mon, 26 May 2008 18:12:38 -0500
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@xxxxxxxxx> 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@xxxxxxxxx, v.amit@xxxxxxxxxxx
> WebSite:- http://www.linkedin.com/in/vamit
> IM:- verma.labs@xxxxxxxxx
> 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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
