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控制。
session级别的trace控制。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-717719/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
