This section provides instructions about viewing information about the various database storage structures with Oracle Enterprise Manager Database Control (Database Control). It contains the following topics:
See Also:
Viewing Control File Information
You use Database Control to view location and status information about control files.
To view control file information:
-
Go to the Database Home page.
-
At the top of the page, click the Server link to view the Server subpage.
-
In the Storage section, click Control Files.
The Control Files page appears, showing the General subpage. This page shows whether or not your database has a multiplexed control file. The Advanced and Record Section subpages give you more detailed information about your control files.
For more information about a page, at any time, click Help.
Viewing Online Redo Log File Information
You use Database Control to view status and multiplexing information about online redo log files.
To view redo log file information:
-
Go to the Database Home page.
-
At the top of the page, click the Server link to view the Server subpage.
-
In the Storage section, click Redo Log Groups.
The Redo Log Groups page appears. This page shows the attributes of the redo log groups for your database.
When a redo log group contains only one member, it is not multiplexed. Note the Status attribute for the redo log groups. The group with status Current is the one currently being written to disk by the log writer.
For more information about a page, at any time, click Help.
-
(Optional) In the Group column, click a group number to view information about redo log group members.
Viewing Archive Log Information
You use Database Control to view status information about archived redo log files.
Note:
Archived redo log files do not exist until you set the database inARCHIVELOG mode.To view archive log information:
-
Go to the Database Home page.
-
At the top of the page, click the Server link to view the Server subpage.
-
In the Storage section, click Archive Logs.
The Archive Logs page appears.
For more information about a page, at any time, click Help.
Viewing Datafile Information
You use Database Control to view status and location information about datafiles.
To view datafile information:
-
Go to the Database Home page.
-
At the top of the page, click the Server link to view the Server subpage.
-
In the Storage section, click Datafiles.
The Datafiles page appears.
For more information about a page, at any time, click Help.
-
(Optional) Select a datafile, and then click View to display more attributes for the datafile. You can also click the name of a tablespace in the Tablespace column to display the attributes of the tablespace associated with the datafile.
Viewing Tablespace Information
You use Database Control to view configuration, size, and status information about tablespaces.
To view tablespace information:
-
Go to the Database Home page.
-
At the top of the page, click the Server link to view the Server subpage.
-
In the Storage section, click Tablespaces.
The Tablespaces page appears.
For more information about a page, at any time, click Help.
: 科技
