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');
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');
HIDDEN CONTENT spool toto set time on termout on flush on timing on trimspool on echo on ..... spool off hope this help
For RAC environnement, I sill don't know How to see them without connecting directly to the instance ... set lines 200 pages 500 col value for a10 col isdefault for a10 col name for a40 col DESCRIPTION for a60 col SESMOD for a10 col SYSMOD for a10 SELECT...