Re: Active session

From: dombrooks <>
Date: Fri, 11 Jan 2013 02:25:03 -0800 (PST)
Message-ID: <>

I always use STATUS = 'ACTIVE', the STATE and a filter on the event if WAITING.

For actively executing SQL, SQL_EXEC_ID and SQL_EXEC_START can be useful but recursive SQL complicates the situation.

LAST_CALL_ET isn't that useful.
See: Received on Fri Jan 11 2013 - 11:25:03 CET

Original text of this message