12C DDL logging

在12C中引入了DDL日志的功能，通过enable_ddl_logging参数来控制，设置为TRUE后，会将执行过的DDL语句记录到log文件中，文件类似 $ORACLE_BASE/diag/rdbms/orcl12c/orcl12c/log/ddl_orcl12c.log。
下面简单测试了下：
[code]SQL> show parameter enable_ddl_logging

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_ddl_logging boolean FALSE
SQL> alter session set enable_ddl_logging = true;

Session altered.

SQL> show parameter enable_ddl_logging

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_ddl_logging boolean TRUE
SQL> show user;
USER is "C##AWEN"
SQL> create table ddl_test as select * from dba_objects where rownum<100;

Table created.

SQL> truncate table ddl_test;

Table truncated.

SQL> drop table ddl_test purge;

Table dropped.

SQL> alter session set enable_ddl_logging = false;

Session altered.

[oracle@ora12c ~]$ cd $ORACLE_BASE/diag/rdbms/orcl12c/orcl12c/log/
[oracle@ora12c log]$ ls
ddl ddl_orcl12c.log debug test
[oracle@ora12c log]$ cat ddl_orcl12c.log
Wed Aug 28 15:47:41 2013
diag_adl:create table ddl_test as select * from dba_objects where rownum<100
diag_adl:truncate table ddl_test
diag_adl:drop table ddl_test purge
[oracle@ora12c log]$ pwd
/oracle/12c/diag/rdbms/orcl12c/orcl12c/log
[oracle@ora12c log]$[/code]