| SAVEDATE |
✔ |
Date of Data Retrieval from dba Tables |
|
DATS |
8 |
|
| SAVETIME |
✔ |
Time of Data Retrieval from dba Table |
|
TIMS |
6 |
|
| TSNAME |
✔ |
Tablespace Name |
|
CHAR |
30 |
|
| INIT_EXT |
|
Default Initial Extent Size |
|
DEC |
10 |
|
| NEXT_EXT |
|
Next Extent Size |
|
DEC |
10 |
|
| MIN_EXT |
|
Default Minimum Number of Extents |
|
DEC |
10 |
|
| MAX_EXT |
|
Default Maximum Number of Extents |
|
DEC |
10 |
|
| STATUS |
|
Tablespace Status (ONLINE, OFFLINE, or READ ONLY) |
|
CHAR |
10 |
|
| EXT_MGMT |
|
Extent Management Tracking (DICTIONARY or LOCAL) |
|
CHAR |
10 |
|
| ALLOC_TYPE |
|
Type of Extent Allocation in Effect for this Tablespace |
|
CHAR |
10 |
|
| TOT_EXTS |
|
Total Number of Free Extents in Tablespace |
|
DEC |
12 |
|
| COALES_EXT |
|
Total Number of Coalesced Free Extents in Tablespace |
|
DEC |
12 |
|
| P_COAL_EXT |
|
Percentage of Coalesced Free Extents in Tablespace |
|
DEC |
10 |
|
| TOT_BYTES |
|
Total Number of Free Bytes in Tablespace |
|
DEC |
12 |
|
| COAL_BYTES |
|
Total Number of Coalesced Free Bytes in Tablespace |
|
DEC |
12 |
|
| TOT_BLOCKS |
|
Total Number of Free Oracle Blocks in Tablespace |
|
DEC |
12 |
|
| COAL_BLKS |
|
Total Number of Coalesced Free Oracle Blocks in Tablespace |
|
DEC |
12 |
|
| P_COAL_BLK |
|
Percentage of Coalesced Free Oracle Blocks in Tablespace |
|
DEC |
10 |
|