12c如何监控DDL

这篇文章主要介绍了12c如何监控DDL，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。

SQL> show parameter ENABLE_DDL_LOGGING

NAME     TYPE VALUE

------------------------------------ ----------- ------------------------------

enable_ddl_logging     boolean FALSE

SQL> alter system set ENABLE_DDL_LOGGING=true;

SQL> create table look2 as select * from look;

Table created.

SQL> drop table look2;

Table dropped.

SQL>

 create table look2 as select * from look

[oracle@cloud12c ddl]$ cat log.xml 

msg_id=opiexe:4695:2946163730 type=UNKNOWN group=diag_adl

 level=16 host_id=cloud12c host_addr=10.60.17.99

pid=7510 version=1>

 alter table look modify (money visible)

 msg_id=opiexe:4695:2946163730 type=UNKNOWN group=diag_adl

level=16 host_id=cloud12c host_addr=10.60.17.99

 pid=7510>

 create table look2 as select * from look

msg_id=opiexe:4695:2946163730 type=UNKNOWN group=diag_adl

 level=16 host_id=cloud12c host_addr=10.60.17.99

pid=7510>

 drop table look2

[oracle@cloud12c ddl]$ pwd

/u01/app/oracle/diag/rdbms/orcl/cloud/log/ddl

感谢你能够认真阅读完这篇文章，希望小编分享的“12c如何监控DDL”这篇文章对大家有帮助，同时也希望大家多多支持，关注行业资讯频道，更多相关知识等着你来学习!