Menu

SAP Table GVD_SGADYNCOMP

Oracle monitoring: Snapshot table for GV$SGA_DYNAMIC_COMPON

The table GVD_SGADYNCOMP (Oracle monitoring: Snapshot table for GV$SGA_DYNAMIC_COMPON) is a standard table in SAP ERP. It belongs to the package STUN.

Technical Information

Table GVD_SGADYNCOMP
Short Text Oracle monitoring: Snapshot table for GV$SGA_DYNAMIC_COMPON
Package STUN
Table Type Transparent Table

Fields for Table GVD_SGADYNCOMP

Field Name Key Description Data Element Type Length Check Table
SNAPSHOT_ID Oracle monitor: snapshot ID ORA_SNAPSHOT_ID NUMC 10 *
INST_ID Oracle monitor: Instance ID ORA_INST_ID DEC 22
COMPONENT Oracle monitoring:COMPONENT:Component name ORA_COMPONENT CHAR 64
CURRENT_SIZE Oracle monitoring:CURRENT_SIZE:Current value of the paramete ORA_CURRENT_SIZE DEC 22
MIN_SIZE Oracle monitoring:MIN_SIZE:Minimum size of the component ORA_MIN_SIZE DEC 22
MAX_SIZE Oracle monitoring:MAX_SIZE:Maximum size of the component ORA_MAX_SIZE DEC 22
OPER_COUNT Oracle monitoring:OPER_COUNT:Number of ops. since startup ORA_OPER_COUNT DEC 22
LAST_OPER_TYPE Oracle monitoring:LAST_OPER_TYPE:Last completed operation ORA_LAST_OPER_TYPE CHAR 6
LAST_OPER_MODE Oracle monitoring:LAST_OPER_MODE:Mode of last completed op. ORA_LAST_OPER_MODE CHAR 6
LAST_OPER_TIME Oracle monitoring:LAST_OPER_TIME:Start time of the last comp ORA_LAST_OPER_TIME TIMS 6
LAST_OPER_DATE Oracle monitoring:LAST_OPER_TIME:Start date of the last comp ORA_LAST_OPER_DATE DATS 8
GRANULE_SIZE Oracle monitoring:GRANULE_SIZE:Granularity of the grow or th ORA_GRANULE_SIZE DEC 22