Tablespace (PD_PDTS)
- Organization of this page
Function
The Tablespace (PD_PDTS) record stores performance data indicating the status (at a specific point in time) of tablespaces in a database. PFM - Agent for Oracle creates one record for each tablespace in a database. This is a multi-instance record.
For details about the difference between the Tablespace (PD_PDTS) record and the CDB Tablespace (CD_CDTS) record, see the information provided in the CDB Tablespace (PD_CDTS) record.
The following figure shows the relationship between the fields associated with tablespace sizes.
The following fields related to the automatic expansion of tablespaces are valid when Oracle Database 11g R2 or later is monitored. When Oracle Database 11g R1 or earlier is monitored, these fields are either always set to 0 or empty.
No. |
Field |
Value set when Oracle Database 11g R1 or earlier is monitored |
---|---|---|
1 |
Auto Extensible |
Empty |
2 |
Extensible Mbytes |
0 |
3 |
Extensible Mbytes % |
0 |
4 |
Max Extend Free % |
0 |
5 |
Max Extend Free Mbytes |
0 |
6 |
Max Extend Mbytes |
0 |
If the size of automatic expansion is unlimited, the Max Extend Free Mbytes field displays the value based on the theoretical maximum size that can be set for Oracle Database. The values of the other fields are calculated based on the value of the Max Extend Free Mbytes field.
The values set for localtemp_option and undospace_option in the instance information affect only values of the Used Mbytes field and Free Mbytes field. The following figures show effects of the values of localtemp_option and undospace_option.
Default and changeable values
Item |
Default value |
Changeable |
---|---|---|
Collection Interval |
3600 |
Y |
Collection Offset |
30 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
PD_PDTS_TABLESPACE_NAME
Lifetime
From the creation to the deletion of a tablespace
Record size
-
Fixed part: 678 bytes
-
Variable part: 161 bytes
Fields
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
---|---|---|---|---|---|---|
Auto Extensible (AUTO_EXTENSIBLE) |
Indicates whether automatic expansion of the tablespace is enabled when the monitoring target is Oracle Database 11g R2 or later. YES is set if automatic expansion is enabled. NO is set if automatic expansion is disabled. YES is set if automatic expansion is enabled for at least one of the data files which comprise the tablespace. A blank is set if the monitoring target is Oracle Database 11g R1 or earlier. |
-- |
string(3) |
No |
All |
DBA_DATA_FILES.AUTOEXTENSIBLE |
Blocks (BLOCKS) |
Size of tablespace in Oracle blocks |
-- |
ulong |
No |
All |
|
Data Files (DATAFILES) |
Number of data files in use by the tablespace |
-- |
ushort |
No |
All |
|
Extensible Mbytes (EXTENSIBLE_BYTES) |
Size remaining in megabytes for automatic expansion when the monitoring target is Oracle Database 11g R2 or later. 0 is set if automatic expansion is disabled, the maximum size has already been reached, or the monitoring target is Oracle Database 11g R1 or earlier. |
-- |
double |
No |
All |
MAX_BYTES - BYTES |
Extensible Mbytes % (PERCENT_EXTENSIBLE_BYTES) |
Percentage of space remaining for automatic expansion if the monitoring target is Oracle Database 11g R2 or later. 0 is set if automatic expansion is disabled, the maximum size has already been reached, or the monitoring target is Oracle Database 11g R1 or earlier. |
-- |
double |
No |
All |
(EXTENSIBLE_BYTES / MAX_BYTES) * 100 |
Extents (EXTENTS) |
Number of extents |
-- |
ulong |
No |
All |
|
Free % (PERCENT_FREE) |
Percentage ratio of free space |
-- |
double |
No |
All |
|
Free Extents (FREE_EXTENTS) |
Number of free extents. |
-- |
ulong |
No |
All |
|
Free Mbytes (FREE_BYTES) |
Size of free space in megabytes. |
-- |
double |
No |
All |
|
Increase % (PCT_INCREASE) |
Default rate of increase in the extent size |
-- |
short |
No |
All |
DBA_TABLESPACES.PCT_INCREASE |
Initial Extent (INITIAL_EXTENT) |
Default size of the initial extent |
-- |
double |
No |
All |
DBA_TABLESPACES.INITIAL_EXTENT |
Max Extend Free % (MAX_PERCENT_FREE) |
Percentage of the unused size in relation to the maximum automatically expandable size if the monitoring target is Oracle Database 11g R2 or later. The value is the same as the Free % field when automatic expansion is disabled or the maximum size has already been reached. The value is 0 when the monitoring target is Oracle Database 11g R1 or earlier. |
-- |
double |
No |
All |
(MAX_FREE_BYTES / MAX_BYTES) * 100 |
Max Extend Free Mbytes (MAX_FREE_BYTES) |
Size unused when automatic expansion is enabled and the monitoring target is Oracle Database 11g R2 or later. 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. The value is 0 when the monitoring target is Oracle Database 11g R1 or earlier. |
-- |
double |
No |
All |
MAX_BYTES - USED_BYTES |
Max Extend Mbytes (MAX_BYTES) |
Maximum automatic expandable size (in megabytes) when the monitoring target is Oracle Database 11g R2 or later. The value is the same as the Mbytes field when automatic expansion is disabled or the maximum size has already been reached. The value is 0 when the monitoring target is Oracle Database 11g R1 or earlier. |
-- |
double |
No |
All |
|
Max Extents (MAX_EXTENTS) |
Default maximum number of extents |
-- |
ulong |
No |
All |
DBA_TABLESPACES.MAX_EXTENTS |
Mbytes (BYTES) |
Size of the tablespace in megabytes #4 |
-- |
double |
No |
All |
|
Min Extents (MIN_EXTENTS) |
Default minimum number of extents |
-- |
long |
No |
All |
DBA_TABLESPACES.MIN_EXTENTS |
Next Extent (NEXT_EXTENT) |
Default size of the incremental extent |
-- |
double |
No |
All |
DBA_TABLESPACES.NEXT_EXTENT |
Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record |
-- |
time_t |
No |
All |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record name (always PDTS) |
-- |
string(4) |
No |
All |
Agent Collector |
Segments (SEGMENTS) |
Number of segments. Always 1 for locally managed temporary tablespaces when the value of localtemp_option is Y. |
-- |
ulong |
No |
All |
|
Start Time (START_TIME) |
Collection start time for the performance data stored in the record |
-- |
Time_t |
No |
All |
Agent Collector |
Status (STATUS) |
Tablespace status. Valid values are INVALID (tablespace was deleted), OFFLINE, and ONLINE. |
-- |
string(9) |
No |
All |
DBA_TABLESPACES STATUS |
Tablespace Name (TABLESPACE_NAME) |
Tablespace name |
-- |
string(30) |
No |
All |
DBA_TABLESPACES.TABLESPACE_NAME |
Used Mbytes (USED_BYTES) |
Size of used area in megabytes. #4 |
-- |
double |
No |
All |
|