Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Control file Question

Status
Not open for further replies.

sasa888

Programmer
Oct 15, 2001
131
US
*The control file defines the current state of the physical database. Which 3 dynamic performance views obtain information about the control files?
~V$LOG
~V$SGA
~V$THREAD
~V$VERSION
~V$DATAFILE
~V$PARAMETER

I think it is V$LOG, V$PARAMETER, do you think V$THREAD should be the answer as well? Please help
 
Are your choices limited to the list you gave?

I would choose:
v$parameter
V$CONTROLFILE
V$CONTROLFILE_RECORD_SECTION

Aryeh Keefe
 
Even i go with the above person .

We see control file information only on

V$PARAMETER,
V$CONTROLFILE
V$CONTROLFILE_RECORD_SECTION

I know the above question is from dump question. The answer what they have given is wrong.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top