Re: Active session

From: dombrooks <dombrooks_at_hotmail.com>
Date: Fri, 11 Jan 2013 02:25:03 -0800 (PST)
Message-ID: <df9ae27d-5830-463d-993d-792ec36efbc0_at_googlegroups.com>

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:
http://hemantoracledba.blogspot.co.uk/2010/08/trying-to-understand-lastcallet-1.html http://dioncho.wordpress.com/2009/05/02/how-long-is-my-query-being-executed/ Received on Fri Jan 11 2013 - 11:25:03 CET