RE: inactive sessions

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Fri, 02 Nov 2001 04:43:13 -0800
Message-ID: <F001.003BB2E0.20011102044517@fatcity.com>

An INACTIVE status means that the process is still connected to Oracle but not running a query. These are
valid connections and will not be cleaned up.

It is the job of the pmon process to clean up dead connections. It usually wakes up approximately every 5
minutes.

Rick

-----Original Message-----
[mailto:Shrinivas.Tatireddy_at_med.ge.com]
Sent: Friday, November 02, 2001 6:50 AM
To: Multiple recipients of list ORACLE-L

can anybody tell me

when a sessions status becomes INACTIVE in v$session?

thnx and regards,
srinivas
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tatireddy, Shrinivas (MED, Keane) INET: Shrinivas.Tatireddy_at_med.ge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Cale, Rick T (Richard)
INET: RICHARD.T.CALE_at_saic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------