Activity within Instance/Cluster tab
The Activity within Instance tab contains the following sections, which display information about the pluggable database selected in the Pluggable Databases List table:
The Storage drilldown comprises the panels described in the following topics:
Tablespaces and Datafiles Panel
The Tablespaces and Datafiles panel comprises the sections described in the following topics:
The Tablespaces page displays the database individual tablespace information, sorted by either percent of space usage or size.
The Tablespaces page contains the following components:
The Top 10 Tablespaces bar chart displays the tablespaces that have the highest used value, sorted by:
The Tablespaces Summary table shows the status for all of the database tablespaces.
To view details on a specific tablespace, click the tablespace.
The Datafiles grid displays a list, sorted by usage, of all datafiles used by the database.
The Tablespace-specific page charts used and free space, as well as the fragmentation level of the tablespace (to determine how much space can yet be utilized). The datafiles that make up the individual tablespace appear on the bottom pane of the dashboard.
This page comprises the following sections:
The tablespace properties are provided using the following panes:
The tablespace details are provided using the following panes:
This table provides the following information for tablespace metrics.
The individual Datafile properties panel displays general properties of the selected datafile, as well as a representation of the used and free space that make up the specific datafile.
The Oracle database datafile-specific panel comprises the sections listed below.
Details are provided for:
Use the Fragmentation section to view the file fragmentation status of used and free extents, using a fragmentation analysis triggered by clicking Analyze Fragmentation.
Redo Logs Panel
The Redo Logs panel, which displays details regarding all redo logs, either for the Oracle instance or for all nodes of an Oracle RAC, comprises the following sections:
The redo log records all changes made in datafiles.