RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Database Monitoring
«Prev
Next»
DBA Taks
Database Monitoring
Control File Parameters
Protecting Control Files
Removing Control File
Add Control File
Backingup Control File
Recreating Control Files
Checking Parameter Values
v Parameter Dynamic
Changing DB Parameters
Managing DB Parameters
Managing Redo Log
Protecting redoLog Files
Listing RedoLog Files
Create Redo Log Files
Dropping Redo Log Files
Moving Redo Log Files
Manually Switch Log Files
Managing RedoLog Conclusion
Redolog Files
archivelog-mode
archive-log-destination
naming-archive-log-files
manually-archiving-log-file
archive-log-history
archivelog-mode-conclusion
Manage Tablespace Files
Disk I/O and Redo Contention - Quiz
1.
Why is it important to spread I/O evenly across drives?
Please select
the best answer
.
A.
It results in even wear on the hardware.
B.
It ensures that all drives are used.
C.
It maximizes the total I/O throughput.
D.
It minimizes the total I/O throughput.
2.
From which of the following sources can you obtain information on data file I/O?
Please select
all the correct answers
.
A.
The report generated by
utlbstat/utlestat
B.
The v$datafile dynamic performance view
C.
The v$filestat dynamic performance view
D.
The report generated by the
utlfileio
script
3.
What statistic do you look at to detect redo log contention?
Please select
the best answer
.
A.
Redo buffer allocation retries
B.
Redo buffer contention
C.
Redo buffer log retries
D.
Contention log retry buffers
4.
Which of the following is a possible solution to redo log buffer contention?
Please select
the best answer
.
A.
Increase the value of the
db_block_size
parameter.
B.
Increase the value of the
log_buffers
parameter.
C.
Increase the value of the
shared_pool_size
parameter.
D.
Increase the value of the
db_block_buffers
parameter.