12C-OCP升级1z-060-022
来源:互联网 发布:宝利通双流软件 编辑:程序博客网 时间:2024/06/05 19:55
Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=FALSE;
Which statement is true?
A. None of the data definition language (DDL) statements are logged in the trace file.
B. Only DDL commands that resulted in errors are logged in the alert log file.
C. A new log.xml file that contains the DDL statements is created, and the DDL command
details are removed from the alert log file.
D. Only DDL commands that resulted in the creation of new database files are logged.
正确答案:A
官方文档的位置:
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams085.htm#REFRN10302
生产环境经常遇到DROP、TRUNCATE、DELETE等误操作,
其中大部分影响较大的是DDL,11.2 设置ENABLE_DDL_LOGGING为true后,alert中会记录DDL操作的语句,但是没有详细信息:
alter system set enable_ddl_logging = TRUE sid='*' scope=spfile;
12C中的开启ENABLE_DDL_LOGGING后,会专门有一个日志文件记录详细的信息。
ALTER SYSTEM SET enable_ddl_logging=FALSE;
Which statement is true?
A. None of the data definition language (DDL) statements are logged in the trace file.
B. Only DDL commands that resulted in errors are logged in the alert log file.
C. A new log.xml file that contains the DDL statements is created, and the DDL command
details are removed from the alert log file.
D. Only DDL commands that resulted in the creation of new database files are logged.
正确答案:A
官方文档的位置:
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams085.htm#REFRN10302
生产环境经常遇到DROP、TRUNCATE、DELETE等误操作,
其中大部分影响较大的是DDL,11.2 设置ENABLE_DDL_LOGGING为true后,alert中会记录DDL操作的语句,但是没有详细信息:
alter system set enable_ddl_logging = TRUE sid='*' scope=spfile;
12C中的开启ENABLE_DDL_LOGGING后,会专门有一个日志文件记录详细的信息。
SQL> select * from v$version;BANNER CON_ID-------------------------------------------------------------------------------- ----------Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 0--默认没有开启SQL> show parameter enable_ddl_loggingNAME TYPE VALUE------------------------------------ ----------- ------------------------------enable_ddl_logging boolean FALSESQL> alter system set enable_ddl_logging=true;System altered.SQL> show parameter enable_ddl_loggingNAME TYPE VALUE------------------------------------ ----------- ------------------------------enable_ddl_logging boolean TRUESQL> create table goolen as select * from dba_objects;Table created.SQL> create index ind_oid on goolen(object_id);Index created.SQL> alter table goolen modify(object_id not null);Table altered.SQL> truncate table goolen;Table truncated.SQL> drop table goolen purge;Table dropped.$ adrciADR base = "/opt/app/oracle"adrci> show logChoose the home from which to view diagnostic logs:1: diag/tnslsnr/release-mysql/listener2: diag/rdbms/ora12c/ora12cQ: to quit$ cd /opt/app/oracle/diag/rdbms/ora12c/ora12c/log$ lsddl ddl_ora12c.log debug test$ cat ddl_ora12c.log diag_adl:create table goolen as select * from dba_objectsdiag_adl:create index ind_oid on goolen(object_id)diag_adl:alter table goolen modify(object_id not null)diag_adl:truncate table goolendiag_adl:drop table goolen purge$ cat ddl/log.xml msg_id='opiexe:4181:2946163730' type='UNKNOWN' group='diag_adl' level='16' host_id='release' host_addr='192.168.100.92' version='1'> create table goolen as select * from dba_objects msg_id='opiexe:4181:2946163730' type='UNKNOWN' group='diag_adl' level='16' host_id='release' host_addr='192.168.100.92'> create index ind_oid on goolen(object_id) msg_id='opiexe:4181:2946163730' type='UNKNOWN' group='diag_adl' level='16' host_id='release' host_addr='192.168.100.92'> alter table goolen modify(object_id not null) msg_id='opiexe:4181:2946163730' type='UNKNOWN' group='diag_adl' level='16' host_id='release' host_addr='192.168.100.92'> truncate table goolen msg_id='opiexe:4181:2946163730' type='UNKNOWN' group='diag_adl' level='16' host_id='release' host_addr='192.168.100.92'> drop table goolen purge
0 0
- 12C-OCP升级1z-060-022
- 12C-OCP升级1z-060-001
- 12C-OCP升级1z-060-002
- 12C-OCP升级1z-060-003
- 12C-OCP升级1z-060-004
- 12C-OCP升级1z-060-006
- 12C-OCP升级1z-060-007
- 12C-OCP升级1z-060-008
- 12C-OCP升级1z-060-009
- 12C-OCP升级1z-060-010
- 12C-OCP升级1z-060-011
- 12C-OCP升级1z-060-005
- 12C-OCP升级1z-060-013
- 12C-OCP升级1z-060-012
- 12C-OCP升级1z-060-014
- 12C-OCP升级1z-060-015
- 12C-OCP升级1z-060-016
- 12C-OCP升级1z-060-017
- php+js字符串的拼接
- caffe中的iteration,batch_size, epochs理解
- hdu 1023 Train Problem II
- c++忽略大小比较
- iOS 截图
- 12C-OCP升级1z-060-022
- initWithContentFile 与imageName
- RecyclerView Bug:IndexOutOfBoundsException: Inconsistency detected. Invalid item position …
- 通过注册表修改IE的Internet选项
- getClass(),class属性和getName()解析(整理)
- openwrt 下调试实现wifi 开启/关闭及设置指示灯
- 练习8:打印,打印。。。
- hdoj1495非常可乐《bfs》
- PDO连接数据库及DSN详解