单项选择题
As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?()
A. CKPT
B. SMON
C. MMON
D. DBWR
相关考题
-
多项选择题
Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks?()
A. Define the POWER option while adding or removing the disks
B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
C. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
D. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES -
多项选择题
You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?()
A. You are backing up to tape and your tape device performs its own compression.
B. You are making image copies, and you have not enabled tablespace compression.
C. You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage. -
单项选择题
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()。
A. identify the segments that you should shrink
B. modify the storage parameters for the tablespace
C. automatically shrink the segments with unused space
D. check the alerts generated for the tablespace that is running low on space
