Another V$ question
From: <art_at_unsu.com>
Date: Wed, 27 May 2009 13:49:35 -0700 (PDT)
Message-ID: <115de323-46e3-4694-835d-98ea6784dd61_at_a36g2000yqc.googlegroups.com>
Date: Wed, 27 May 2009 13:49:35 -0700 (PDT)
Message-ID: <115de323-46e3-4694-835d-98ea6784dd61_at_a36g2000yqc.googlegroups.com>
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