Data blocks have to be written more frequently by DBWR.
Redo blocks have to be written more frequently by LGWR.
You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records.
You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
第1题:
You can control instance recover performance by setting parameters to define targets for()
第2题:
In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration, the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started?()
第3题:
A、wrote
B、had written
C、write
D、have written
第4题:
Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance?()
第5题:
You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals: SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(’SH’,’SALES’,GRANULARITY=>’GLOBAL’); You need statistics to be collected more quickly. What can you do to achieve this?()
第6题:
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()
第7题:
You are working on the 24X7 database with high transaction volume, to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database?()
第8题:
Which statements are true about checkpointing()
第9题:
Which two statements are true regarding the database in ARCHIVELOG mode?()
第10题:
Which two statements are true about checkpointing()