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:
The Tablespaces and Datafiles panel comprises the sections described in the following topics:
• |
Tablespaces page — displayed by default. When switching to other sections of this panel, accessible by clicking the link View all tablespaces on the upper right side of the screen. For details, see Tablespaces page . |
• |
Datafiles grid — accessed by clicking the link View all datafiles on the upper right side of the screen. For details, see Datafiles Grid . |
• |
• |
Clicking the name of the requested datafile from the Tablespace Details > Datafiles pane, under the tablespace-specific page (see Tablespace Details Section ). |
• |
Clicking the name of the requested datafile from the Datafiles grid. |
The Tablespaces page contains the following components:
• |
• |
• |
Use the Show top options to select which metric the vertical axis displays for the top 10 tablespaces:
| |||||
The percentage of the database tablespace pages currently being utilized. | |||||
The bar chart representation of the utilized tablespaces. Click a specific tablespace representation to drill down further to the Tablespace-specific page. For details, see Tablespace-specific page . |
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 file name of the datafile, including the full directory path. Click the file name to drill down further to the Datafile-specific panel. For details, see Datafile-specific Page . | |
The name of the tablespace that contains the selected datafile. | |
The current used megabytes associated to the datafile, as a percentage of datafile’s allocated size. | |
This page comprises the following sections:
The tablespace properties are provided using the following panes:
The number of warning, critical, and fatal alarms for the selected tablespace. |
Indicates the current status of the tablespace — Online or Offline. | |
Indicates the method used for managing extents in this tablespace: | |
The type of extent allocation to be used for this tablespace. | |
Indicates if a redo log is to be generated for the tablespace. The possible values are Logging and No. | |
Indicates the status of default table compression; either Enabled or Disabled. | |
Indicates if unexpired undo blocks are retained in the tablespace. | |
The size of the memory block used by this tablespace in megabytes. | |
Indicates whether the tablespace data is encrypted (Yes) or not (No). |
Total amount of available memory for this tablespace, plotted over time. | |
Amount of available memory that is used for this tablespace, plotted over time. |
The tablespace details are provided using the following panes:
The datafile name, including the full directory path. Click the datafile name to drill down further to the Datafile-specific panel. For details, see Datafile-specific Page . | |
Available space on the file system as a percentage of file system size, rounded up to one decimal. | |
The number of warning, critical, and fatal alarms for this Oracle database tablespace. |
This table provides the following information for tablespace metrics.
The percentage of used space for non auto-extensible files in the selected tablespace. | |
The size of the smallest fragment in the selected tablespace. | |
The size of the largest fragment in the selected tablespace. | |
The total amount of space used by the recycle bin within the allocated free space of the tablespace. | |
The percentage of recycle bin space which occupies the allocated free space of the tablespace. | |
The Oracle database datafile-specific panel comprises the sections listed below.
The number of warning, critical, and fatal alarms for the selected datafile. |
The name of the datafile, including the full directory path. | |||
In multitenant architectures, the name of the pluggable database. | |||
Indicates whether the datafile is available:
| |||
Use the Fragmentation section to view the file fragmentation status of used and free extents, using a fragmentation analysis triggered by clicking Analyze Fragmentation.
This bar displays the file fragmentation snapshot of used and free extents. | |
• |
The redo log records all changes made in datafiles.
The log files can have one of the following status values:
| |||
A system-allocated number (SCN), which identifies the first time a change was recorded in this log. | |||
The number of warning, critical, and fatal alarms for the selected Oracle database tablespace. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center