SELECT a.sid,
a.username,
c.disk_reads,
c.buffer_gets,
c.sorts,
c.executions,
c.rows_processed,
c.sql_text
FROM v$session a,
v$sqlarea c
WHERE a.sid = &&sessid
AND a.sql_address = c.address
-- AND a.SQL_HASH_VALUE = c.HASH_VALUE
AND c.hash_value =
DECODE( SIGN(a.sql_hash_value), -1, a.sql_hash_value + POWER(2,32),
a.sql_hash_value )
/Not sure if there's still an issue with the hash_value or not.
At 09:18 AM 3/12/2003 -0800, you wrote:
I'm suffering from a senior moment. The question is at the every bottom.
So exactly how do I join V$SQLAREA to V$SESSION?
Andy Rivenes [EMAIL PROTECTED]
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
