You are maintaining your OLTP database in Oracle10g. While observing the performance of the database, you find that the log switch occurs more than once for every 20 minutes, affecting the database performance. Which factor is responsible for frequent log switches?()
Athe value of the UNDO_RETENTION initialization parameter
Bthe value of the optimal redo log file size provided by the Redo Logfile Size Advisor
Cthe online redo log files size
Dthe number of redo log members in a group
正确答案
答案解析
相似试题
(单选题)
You are configuring for Oracle Shared Server. Which service is required? ()
(多选题)
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()
(单选题)
How are messages displayed when you use the SRW.MESSAGE packaged procedure? ()
(单选题)
In which situation are you NOT required to perform an incomplete recovery?()
(单选题)
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
(单选题)
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
(单选题)
You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()
(多选题)
You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? ()
(单选题)
Which command would you use to determine what database backups are currently available for restore?()
(单选题)
Which command would you use to determine what database backups are currently available for restore?()