多项选择题

A. LOG_BUFFERB. DB_CACHE_SIZEC. JAVA_POOL_SIZED. LARGE_……

The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）

A. LOG_BUFFER
B. DB_CACHE_SIZE
C. JAVA_POOL_SIZE
D. LARGE_POOL_SIZE
E. SHARED_POOL_SIZE
F. STREAMS_POOL_SIZE

<上一题目录下一题>

热门试题

单项选择题The warning level threshold value for a tablespace， DATA1， is set to 60% and the critical level threshold value is set to 80%. The tablespace， DATA1， is infrequently used and is not a part of the production environment. You issued the following command： SQL> EXECUTE DBMS_SERVER_ALERT.SET_THRESHOLD （dbms_server_alert.tablespace_pct_full， dbms_server_alert.operator_ge，80， dbms_server_alert.operator_ge，90， 1，1，NULL， dbms_server_alert.object_type_tablespace，’DATA’）； What will be the result of the command？（）

A. The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.
B. The total numbers of alerts that you receive every day will be reduced.
C. The total number of alerts that you receive every day will be increased.
D. No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.

单项选择题AjuniorlevelDatabaseAdministratorerroneouslydeletedthedatabasealertlogwhileuserswereaccessingthedatabase.Whichactionshouldyoutaketorecoverthealertlog？（）

A. Do nothing.
B. Restart the database.
C. Perform recovery on the database.
D. Restore the alert log from the last backup.

单项选择题YouaremaintainingthePRODdatabaseofNetFxCorporation.YousetthevalueoftheSQL_TRACEparametertoTRUE.Whatwillbetheimpactofthissetting？（）

A. The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.
B. The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.
C. The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.
D. The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.

单项选择题YouaremaintaininganOLTPdatabaseinOracle10g.YousetthevalueoftheLOG_ARCHIVE_TRACEparametertozero.Whatistheimpactofthissetting？（）

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.

单项选择题YouaremaintaininganOLTPdatabaseinOracle10g.Youfindthatthedatabaseisgeneratingalargenumberoftracefiles.YoudecidetodisablethetracefilesgeneratedbytheARCnbackgroundprocess.WhichactionwillenableyoutodisablethetracefilesgeneratedbytheARCnbackgroundprocess？（）

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.