Check Executed Sql Status

find with session SID

SELECT SID, USERNAME FROM V$SESSION WHERE USERNAME = 'THE_USER';
SELECT SQL_TEXT FROM V$SQL WHERE SQL_ID IN (SELECT PREV_SQL_ID FROM V$SESSION WHERE SID = 146);

find with explain

explain plan for insert into t select * from t@link_10g;
select * from table(dbms_xplan.display);