ORACLE Join V$SQLAREA V$SESSION

Question

hi all,

which column i need to use to join V$session and V$sqlarea?

My main aim is to find top 5 queries with most disk_reads and generate a report containing relevant information.

Thanks

Answer 1

This SQL does the join:

select s.sid, s.serial#, a.sql_text
from v$session s
join v$sqlarea a on a.hash_value = s.sql_hash_value;