Menu

SAP Table ORATSPINFO

Tablespace Information

The table ORATSPINFO (Tablespace Information) is a standard table in SAP ERP. It belongs to the package S_DBMON_ORA.

Technical Information

Table ORATSPINFO
Short Text Tablespace Information
Package S_DBMON_ORA
Table Type Transparent Table

Fields for Table ORATSPINFO

Field Name Key Description Data Element Type Length Check Table
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