单项选择题
You receive the following error：
ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit
Identify the reason for receiving the above error message？（）
A. The sort area is very small.
B. There is no more space in the Undo tablespace.
C. The flash recovery area is full.
D. The online redo log file is full.
相关考题
-
多项选择题
Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile？（）
A. DB_CREATE_FILE_DEST
B. DB_RECOVERY_FILE_DEST
C. DB_RECOVERY_FILE_DEST_SIZE
D. DB_ONLINE_LOG_DEST_n -
单项选择题
YouaremaintaininganOLTPdatabaseinOracle10g.YouhaveconfiguredtheFlashRecoveryAreainyourdatabase.TheFlashRecoveryAreaisfullbecauseyouhavesettheretentionpolicytoNONE.Whatwillyoudotoresolvetheproblem？（）
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’；
