How to locate where a bugged sql failed abnormaly

HIDDEN CONTENT

alter session set tracefile_identifier = majda;
alter session set events '10046 trace name context forever, level 12' ;
exec  dbms_refresh.refresh('AS2CARAT.AT_N_AGE');