Monday, April 13, 2015

Displaying Control File Information:

Displaying Control File Information:

The following views display information about control files:


1.V$DATABASE
:
Displays database information from the control file.

2.V$CONTROLFILE:
Lists the names of control files.

3.V$CONTROLFILE_RECORD_SECTION:
Displays information about control file record sections.

4.V$PARAMETER:
Can be used to display the names of control files as specified in the CONTROL_FILES initialization parameter.

No comments:

Post a Comment

How to create user in MY SQL

Create  a new MySQL user Account mysql > CREATE USER ' newuser '@'localhost' IDENTIFIED BY ' password '...