Property | Description |
---|---|
Parameter type |
Boolean |
Default value |
|
Modifiable |
|
Modifiable in a PDb |
Yes |
Range of values |
|
Basic |
No |
ENABLE_DDL_LOGGING
enables or disables the writing of a subset of data definition language (DDL) statements to a DDL log.
The DDL log is a file that has the same format and basic behavior as the alert log, but it only contains the DDL statements issued by the database. The DDL log is created only for the RDBMS component and only if the ENABLE_DDL_LOGGING
initialization parameter is set to true
. When this parameter is set to false
, DDL statements are not included in any log.
The DDL log contains one log record for each DDL statement issued by the database. The DDL log is included in IPS incident packages.
There are two DDL logs that contain the same information. One is an XML file, and the other is a text file. The DDL log is stored in the log/ddl
subdirectory of the ADR home.
When ENABLE_DDL_LOGGING
is set to true
, the following DDL statements are written to the 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
## 062考题 Examine the command: SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true in this scenario? (Choose two.)
A. All data definition language (DDL) commands are logged in to the alert log file.
B. All DDL commands are logged in to a text file in Automatic Diagnostic Repository (ADR) home.
C. A subset of executed DDL statements is written into an XML file in ADR home.
D. A subset of executed DDL statements is written to the DDL log in ADR home.
E. All DDL commands are logged in to a trace file in ADR home.
Answer: C,D