核心SQL
idle>alter session set tracefile_identifier=‘aaaaaaaaaaaaaaaaa’;
idle>alter session set sql_trace=true;
idle>desc v$parameter;
idle>alter session set sql_trace=false;
idle>oradebug setmypid;
idle>oradebug tracefile_name;
实验详细
idle>alter session set tracefile_identifier='aaaaaaaaaaaaaaaaa';
Session altered.
idle>
idle>
idle>
idle>alter session set sql_trace=true;
Session altered.
idle>
idle>
idle>
idle>desc v$parameter;
Name Null? Type
----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
NUM NUMBER
NAME VARCHAR2(80)
TYPE NUMBER
VALUE VARCHAR2(4000)
DISPLAY_VALUE VARCHAR2(4000)
ISDEFAULT VARCHAR2(9)
ISSES_MODIFIABLE VARCHAR2(5)
ISSYS_MODIFIABLE VARCHAR2(9)
ISINSTANCE_MODIFIABLE VARCHAR2(5)
ISMODIFIED VARCHAR2(10)
ISADJUSTED VARCHAR2(5)
ISDEPRECATED VARCHAR2(5)
ISBASIC VARCHAR2(5)
DESCRIPTION VARCHAR2(255)
UPDATE_COMMENT VARCHAR2(255)
HASH NUMBER
idle>
idle>
idle>
idle>
idle>
idle>alter session set sql_trace=false;
Session altered.
idle>
idle>
idle>
idle>
idle>oradebug setmypid;
Statement processed.
idle>
idle>oradebug tracefile_name;
/opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_42791_aaaaaaaaaaaaaaaaa.trc
idle>
idle>
idle>
idle>