Oracle® Database 2 Day DBA 11g Release 1 (11.1) Part Number B28301-03 |
|
|
View PDF |
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:
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.
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.
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.
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.
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.