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.
To monitor the tablespace size, the size of the currently allocated space can be monitored. However, if automatic expansion is enabled, the size of the unallocated space can also be monitored. The following figure shows the relationship between the fields associated with tablespace sizes.
|
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 MB 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 MB. 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 MB) 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 |
|