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.

+ | -