Re: V$SESSION Status
From: joel garry <joel-garry_at_home.com>
Date: Fri, 30 Jul 2010 11:35:04 -0700 (PDT)
Message-ID: <31464542-157c-4a40-b7de-6f5c5820013f_at_b4g2000pra.googlegroups.com>
On Jul 30, 11:07 am, The Magnet <a..._at_unsu.com> wrote:
> We've recently put in a profile to disconnect sessions after 2 hours
> of inactivity. We also put into out SQLNET.ORA: SQLNET.EXPIRE_TIME =
> 30
>
> I read the URL below and it says OS processes are not cleaned up. Is
> this true, and if yes, what sense does it make to kill the Oracle
> process when resources at the OS level are still being used.
>
> http://www.sap-img.com/oracle-database/what-does-sniped-status-in-v-s...
Date: Fri, 30 Jul 2010 11:35:04 -0700 (PDT)
Message-ID: <31464542-157c-4a40-b7de-6f5c5820013f_at_b4g2000pra.googlegroups.com>
On Jul 30, 11:07 am, The Magnet <a..._at_unsu.com> wrote:
> We've recently put in a profile to disconnect sessions after 2 hours
> of inactivity. We also put into out SQLNET.ORA: SQLNET.EXPIRE_TIME =
> 30
>
> I read the URL below and it says OS processes are not cleaned up. Is
> this true, and if yes, what sense does it make to kill the Oracle
> process when resources at the OS level are still being used.
>
> http://www.sap-img.com/oracle-database/what-does-sniped-status-in-v-s...
That link seems to be saying it will be cleaned up if you use SQLNET.EXPIRE_TIME, not cleaned up if you don't use it.
Bug 6857474 on MOS (for jdbc) and other notes suggest this may vary depending on a lot of things, so try it and see if it works for you.
It often helps to specify exact Oracle and OS versions, and other relevant info like shared server and type of client. So often, in fact, that you should specify those things every time whether it seems relevant or not. We don't use OCM here.
jg
-- _at_home.com is bogus. http://web.signonsandiego.com/news/2010/jul/23/former-ucsf-employee-pleads-guilty-to-online-scam/Received on Fri Jul 30 2010 - 13:35:04 CDT