试题详情
- 单项选择题In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， 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 SYSTEM command in the user session
D、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
- B
关注下方微信公众号，在线模考后查看
热门试题
- Given: Whatisthere
- 假设需要导出某个表table1，只导出表
- Which two are true a
- You plan to execute
- Given： What is
- Which object privile
- The EMPLOYEES&
- Which statement is t
- Which initiali
- 数据处理技术通常分为以下（）类型。
- Last night，
- 在下列各选项中，关于同义词的描述哪一项是
- In Recovery&en
- Users complain
- Why shouldQ
- You are
- Two database&#
- Your database&
- ORACLE9i数据库服务器不能在下列哪
- What is t