CDB Status (PD_CDCS)
- Organization of this page
Function
The CDB Status (PD_CDCS) record stores performance data related to a PDB built in a CDB, including open mode information and the amount of disk space used at a certain point in time. One record is created per PDB. This record is a multiple-instance record.
- Notes
-
-
The CDB Status (PD_CDCS) record is supported only when Oracle Database 12c R2 or later is monitored in a CDB configuration. This record cannot be collected when Oracle Database 12c R1 or earlier is monitored or when Oracle Database 12c R2 or later is monitored in a non-CDB configuration.
-
When the CDB Status (PD_CDCS) record is to be monitored from the root container, you need to use an Oracle administrative account (sys or system). The CDB Status (PD_CDCS) record cannot be collected if you use a common user's account.
-
The range of information collected varies depending on whether it is PDBs or the root container (CDB$ROOT) that is going to be monitored.
- When monitoring PDBs
![[Figure]](GRAPHICS/ZUENG100.GIF)
Performance data regarding the monitored PDBs
- When all PDBs are monitored from the root container (CDB$ROOT) to which they belong
Performance data regarding all PDBs managed by the root container (CDB$ROOT)
-
If the PDB storage size (MAX_SIZE, MAX_DIAG_SIZE, or MAX_AUDIT_SIZE) is either not set or set to unlimited in the Oracle Database to be monitored, the following fields would always be 0 or 100 and therefore cannot be monitored:
|
Oracle item that is either not set or set to unlimited |
Field name |
Displayed value |
|---|---|---|
|
MAX_SIZE |
Max Size |
Always 0 |
|
Free Size |
Always 0 |
|
|
Free Size % |
Always 100 |
|
|
MAX_DIAG_SIZE |
Max Diagnostics Size |
Always 0 |
|
Free Diagnostics Size |
Always 0 |
|
|
Free Diagnostics Size % |
Alway 100 |
|
|
MAX_AUDIT_SIZE |
Max Audit Size |
Always 0 |
|
Free Audit Size |
Always 0 |
|
|
Free Audit Size % |
Alway 100 |
Default and changeable values
|
Item |
Default Value |
Changeable |
|---|---|---|
|
Collection Interval |
600 |
Y |
|
Collection Offset |
0 |
Y |
|
Log |
No |
Y |
|
LOGIF |
(Blank) |
Y |
ODBC Key Fields
PD_CDCS_CON_ID
Lifetime
From the creation to the deletion of PDB
Record Size
-
Fixed part: 678bytes
-
Variable part: 262bytes
Fields
|
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported Version |
Data Source |
|---|---|---|---|---|---|---|
|
Container ID (CON_ID) |
Container ID of a PDB |
-- |
ushort |
No |
Oracle 12c R2 or later |
V$PDBS.CON_ID |
|
Container UID (CON_UID) |
Unique identifier related to a PDB |
-- |
ulong |
No |
Oracle 12c R2 or later |
V$PDBS.CON_UID |
|
DBID (DBID) |
PDB identifier |
-- |
ulong |
No |
Oracle 12c R2 or later |
V$PDBS.DBID |
|
Name (NAME) |
PDB name |
-- |
string(128) |
No |
Oracle 12c R2 or later |
V$PDBS.NAME |
|
Open Mode (OPEN_MODE) |
Open mode
|
-- |
string(10) |
No |
Oracle 12c R2 or later |
V$PDBS.OPEN_MODE |
|
Restricted (RESTRICTED) |
This field indicates YES or NO depending on whether only users with RESTRICTED SESSION privilege are allowed access. |
-- |
string(3) |
No |
Oracle 12c R2 or later |
V$PDBS.RESTRICTED |
|
Total Size (TOTAL_SIZE) |
Size of the disk space for data and temporary files inside a PDB in megabytes |
-- |
double |
No |
Oracle 12c R2 or later |
V$PDBS.TOTAL_SIZE / (1024 * 1024) |
|
Diagnostics Size (DIAG_SIZE) |
Size of the diagnostic trace generated in a PDB in megabytes |
-- |
double |
No |
Oracle 12c R2 or later |
V$PDBS.DIAGNOSTICS_SIZE / (1024 * 1024) |
|
Audit File Size (AUDIT_SIZE) |
Size of the unified audit file inside a PDB in megabytes |
-- |
double |
No |
Oracle 12c R2 or later |
V$PDBS.AUDIT_FILE_SIZE / (1024 * 1024) |
|
Max Size (MAX_SIZE) |
Size of maximum space available for data and temporary files inside a PDB in megabytes |
-- |
double |
No |
Oracle 12c R2 or later |
V$PDBS.MAX_SIZE / (1024 * 1024) |
|
Max Diagnostics Size (MAX_DIAG_SIZE) |
Size of maximum space available for the diagnostic trace in a PDB in megabytes |
-- |
double |
No |
Oracle 12c R2 or later |
V$PDBS.MAX_DIAGNOSTICS_SIZE / (1024 * 1024) |
|
Max Audit Size (MAX_AUDIT_SIZE) |
Size of the maximum space available for the unified audit file inside a PDB in megabytes |
-- |
double |
No |
Oracle 12c R2 or later |
V$PDBS.MAX_AUDIT_SIZE / (1024 * 1024) |
|
Free Size (TOTAL_FREE) |
Size of free space available for data and temporary files inside a PDB in megabytes. When MAX_SIZE is 0, this field is always 0. |
-- |
double |
No |
Oracle 12c R2 or later |
MAX_SIZE - TOTAL_SIZE |
|
Free Diagnostics Size (DIAG_FREE) |
Size of free space available for the diagnostic trace in a PDB in megabytes. When MAX_DIAG_SIZE is 0, this field is always 0. |
-- |
double |
No |
Oracle 12c R2 or later |
MAX_DIAG_SIZE - DIAG_SIZE |
|
Free Audit Size (AUDIT_FREE) |
Size of free space available for the unified audit file inside a PDB in megabytes. When MAX_AUDIT_SIZE is 0, this field is always 0. |
-- |
double |
No |
Oracle 12c R2 or later |
MAX_AUDIT_SIZE - AUDIT_SIZE |
|
Free Size % (PERC_FREE) |
Percentage ratio of free space available for data and temporary files inside a PDB. When MAX_SIZE is 0, this field is always 100. |
-- |
double |
No |
Oracle 12c R2 or later |
((MAX_SIZE - TOTAL_SIZE) / MAX_SIZE) * 100 |
|
Free Diagnostics Size % (PERC_FREE_DIAG) |
Percentage ratio of free space available for the diagnostic trace in a PDB. When MAX_DIAG_SIZE is 0, this field is always 100. |
-- |
double |
No |
Oracle 12c R2 or later |
((MAX_DIAG_SIZE - DIAG_SIZE) / MAX_DIAG_SIZE) * 100 |
|
Free Audit Size % (PERC_FREE_AUDIT) |
Percentage ratio of free space available for the unified audit file inside a PDB. When MAX_AUDIT_SIZE is 0, this field is always 100. |
-- |
double |
No |
Oracle 12c R2 or later |
((MAX_AUDIT_SIZE - AUDIT_SIZE) / MAX_AUDIT_SIZE) * 100 |
|
Application Root (APPLICATION_ROOT) |
This field indicates YES or NO depending on whether the PDB is an application root. |
-- |
string(3) |
No |
Oracle 12c R2 or later |
V$PDBS.APPLICATION_ROOT |
|
Applicaton PDB (APPLICATION_PDB) |
This field indicates YES or NO depending on whether the PDB is an application PDB. |
-- |
string(3) |
No |
Oracle 12c R2 or later |
V$PDBS.APPLICATION_PDB |
|
Application Seed (APPLICATION_SEED) |
This field indicates YES or NO depending on whether the PDB is an application seed. |
-- |
string(3) |
No |
Oracle 12c R2 or later |
V$PDBS.APPLICATION_SEED |
|
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 CDCS) |
-- |
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 |