首页 > 其他 > 详细

052-38

时间:2017-12-05 16:57:32      阅读:226      评论:0      收藏:0      [点我收藏+]

To make audit information more productive, the DBA executes the following command before starting
an audit operation:
SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;
Which statement is true regarding the audit record generated when auditing starts after restarting the database?
A.It contains only the plan for the SQL statement executed by the user.
B.It contains the SQL text executed by the user and the bind variables used with it.
C.It contains the plan and statistics associated with the SQL statement executed by the user.
D.It contains the plan for the SQL statement executed by the user and the bind variables used with it.

AUDIT_TRAIL 值含义如下:
DB:启用审计,信息记录在 SYS.AUD$中
OS:启用审计,审计信息保存在操作系统,Oralce 建议使用该配置
Db,extended:启用审计,并且记录对应的执行语句
Xml:启用审计,审计信息以 xml 形式保存在操作系统上
Xml,extended:启用审计,并且包括所有的执行语句

052-38

原文:http://www.cnblogs.com/Babylon/p/7987984.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!