Oracle-L: session idle time

From: Sarnowski, Chris <csarnows_at_CuraGen.com>
Date: Fri, 31 Jan 2003 11:56:10 -0800
Message-ID: <F001.00540E43.20030131115610@fatcity.com>

Oracle 8.1.7.2 on Solaris 8.
I'm looking for a way to see how long a session has been idle or whether it's done any work. I've just been looking at v$sesstat, specifically 'session connect time' and 'process last non-idle time'. But every time I've queried these numbers, they were the same for each SID except SMON (that is, for a given SID, except the SID assiociated with SMON, the 2 numbers are the same). So they must not measure what I guessed they measure.

So the immediate question is, are these statistics useful for anything?

The actual problem I'm trying to solve is, we are using a connection pooling method for Java that seems to allocate far more connections than it ever uses, and I am trying to find a way to document what is actually going on with these connections; i.e. whether some are never used, and how often connections are reused.

thanks for any help, and sorry for the legal goop at the end.

-Chris
--

LEGAL NOTICE:
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.
--

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

Author: Sarnowski, Chris
INET: csarnows_at_CuraGen.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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). Received on Fri Jan 31 2003 - 13:56:10 CST