V$SESSION Status
From: The Magnet <art_at_unsu.com>
Date: Fri, 30 Jul 2010 11:07:57 -0700 (PDT)
Message-ID: <2260a3d7-f689-405a-906e-36fae76cf216_at_t5g2000prd.googlegroups.com>
Date: Fri, 30 Jul 2010 11:07:57 -0700 (PDT)
Message-ID: <2260a3d7-f689-405a-906e-36fae76cf216_at_t5g2000prd.googlegroups.com>
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-session-mean.htm Received on Fri Jul 30 2010 - 13:07:57 CDT