Another V$ question

From: <>
Date: Wed, 27 May 2009 13:49:35 -0700 (PDT)
Message-ID: <>

Why is it so hard for Oracle to give proper documentation, instead of putting hundreds of columns into their V$ views that even they do not understand.

I want to know 1 thing:

1 - How long a query has been running thus far. not from SQLPLUS using 'timing', but from a stored procedure that looks at the V$ views.

What do I have to work with? LAST_CALL_ET, SECONDS_IN_WAIT, WAIT_TIME, etc......

So, the session is ACTIVE, how long has that session been ACTIVE? Why does Oracle make this so hard from a SQL Query standpoint? Received on Wed May 27 2009 - 15:49:35 CDT

Original text of this message