Q139. While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck
Q139. While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck.
Which three are true about diagnosing and tuning these problems? (Choose three.)
- A. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, thenboth read and write I/O are likely bottlenecks.
- B. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when usingsynchronous I/O.
- C. If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then writeI/O is a likely bottleneck.
- D. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, thenread I/O is a likely bottleneck.
- E. Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.
- F. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when usingasynchronous I/O/
- G. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.
Xem thêm:
Bài viết cùng chủ đề:
-
Q172. PDB1 and PBD2 are pluggable databases in CDB1 Examine these commands: CDB1 is then restarted Which three are true?
-
Q171. Which two are true about RMAN Multisection backups when a very large data file is divided int four sections?
-
Q170. You must migrate a NON-CDB Oracle 11g Database to a CDB without first performing an upgrade to the NON-CDB User-defined objects are stored in several tablespaces in the NON-CDB
-
Q169. Examine the command for creating pluggable database PDB2 in container database CDB2
-
Q168 After a system crash, an instance restart and an attempted opening of the PDBs result in
-
Q167. Which two are true about automatic block repair?
-
Q166. For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command?
-
Q165. Which two are true about server-generated alerts?
-
Q164. Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?
-
Q163. Which three are true about Recovery Manager (RMAN) in Oracle Database and later releases?
-
Q162. Which three methods can be used for heap table data migration after upgrading a database?
-
Q161. Which three are true about opatchauto?
-
Q160. Which three are true about Automatic Workload Repository (AWR)?
-
Q159. Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB?
-
Q158. Which three are true in Oracle 19c and later releases?
-
Q157. Which two are true about RMAN duplexed backup sets?
