ORATSPINFO - Tablespace Information

Tablespace Information information is stored in SAP table ORATSPINFO.
 It is part of development package S_DBMON_ORA in software component BC-CCM-MON-ORA. This development package consists of objects that can be grouped under "Database Monitor for Oracle".

Fields for table ORATSPINFO

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
SAVEDATEDate of Data Retrieval from dba TablesXDATS8
SAVETIMETime of Data Retrieval from dba TableXTIMS6
TSNAMETablespace NameXCHAR30
INIT_EXTDefault Initial Extent SizeDEC6
NEXT_EXTNext Extent SizeDEC6
MIN_EXTDefault Minimum Number of ExtentsDEC6
MAX_EXTDefault Maximum Number of ExtentsDEC6
STATUSTablespace Status (ONLINE, OFFLINE, or READ ONLY)CHAR10
EXT_MGMTExtent Management Tracking (DICTIONARY or LOCAL)CHAR10
ALLOC_TYPEType of Extent Allocation in Effect for this TablespaceCHAR10
TOT_EXTSTotal Number of Free Extents in TablespaceDEC7
COALES_EXTTotal Number of Coalesced Free Extents in TablespaceDEC7
P_COAL_EXTPercentage of Coalesced Free Extents in TablespaceDEC6
TOT_BYTESTotal Number of Free Bytes in TablespaceDEC7
COAL_BYTESTotal Number of Coalesced Free Bytes in TablespaceDEC7
TOT_BLOCKSTotal Number of Free Oracle Blocks in TablespaceDEC7
COAL_BLKSTotal Number of Coalesced Free Oracle Blocks in TablespaceDEC7
P_COAL_BLKPercentage of Coalesced Free Oracle Blocks in TablespaceDEC6
Privacy Policy