ORA_DB02_SPOV
Data Description
The ORA_DB02_SPOV event is used in SAP to provide an overview of the space in your Oracle database. It uses a collector job to periodically retrieve data from the cluster table MONI.
Potential Use Cases
This event could be used in the following scenarios:
Alert if your database is running our of storage.
Trend storage use over time.
Identify opportunities to reduce tablespace size.
Understand the overall storage environment of the Oracle database.
Splunk Event
The event will look like this in Splunk:
SAP Navigation
Log into the managed system and execute the dbacockpit transaction code. Then expand the Space menu option on the left side of the screen, and then double-click the Space Overview option. The data displayed will match the data that is extracted and sent to Splunk.
Field Mapping
Field | Description | Unit of Measure |
|---|---|---|
CURRENT_TIMESTAMP | The date time stamp when the information was collected | YYYYMMDDHHMMSS |
DB_ANALYD | Database Last analysis date. | YYYYMMDD |
DB_ANALYT | Database Last analysis time. | HHMMSS |
DB_CREATDAT | Database creation date. | YYYYMMDD |
DB_FREE | Database free space size. | Number |
DB_NAME | Database name. | String |
DB_PER_USED | Database usage percentage. | Number (Percent) |
DB_SIZE | Database size.(generic for Total, Free) | Number |
DB_SYSDATE | Database current date. | YYYYMMDD |
DB_SYSTEM | Oracle Monitoring: DB System | String |
DB_SYSTIME | Database Current time. | HHMMSS |
DB_TOT_FREE | Database total free size | Number |
DB_TOT_PER_USED | Database total percentage usage | Number (Percent) |
DB_TOT_SIZE | Database total size | Number |
EVENT_SUBTYPE | String | |
EVENT_TYPE | ORA_DB02_SPOV | String |
SE_IND_NUM | Number of indexes. | Number |
SE_IND_NUM_COMP | Number of indexes that are compressed. | Number |
SE_IND_NUM_CRIT | Number of indexes that are critical. | Number |
SE_IND_NUM_M100 | Number of indexes that have more than 100 extents. | Number |
SE_IND_NUM_M_DB | Number of indexes that are missing in DB. | Number |
SE_IND_NUM_M_R3 | Number of indexes that are missing in ABAP Dictionary. | Number |
SE_IND_NUM_NOLOG | Number of indexes that have no-logging. | Number |
SE_IND_SIZE | Size of indexes in MB. | Number |
SE_OTH_NUM | Number of other segments. | Number |
SE_OTH_NUM_COMP | Number of other segments that are compressed. | Number |
SE_OTH_NUM_CRIT | Number of other segments that are critical. | Number |
SE_OTH_NUM_M100 | Number of other segments that have more than 100 extents. | Number |
SE_OTH_NUM_M_DB | Number of other segments that are missing in DB. | Number |
SE_OTH_NUM_M_R3 | Number of other segments that are missing in ABAP Dictionary | Number |
SE_OTH_NUM_NOLOG | Number of other objects that have no-logging. | Number |
SE_OTH_SIZE | Size of other segments in MB. | Number |
SE_TAB_NUM | Number of tables. | Number |
SE_TAB_NUM_COMP | Number of tables that are compressed. | Number |
SE_TAB_NUM_CRIT | Number of tables that are critical. | Number |
SE_TAB_NUM_M100 | Number of tables that have more than 100 extents. | Number |
SE_TAB_NUM_M_DB | Number of tables that are missing in DB. | Number |
SE_TAB_NUM_M_R3 | Number of tables that are missing in ABAP Dictionary. | Number |
SE_TAB_NUM_NOLOG | Number of tables that have no-logging. | Number |
SE_TAB_SIZE | Size of tables in MB. | Number |
SE_TOT_NUM | Number of All segments. | Number |
SE_TOT_NUM_COMP | Number of all segments that are compressed. | Number |
SE_TOT_NUM_CRIT | Number of all segments that are critical. | Number |
SE_TOT_NUM_M100 | Number of all segments that have more than 100 extents. | Number |
SE_TOT_NUM_M_DB | Number of all segments that are missing in DB. | Number |
SE_TOT_NUM_M_R3 | Number of all segments that are missing in ABAP Dictionary. | Number |
SE_TOT_NUM_NOLOG | Number of all objects that have no-logging. | Number |
SE_TOT_SIZE | Size of other segments in MB. | Number |
TS_MAX_SIZE | Maximum tablespace size. | Number |
TS_MAX_SIZE_WHO | Biggest tablespace name. | String |
TS_MIN_FREE | Minimum free space not used by a corresponding tablespace. | Number |
TS_MIN_FREE_WHO | The tablespace that has the minimum free space . | String |
TS_NUM | Number of tablespaces. | Number |
US_MAX_SEG | Maximum number of segments used. | Number |
US_MAX_SEG_WHO | User that is using the maximum nbr of segments | String |
US_MAX_SIZE | Maximum size used by the corresponding user. | Number |
US_MAX_SIZE_WHO | User that is using the maximum of it. | String |
US_NUM | Number of users. | Number |
UTCDIFF | The UTC OFFSSET in HHMMSS that the data was collected in | HHMMSS |
UTCSIGN | The UTC positive or negative OFFSET indicator. Positive (+) means add UTCDIFF to find the time zone of the data, negative (-) means subtract the UTCDIFF to find the time zone adjusted date time the data was collected in. | + | - |