This preview shows page 1. Sign up to view the full content.
Unformatted text preview: E command forces a log switch and causes a checkpoint to
A: There is no ALTER SYSTEM CHECKPOINT command in Oracle.
C: There is no ALTER DATABASE CHECKPOINT command in Oracle.
D: There is no ALTER DATABASE SWITCH LOGFILE command in Oracle.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 328-330
Chapter 7: Managing the Physical Database Structure
Which two dynamic performance views could you query to display the number of online
redo log groups and the current log groups? (Choose two)
Answer: A, B
Answers A and B are correct. V$LOG view gives comprehensive information about the current
status of the redo log. V$THREAD view provides information about the number of online redo
C: V$SESSION dictionary view contains information about every session currently connected to
D: There is no V$ARCHIVE view in Oracle.
E: V$INSTANCE shows inform...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09