External Performance   «Prev  Next»
 

Oracle Hot Disks - Quiz Results

Each question is worth one point. Select the best answer or answers for each question.

1. Which of the following are true about hot disks?
Please select all the correct answers.
  A. They have a disproportional amount of I/O activity.
  B. They always create bottlenecks for I/O.
  C. They can only be remedied by striping.
  D. They are easy to detect with iostat.

2. How do you discover which Oracle data files are making a disk hot?
Please select the best answer.
  A. Execute iostat
  B. Execute bstat-estat
  C. Execute Oracle Enterprise manager
  D. Execute Oracle auditing

3. Which of the following are steps in striping an Oracle table?
Please select all the correct answers.
  A. Run CTAS to copy the table into the new tablespace
  B. Create a new tablespace for the table with data files on separate disks
  C. Adjust PCTFREE to spread the data across the data blocks
  D. Run iostat to get striping sizes