Multiple choice technology databases

The control file defines the current state of the physical database. Which dynamic performance views obtain information from the control file?

  1. V$LOG
  2. V$THREAD
  3. V$DATAFILE

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Dynamic performance views like V$LOG, V$THREAD, and V$DATAFILE obtain their structural database details directly from the control file. Since all these views rely on the database's physical layout and current states registered in the control file, 'All of the above' is the correct answer.

Keep practicing — related questions