Another V$ question
Date: Wed, 27 May 2009 13:49:35 -0700 (PDT)
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