当需要确定某些ddl操作什么时候发生，确定是表啥时间被动了，可以设置此参数。
alter system set enable_ddl_logging=true;
效果图如下：
SQL> create table tmp_lk as select * from dba_objects where rownum=1;
Table created.
SQL> alter table tmp_lk modify object_name varchar2(100);
Table altered.
SQL>
告警日志如下：
2015-05-15 17:18:20.128000 +08:00
ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;
2015-05-15 17:18:55.148000 +08:00
create table tmp_lk as select * from dba_objects where rownum=1
2015-05-15 17:20:12.431000 +08:00
alter table tmp_lk modify object_name varchar2(100)
ENABLE_DDL_LOGGING
| Property | Description |
|---|---|
| Parameter type | Boolean |
| Default value | false |
| Modifiable | ALTER SESSION, ALTER SYSTEM |
| Range of values | true | false |
| Basic | No |
ENABLE_DDL_LOGGING enables or disables the writing of a subset of DDL statements to the alert log.
When ENABLE_DDL_LOGGING is set to true, the following DDL statements are written to the alert log:
-
ALTER/CREATE/DROP/TRUNCATE CLUSTER
-
ALTER/CREATE/DROP FUNCTION
-
ALTER/CREATE/DROP INDEX
-
ALTER/CREATE/DROP OUTLINE
-
ALTER/CREATE/DROP PACKAGE
-
ALTER/CREATE/DROP PACKAGE BODY
-
ALTER/CREATE/DROP PROCEDURE
-
ALTER/CREATE/DROP PROFILE
-
ALTER/CREATE/DROP SEQUENCE
-
CREATE/DROP SYNONYM
-
ALTER/CREATE/DROP/RENAME/TRUNCATE TABLE
-
ALTER/CREATE/DROP TRIGGER
-
ALTER/CREATE/DROP TYPE
-
ALTER/CREATE/DROP TYPE BODY
-
DROP USER
-
ALTER/CREATE/DROP VIEW
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29477587/viewspace-1656549/ ，如需转载，请注明出处，否则将追究法律责任。
