query to find the SQLTEXT in datbase oracle

 query to find the SQLTEXT in datbase oracle

Find sqltext through sqladdress

select sql_address from gv$session where sid=36;

select sql_text from v$sqltext where ADDRESS='D00000034GG11BH1' order by PIECE;

To find sqltext for different sql hashvalues:

select hash_value,sql_text from v$sql where hash_value in (3417378547,6564768875,8753841712,

1353497310,7874027456);