[ORACLE] DDL Logging

1. DDL Logging Parameter확인

Default = False

set lines 150
col name for a40
col value for a30
col issys_mod for a50
select name, value, issys_modifiable from v$parameter
where name='enable_ddl_logging'
;

NAME                                     VALUE                          ISSYS_MODIFIABLE
---------------------------------------- ------------------------------ ---------------------------
enable_ddl_logging                       FALSE                          IMMEDIATE

2. Parameter 변경

ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;

3. 로그 위치

ll $ORACLE_BASE/diag/rdbms/*/*/log/ddl/log.xml

<msg time='2022-06-27T15:38:44.257+09:00' org_id='oracle' comp_id='rdbms'
 msg_id='opiexe:4383:2946163730' type='UNKNOWN' group='diag_adl'
 level='16' host_id='oracle1' host_addr='192.168.80.134'
 version='1'>
 <txt>create table test1(c1 number)
 </txt>
</msg>