单项选择题
You can control instance recover performance by setting parameters to define targets for（）
A.The size of the redo buffer in SGA.
B.The instance that will perform recovery in Real Application Cluster database.
C.The number of blocks to be read during instance recovery, or the time needed to complete instance recovery.
D.The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.
相关考题
-
单项选择题
TheEMPLOYEEStablehassixindexesandDMLoperationsareslow.WhichcommandbeginsmonitoringtheEMPLOYEE_IDX_FKindextodeterminewhetherithasbeenusedbyanexecutionplan？（）
A.ALTER TABLE employees monitor index employee_idx_fk;
B.ALTER INDEX employee_idx_fk monitoring on;
C.ALTER TABLE employees monitor all indexes;
D.ALTER INDEX employee_idx_fk monitoring usage; -
多项选择题
Usingabitmapstructuretomanagedatabaseobjectspacehasseveralbenefitsoverusingfreeliststructures.Whichthreearebenefitsofmanagingspaceusingautomatic-segment-spacemanagedobjects？（）
A.It readily responds to dynamic changes for concurrent access.
B.It improves performance and space utilization in a multiple-instance environment.
C.It requires fewer space related options then freelist managed structures.
D.It improves performance for SYSTEM tablespaces where a high degree of concurrency is required. -
单项选择题
WhendoesOracle9iflaganindexasbeingusedintheV$OBJECT_USAGEview？（）
A.During a query’s parse time only.
B.During a query’s execution time only.
C.During any kind of DML statement execution.
D.During the execution of an INSERT statement only.
