CDB Tablespace(PD_CDTS)
- Organization of this page
Function
The CDB Tablespace (PD_CDTS) record stores performance data indicating the status concerning the size of the tablespaces of all the containers managed by the root container of the CDB at a certain point in time. One record is created per tablespace. This record is a multiple-instance record.
The CDB Tablespace (PD_CDTS) record differs from the Tablespace (PD_PDTS) record in the following respects.
- Range of information collected
-
Record
Oracle Database to be monitored
Range of information collected
CDB Tablespace
(CD_CDTS)
Root container (CDB$ROOT) in a CDB configuration
-
When an Oracle administrative account (sys or system) is used:
Performance data concerning the root container (CDB$ROOT) and all the PDBs managed by it
-
When a common user's account is used:
Performance data concerning the root container (CDB$ROOT)
PDBs in a CDB configuration
Performance data concerning monitored PDBs
Non-CDB configuration
Performance data concerning the monitored Oracle Database
Tablespace
(PD_PDTS)
Root container (CDB$ROOT) in a CDB configuration
Performance data concerning the root container (CDB$ROOT)
PDBs in a CDB configuration
Performance data concerning the monitored PDBs
Non-CDB configuration
Performance data concerning the monitored Oracle Database
-
- Maximum size of automatic expansion
-
Record
Tablespace
Maximum size of automatic expansion
CDB Tablespace
(CD_CDTS)
Permanent tablespace/temporary tablespaces
The maximum size of automatic expansion defined in the tablespace or the free space of the file system, whichever is smaller
UNDO tablespaces
The maximum size of automatic expansion defined in the tablespace
Tablespace
(PD_PDTS)
All tablespaces
The maximum size of automatic expansion defined in the tablespace
The following figure shows the relationship between the fields acquired with the CDB Tablespace (PD_CDTS) record.
When free space of the file system is smaller than the maximum size of automatic expansion defined in the tablespace, the value of the Max Extend Mbytes field is calculated based on the amount of free space. Other fields are calculated based on the value of the Max Extend Mbytes field.
The maximum size of automatic expansion defined in the tablespace is displayed as the value of the Max Extend Mbytes field. If the maximum size is unlimited, the value is displayed based on the theoretical maximum size that can be set with the Oracle Database. Other fields are calculated based on the value of the Max Extend Mbytes field.
The unused size (which is equivalent to setting localtemp_option to Y in instance information) is displayed as the size of a temporary tablespace. The displayed size of the UNDO tablespace varies depending on the specification of undospace_option in instance information. For more details, see the information about the effect of undospace_option provided in the Tablespace (PD_PDTS) record.
- Notes
-
-
The CDB Tablespace (PD_CDTS) record is supported only when Oracle Database 12c R2 or later is monitored. Information cannot be collected when Oracle Database 12c R1 or earlier is monitored.
-
This record can be collected when either a CDB or non-CDB configuration is monitored.
-
If a CDB configuration is monitored, the range of information collected varies depending on whether it is a PDB or the root container (CDB$ROOT) that is going to be monitored.
-
Default and changeable values
Item |
Default value |
Changeable |
---|---|---|
Collection Interval |
3600 |
Y |
Collection Offset |
0 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
ODBC key fields
-
PD_CDTS_CON_ID
-
PD_CDTS_TABLESPACE_NAME
Lifetime
From creation to deletion of a tablespace
Record size
-
Fixed part: 678 bytes
-
Variable part: 145 bytes
Fields
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
---|---|---|---|---|---|---|
Auto Extensible (AUTO_EXTENSIBLE) |
This field indicates whether the automatic expansion of the tablespace is enabled. YES means enabled and NO means disabled. This field is set to YES when automatic expansion is enabled for any one of the data files of which the tablespace is comprised. |
-- |
string(3) |
No |
Oracle 12c R2 or later |
|
Block Size (BLOCK_SIZE) |
Block size of the tablespace |
-- |
ulong |
No |
Oracle 12c R2 or later |
CDB_TABLESPACES.BLOCK_SIZE |
Container ID (CON_ID) |
ID of the container to which the tablespace belongs |
-- |
ushort |
No |
Oracle 12c R2 or later |
CDB_TABLESPACES.CON_ID |
Contents (CONTENTS) |
Contents of the tablespace |
-- |
string(21) |
No |
Oracle 12c R2 or later |
CDB_TABLESPACES.CONTENTS |
Extensible Mbytes (EXTENSIBLE_BYTES) |
The remaining space available for automatic expansion in megabytes. This field is set to 0 when no automatic expansion is performed or when the maximum size is already reached. |
-- |
double |
No |
Oracle 12c R2 or later |
MAX_BYTES - BYTES |
Extensible Mbytes % (PERCENT_EXTENSIBLE_BYTES) |
Percentage ratio of the remaining space available for automatic expansion. This field is set to 0 when no automatic expansion is performed or when the maximum size is already reached. |
-- |
double |
No |
Oracle 12c R2 or later |
(EXTENSIBLE_BYTES / MAX_BYTES) * 100 |
Free % (PERCENT_FREE) |
Percentage ratio of free space |
-- |
double |
No |
Oracle 12c R2 or later |
(FREE_BYTES / BYTES) * 100 |
Free Mbytes (FREE_BYTES) |
Size of free space in megabytes |
-- |
double |
No |
Oracle 12c R2 or later |
|
Max Extend Free % (MAX_PERCENT_FREE) |
Percentage ratio of the unused size in relation to the maximum automatically expandable size. The value is the same as the Free % field when automatic expansion is disabled or the maximum size has already been reached. |
-- |
double |
No |
Oracle 12c R2 or later |
(MAX_FREE_BYTES / MAX_BYTES) * 100 |
Max Extend Free Mbytes (MAX_FREE_BYTES) |
Size unused when automatic expansion is enabled. This size is the total of the unused size and the automatically expandable size in megabytes. The value is the same as the Free Mbytes field when automatic expansion is disabled or the maximum size has already been reached. |
-- |
double |
No |
Oracle 12c R2 or later |
MAX_BYTES - USED_BYTES |
Max Extend Mbytes (MAX_BYTES) |
Maximum automatic expandable size (in megabytes). The value is the same as the Mbytes field when automatic expansion is disabled or the maximum size has already been reached. |
-- |
double |
No |
Oracle 12c R2 or later |
|
Mbytes (BYTES) |
Size of the tablespace in megabytes |
-- |
double |
No |
Oracle 12c R2 or later |
|
Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record |
-- |
time_t |
No |
Oracle 12c R2 or later |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record name (always CDTS) |
-- |
string(4) |
No |
Oracle 12c R2 or later |
Agent Collector |
Start Time (START_TIME) |
Collection start time for the performance data stored in the record |
-- |
time_t |
No |
Oracle 12c R2 or later |
Agent Collector |
Status (STATUS) |
Tablespace status. Valid values are INVALID (tablespace was deleted), OFFLINE, ONLINE, and READ ONLY. |
-- |
string(9) |
No |
Oracle 12c R2 or later |
CDB_TABLESPACES.STATUS |
Tablespace Name (TABLESPACE_NAME) |
Tablespace name |
-- |
string(30) |
No |
Oracle 12c R2 or later |
CDB_TABLESPACES.TABLESPACE_NAME |
Used Mbytes (USED_BYTES) |
Size of used area in megabytes.#4 |
-- |
double |
No |
Oracle 12c R2 or later |
|