1. Home
  2. Resources
  3. SAP Tables
  4. DB02_COLL_PLAN - Oracle monitoring: List of coll. functions for DB02

SAP Table DB02_COLL_PLAN

Oracle monitoring: List of coll. functions for DB02

DB02_COLL_PLAN (Oracle monitoring: List of coll. functions for DB02) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DB02_COLL_PLAN to other SAP tables.

DB02_COLL_PLAN table fields

Field Data element Checktable Datatype Length Decimals
CON_NAME Logical name for a database connection DBCON_NAME ORA_MON_DBCON CHAR 30 0
SMON_ID Oracle monitoring: Submonitor ID DB02_SMON_ID CHAR 6 0
SMON_NAME Oracle monitoring: Submonitor name (DB02 branch) DB02_SMON_NAME CHAR 15 0
FUNCNAME Oracle monitoring: function name DB02_FUNCNAME CHAR 30 0
MONIFILL Oracle monitoring: Monikey filler DB02_FILLER CHAR 12 0
RANK Oracle monitoring: Order of execution DB02_RANK CHAR 1 0
STATUS Oracle monitoring: status of collector function DB02_STATUS CHAR 1 0
A Active
I Inactive
SCH_DATE Oracle monitoring: Schedule days DB02_SCH_DAT CHAR 7 0
SCH_TIME Oracle monitoring: Schedule time DB02_SCH_TIM CHAR 24 0
PROCESS_TYPE Oracle monitoring: process type DB02_PROC_TYP CHAR 2 0
S Snapshot
SS Snapshot based on snapshot
HD Daily history based on snapshot
HW Weekly history based on snapshot
HM Monthly history based on snapshot
SD Snapshot based on daily history
SW Snapshot based on weekly history
SM Snapshot based on monthly history
SOURCE_SMON Oracle monitoring: submonitor ids DB02_SMON_IDS CHAR 30 0
PARAM Oracle monitoring: parameter DB02_PARAM CHAR 16 0

DB02_COLL_PLAN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DB02_COLL_PLAN CON_NAME DB02_COLL_PLAN CON_NAME ORA_MON_DBCON Oracle monitoring: list of external Oracle connections CON_NAME