SAP GVD_UNDOSTAT table - Oracle monitoring: copy of GV$UNDOSTAT details in SAP


SAP GVD_UNDOSTAT table summary

Object Name: GVD_UNDOSTAT
Dictionary Type: Transparent table
Description: Oracle monitoring: copy of GV$UNDOSTAT


Field list for GVD_UNDOSTAT table on an S/4 SAP system

Details
GVD_UNDOSTAT-SNAPSHOT_ID table field - Oracle monitor: snapshot ID

Description: Oracle monitor: snapshot ID
Field Name: SNAPSHOT_ID
Data Element: ORA_SNAPSHOT_ID
Data Type: NUMC
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: ORA_SNAPSHOT_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPSHOT_ID

GVD_UNDOSTAT-INST_ID table field - Oracle monitor: Instance ID

Description: Oracle monitor: Instance ID
Field Name: INST_ID
Data Element: ORA_INST_ID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_INST_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INST_ID

GVD_UNDOSTAT-BEGIN_TIME_D table field - Oracle monitoring: Begin of time interval (date field)

Description: Oracle monitoring: Begin of time interval (date field)
Field Name: BEGIN_TIME_D
Data Element: ORA_BEGIN_TIME_D
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BEGIN_TIME_D

GVD_UNDOSTAT-BEGIN_TIME_T table field - Oracle monitoring: Begin of time interval (time field)

Description: Oracle monitoring: Begin of time interval (time field)
Field Name: BEGIN_TIME_T
Data Element: ORA_BEGIN_TIME_T
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: ORA_TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BEGIN_TIME_T

GVD_UNDOSTAT-END_TIME_D table field - Oracle monitoring: End of time interval (date field)

Description: Oracle monitoring: End of time interval (date field)
Field Name: END_TIME_D
Data Element: ORA_END_TIME_D
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field END_TIME_D

GVD_UNDOSTAT-END_TIME_T table field - Oracle monitoring: End of time interval (time field)

Description: Oracle monitoring: End of time interval (time field)
Field Name: END_TIME_T
Data Element: ORA_END_TIME_T
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: ORA_TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field END_TIME_T

GVD_UNDOSTAT-UNDOTSN table field - Oracle monitoring: last active undo tablespace

Description: Oracle monitoring: last active undo tablespace
Field Name: UNDOTSN
Data Element: ORA_UNDOTSN
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNDOTSN

GVD_UNDOSTAT-UNDOBLKS table field - Oracle monitoring: total number of undo blocks

Description: Oracle monitoring: total number of undo blocks
Field Name: UNDOBLKS
Data Element: ORA_UNDOBLKS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNDOBLKS

GVD_UNDOSTAT-TXNCOUNT table field - Oracle monitoring: total number of transactions

Description: Oracle monitoring: total number of transactions
Field Name: TXNCOUNT
Data Element: ORA_TXNCOUNT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TXNCOUNT

GVD_UNDOSTAT-MAXQUERYLEN table field - Oracle monitoring: length of the longest query

Description: Oracle monitoring: length of the longest query
Field Name: MAXQUERYLEN
Data Element: ORA_MAXQUERYLEN
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXQUERYLEN

GVD_UNDOSTAT-MAXCONCURRENCY table field - Oracle monitoring: highest nr of TAs executed concurrently

Description: Oracle monitoring: highest nr of TAs executed concurrently
Field Name: MAXCONCURRENCY
Data Element: ORA_MAXCONCURRENCY
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXCONCURRENCY

GVD_UNDOSTAT-UNXPSTEALCNT table field - Oracle monitoring: attempts to obtain undo space

Description: Oracle monitoring: attempts to obtain undo space
Field Name: UNXPSTEALCNT
Data Element: ORA_UNXPSTEALCNT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNXPSTEALCNT

GVD_UNDOSTAT-UNXPBLKRELCNT table field - Oracle monitoring: unexpired undo blocks removed

Description: Oracle monitoring: unexpired undo blocks removed
Field Name: UNXPBLKRELCNT
Data Element: ORA_UNXPBLKRELCNT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNXPBLKRELCNT

GVD_UNDOSTAT-UNXPBLKREUCNT table field - Oracle monitoring: unexpired undo blocks reused

Description: Oracle monitoring: unexpired undo blocks reused
Field Name: UNXPBLKREUCNT
Data Element: ORA_UNXPBLKREUCNT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNXPBLKREUCNT

GVD_UNDOSTAT-EXPSTEALCNT table field - Oracle monitoring: attempts to steal expired undo blocks

Description: Oracle monitoring: attempts to steal expired undo blocks
Field Name: EXPSTEALCNT
Data Element: ORA_EXPSTEALCNT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXPSTEALCNT

GVD_UNDOSTAT-EXPBLKRELCNT table field - Oracle monitoring: expired undo blocks stolen from segments

Description: Oracle monitoring: expired undo blocks stolen from segments
Field Name: EXPBLKRELCNT
Data Element: ORA_EXPBLKRELCNT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXPBLKRELCNT

GVD_UNDOSTAT-EXPBLKREUCNT table field - Oracle monitoring: expired undo blocks reused

Description: Oracle monitoring: expired undo blocks reused
Field Name: EXPBLKREUCNT
Data Element: ORA_EXPBLKREUCNT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXPBLKREUCNT

GVD_UNDOSTAT-SSOLDERRCNT table field - Oracle monitoring: number of times the error ORA-01555 occur

Description: Oracle monitoring: number of times the error ORA-01555 occur
Field Name: SSOLDERRCNT
Data Element: ORA_SSOLDERRCNT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SSOLDERRCNT

GVD_UNDOSTAT-NOSPACEERRCNT table field - Oracle monitoring: number of times space was requested

Description: Oracle monitoring: number of times space was requested
Field Name: NOSPACEERRCNT
Data Element: ORA_NOSPACEERRCNT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUM_22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NOSPACEERRCNT


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table