trace file 덤프방법

SQL>alter session set events 'immediate trace name buffers level 1';

SQL>@identify_trace_file

          SID    SERIAL# TRACE_FILE
          ---------- ---------- ------------------------------------------
          153      11975 /u01/app/oracle/admin/orcl/udump/orcl_ora_26878.trc

SQL>@external_table_create orcl_ora_26878.trc
SQL>select * f\rom system.TRACE_EXTERNAL;