单项选择题
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
A. Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
B. Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
C. Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
D. Increase the value of the SGA_TARGET initialization parameter.
点击查看答案
相关考题
-
单项选择题
YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles？（）
A. ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；
B. ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；
C. ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；
D. ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’； -
单项选择题
YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）
A. V$DATABASE
B. V$FLASHBACK_DATABASE_STAT
C. V$FLASHBACK_DATABASE_LOG
D. V$RECOVERY_FILE_DEST -
单项选择题
WhichbackgroundprocesssequentiallywritesFlashbackDatabasedatafromtheflashbackbuffertotheFlashbackDatabaselogs？（）
A. DBWn
B. RECO
C. RVWR
D. LGWR
