SQLトレースに関するメモ

SQL> alter session set sql_trace=true;

Session altered.

SQL> select to_char(sysdate,'yyyymmddhh24miss') from dual;

TO_CHAR(SYSDAT
--------------
20121017170716

SQL> exit

[oracle@localhost ~]$ cd app/oracle/diag/rdbms/orcl/orcl/trace/
[oracle@localhost trace]$ grep tim  orcl_ora_2924.trc|head -1
PARSING IN CURSOR #18872088 len=32 dep=0 uid=346 oct=42 lid=346 tim=1350518824929181 hv=1569151342 ad='adfeb0' sqlid='4tk6t8tfsfqbf'
[oracle@localhost trace]$ sqlplus neo/zion
SQL> select to_char(to_date(20121017170716,'yyyymmddhh24miss') - 1350518824929181 / (24*60*60*1000000),'yyyymmddhh24miss') from dual;

TO_CHAR(TO_DAT
--------------
19691231170011

SQL> select to_char(to_date(19691231170011,'yyyymmddhh24miss') + 1350518824929181 / (24*60*60*1000000),'YYYY-MM-DD HH24:MI:SS') from dual;

TO_CHAR(TO_DATE(196
-------------------
2012-10-17 17:07:16