select
ADDRESS, -- ADDRESS RAW(8)
HASH_VALUE, -- HASH_VALUE NUMBER
SQL_ID, -- SQL_ID VARCHAR2(13)
COMMAND_TYPE, -- COMMAND_TYPE NUMBER
PIECE, -- PIECE NUMBER
SQL_TEXT -- SQL_TEXT VARCHAR2(64)
from
GV$SQLTEXT
where
inst_id = USERENV('Instance')