单选题

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

略

相似试题

How can you change the cursor style in your form? （）
单选题查看答案
Identify the situations in which you use the alert log file in your database to check the detail.（）
多选题查看答案
Where can you add your own PL/SQL code in relation-handling triggers?（）
单选题查看答案
Your test database is running in NOARCHIVELOG mode. What are the implications of this？（）
单选题查看答案
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？（）
多选题查看答案
Identify the two situations in which you use the alert log file in your database to check the details.（）
多选题查看答案
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）
单选题查看答案
Your end users will need to change values in a REF lookup field in the form application you create. To facilitate choosing a new appropriate value, your provide them with? （）
单选题查看答案
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）
单选题查看答案
Which built-in would you reference in your trigger code to remove a report from the Reports Server queue dynamically?（）
单选题查看答案

语音搜题

拍照搜题

打赏

Oracle认证