You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue()
ADisable automatic checkpoint tuning.
BCheck the size of the redo log file size and increase the size if it is small.
CSet the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
DDecrease the number of redo log members if there are more than one redo log members available in eachredo log group.
正确答案
答案解析
相似试题
(单选题)
While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?()
(单选题)
Exhibit, One of the important tables in the USERStablespace was dropped and purged from the recycle bin at 9:00 a.m. You noticed this at 11:00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true?()
(单选题)
You need to rename a data file of a tablespace. How would you perform this?()
(单选题)
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to ()
(单选题)
View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9:00 a.m. You noticed this at 11:00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true?()
(单选题)
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file()
(单选题)
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
(单选题)
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file()
(单选题)
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()