Page History
...
- Overview
- RAC Database
- Dictionary
- Storage
About the overview of a tablespace
The Overview, in the Objects tab, displays general tablespace information and a stacked overtime graph that illustrates the physical reads and physical writes to the tablespace.
...
Table 6-25 Structure of general information for a tablespace
Item Description
...
| Item | Description |
|---|---|
| Status | Displays the status of the tablespace—online, or offline. |
| Datafiles |
...
| Displays the number of datafiles supporting the tablespace. |
| Contents |
...
| Indicates whether the tablespace is Temporary or Permanent. |
| Logging |
...
| Indicates whether the Tablespace has logging enabled. |
| Extent |
...
| Management | Indicates whether the tablespace is locally managed or dictionary managed. |
| Allocation |
...
| Type | Specifies how Oracle manages extents within the Tablespace. Values are System or Uniform. |
| Plugged |
...
| in | Indicates whether a transportable tablespace is available. |
| Block |
...
| Size | Displays the underlying block size of the tablespace. |
Additionally a Physical I/O Operations graph is shown.
About the RAC Database of a tablespace
The RAC Database view, in the Objects tab, compares the tablespace activity of the entire RAC database to the tablespace activity of the selected RAC instance. This view shows aggregated wait states, and load balancing and indicates whether only the specific instance is effected by an event, or whether the entire database is effected by the event.
...
Table 6-26 Information displayed in the RAC Database view for tablespaces
Item Description
...
| Item | Description |
|---|---|
| Database | Displays the logical name of the RAC database. |
| DB |
...
| Name | Displays the Oracle database name. |
| DB |
...
| ID | Displays the Oracle |
...
| DATABASE ID. |
| Instance |
...
| Number | Displays the number of the instance in the RAC database. |
| Instances |
...
| Displays the number of instances that share the same RAC database with the selected instance. |
| Overtime |
...
| Graphs | Displays Database physical I/O operations in the overtime graph. The graph compares the tablespace activity of the entire database to the tablespace activity of the selected instance, over the selected time period |
...
| . |
About the dictionary of a tablespace
The Dictionary view, in the Objects tab, displays the general properties of the tablespace. The following table describes how the information in the Dictionary view is structured.
Table 6-27 Structure of information in the Dictionary view
Item Description
...
| Item | Description |
|---|---|
| Name | Displays the name of the tablespace. |
| Datafiles |
...
| Displays the number of datafiles supporting the tablespace. |
| Status |
...
| Displays the status of the tablespace—online, or offline. |
| Contents |
...
| Indicates whether the tablespace is Temporary or Permanent. |
| Logging |
...
| Indicates whether the tablespace has logging enabled. |
| Extent |
...
| Management | Indicates whether the tablespace is managed locally or by dictionary. |
| Allocation |
...
| Type | Specifies how Oracle manages extents within the Tablespace.Values are System, or Uniform. |
| Plugged |
...
| in | Indicates whether a transportable tablespace is available. |
About storage information related to a tablespace
The Storage view, in the Objects tab, displays storage information related to the tablespace, including used and free space, and extent information.
...