Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?
A.
Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
B.
All DDL commands are logged in the alert log file.
C.
All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
D.
Only DDL commands that resulted in the creation of new segments are logged.
E.
All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic
Repository (ADR) home.
Explanation:
The log files are created only in $ADR_HOME/log
in alert log only alter system is catched.
Sun Mar 30 23:30:04 2014
ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;
Sun Mar 30 23:32:41 2014
ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;
Sun Mar 30 23:39:35 2014
ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=BOTH;
[oracle@ovs trace]$
only in diag/rdbms/…/../log/ two files are capturing this. The xml file is capturing full details and text file having
only the commands.
[oracle@ovs log]$ pwd
/oraclebase/diag/rdbms/ora12c1/ora12c1/log
[oracle@ovs log]$ cat ddl/*
create table testing2(a number)
create table testing3( aa number)
[oracle@ovs log]$ cat ddl_ora12c1.log
Sun Mar 30 23:33:26 2014
diag_adl:create table testing2(a number)
diag_adl:create table testing3( aa number)
http://docs.oracle.com/database/121/REFRN/refrn10302.htm#REFRN10302