單項(xiàng)選擇題

You are maintaining an OLTP database in Oracle10g. You set the value of the LOG_ARCHIVE_TRACE parameter to zero. What is the impact of this setting？（）

A. The trace files will be disabled only for a specific session.
B. Tracing will be disabled for a client identifier.
C. Tracing will be disabled only for the ARCn process.
D. The SQL Trace facility will be disabled for the instance.

你可能感興趣的試題

單項(xiàng)選擇題

You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process？（）

A. Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.
B. Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.
C. Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.
D. Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.

單項(xiàng)選擇題

You have created a locally managed tablespace by issuing the following command：
CREATE TABLESPACE data1
DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE
UNLIMITED；
For the DATA1 tablespace， you have set the warning level alert limit to 70 percent. In which situation will a warning level alert be generated？（）

A. when 700 KB is used
B. when 700 KB is left as free space
C. when 7MB is used
D. when 7MB is left as free space
E. no alert will be generated because an autoextensible datafile is included in the tablespace

You are maintaining an OLTP database in Oracle10g. You set the value of the LOG_ARCHIVE_TRACE parameter to zero. What is the impact of this setting？ （）

你可能感興趣的試題

You are maintaining an OLTP database in Oracle10g. You set the value of the LOG_ARCHIVE_TRACE parameter to zero. What is the impact of this setting？（）