DBA Hub

📋Steps in this guide1/1

ENABLE_DDL_LOGGING In Oracle 12c

This  ENABLE_DDL_LOGGING parameter has been introduced in oracle 12c.

oracle configurationintermediate
by OracleDba
16 views
1

Overview

This ENABLE_DDL_LOGGING parameter has been introduced in oracle 12c. If this ENABLE_DDL_LOGGING is enabled , then DDL records are written to the ADR.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
SQL> show parameter enable_ddl_logging
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_ddl_logging boolean FALSE


SQL> alter system set enable_ddl_logging=true;
System altered.

SQL> show parameter enable_ddl_logging
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_ddl_logging boolean TRUE

SQL> create user abc identified by abc;
User created.

SQL> create table abc.t8 (n number);
Table created.

SQL> drop user abc cascade;
User dropped.

cd /u02/app/oracle/diag/rdbms/prim/prim/log/ddl

[oracle@localhost ddl]$ more log.xml 
<msg time=’2014-07-10T01:52:00.323-04:00′ org_id=’oracle’ comp_id=’rdbms’  msg_id=’kpdbLogDDL:15115:2946163730′ type=’UNKNOWN’ group=’diag_adl’ level=’16’ host_id=’usa0300lx574′ host_addr=’13.129.131.42′ version=’1′>

Comments (0)

Please to add comments

No comments yet. Be the first to comment!