ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-048

043-048

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-05 11:12:26 0 删除 编辑
48. You work as a database administrator at Certkiller .com. In your
test database, you find that a user's session is executing a lot of S
QL statements, resulting in the generation of a large number of trace
files. While investigating the reason, you find that SQL trace has b
een enabled at the instance level. You want to disable SQL trace, rem
otely, only for that user session to reduce the volume of trace data
being generated. How do you achieve this objective?
A. by setting the SQL_TRACE parameter to FALSE in the parameter file
B. by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing
for the user session
C. by setting the SQL_TRACE parameter to FALSE by using the ALTER SYS
TEM command in the user session
D. by setting the SQL_TRACE parameter to FALSE by using the ALTER SES
SION command in the user session
Answer: B
session级别的trace控制。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-717719/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 043-047
下一篇: 043-049
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    214067