Multiple queries to get the SQLTEXT in the oracle database

Use below queries to find the SQL Texts using sql_address and sql_hashvalue

Find sqltext through sqladdress

select sql_address from gv$session where sid=1999;

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

To find sqltext for different sql hashvalues:

select hash_value,sql_text from v$sql where hash_value in (1937378691,1564286875,248741712,
2235840973,2787402785);