Find SQL statement from SID

select sql_text from gv$sqltext where hash_value in (select sql_hash_value
from gv$session where sid in (&sid)) order by hash_value, piece;