SAP ORA_SG_BPS table - SDD - Oracle SGA monitor: BPS details in SAP

SAP ORA_SG_BPS table summary

Object Name: ORA_SG_BPS
Dictionary Type: Structure
Description: SDD - Oracle SGA monitor: BPS

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

Details

ORA_SG_BPS-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

ORA_SG_BPS-INSTANCE_NAME table field - Oracle monitoring: instance_name ▼

Description: Oracle monitoring: instance_name
Field Name: INSTANCE_NAME
Data Element: ORA_INSTANCE_NAME
Data Type: CHAR
length (Dec): 48(0)
Check table:
Conversion Routine:
Domain Name: ORA_LK_INSTNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSTANCE_NAME

ORA_SG_BPS-ID table field - Oracle Monitoring: ID: Buffer Pool ID ▼

Description: Oracle Monitoring: ID: Buffer Pool ID
Field Name: ID
Data Element: ORA_BPID
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 ID

ORA_SG_BPS-NAME table field - Oracle Monitoring: NAME: Buffer Pool Name ▼

Description: Oracle Monitoring: NAME: Buffer Pool Name
Field Name: NAME
Data Element: ORA_BPNAME
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

ORA_SG_BPS-BLOCK_SIZE table field - Oracle Monitoring: BLOCK_SIZE: Block Size ▼

Description: Oracle Monitoring: BLOCK_SIZE: Block Size
Field Name: BLOCK_SIZE
Data Element: ORA_BPBLOCK_SIZE
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 BLOCK_SIZE

ORA_SG_BPS-SET_MSIZE table field - Oracle Monitoring: SET_MSIZE: Buffer pool maximum set size ▼

Description: Oracle Monitoring: SET_MSIZE: Buffer pool maximum set size
Field Name: SET_MSIZE
Data Element: ORA_SET_MSIZE
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 SET_MSIZE

ORA_SG_BPS-CNUM_REPL table field - Oracle Monitoring: CNUM_REPL: Number of buffers on repl. lst ▼

Description: Oracle Monitoring: CNUM_REPL: Number of buffers on repl. lst
Field Name: CNUM_REPL
Data Element: ORA_CNUM_REPL
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 CNUM_REPL

ORA_SG_BPS-CNUM_WRITE table field - Oracle Monitoring: CNUM_WRITE: No. of buffers on write list ▼

Description: Oracle Monitoring: CNUM_WRITE: No. of buffers on write list
Field Name: CNUM_WRITE
Data Element: ORA_CNUM_WRITE
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 CNUM_WRITE

ORA_SG_BPS-CNUM_SET table field - Oracle Monitoring: CNUM_SET: Number of buffers in set ▼

Description: Oracle Monitoring: CNUM_SET: Number of buffers in set
Field Name: CNUM_SET
Data Element: ORA_CNUM_SET
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 CNUM_SET

ORA_SG_BPS-BUF_GOT table field - Oracle Monitoring: BUF_GOT: No. of buffers gotten by the set ▼

Description: Oracle Monitoring: BUF_GOT: No. of buffers gotten by the set
Field Name: BUF_GOT
Data Element: ORA_BUF_GOT
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 BUF_GOT

ORA_SG_BPS-SUM_WRITE table field - Oracle Monitoring: SUM_WRITE: Buffers written by set ▼

Description: Oracle Monitoring: SUM_WRITE: Buffers written by set
Field Name: SUM_WRITE
Data Element: ORA_SUM_WRITE
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 SUM_WRITE

ORA_SG_BPS-SUM_SCAN table field - Oracle Monitoring: SUM_SCAN: Buffers scanned in the set ▼

Description: Oracle Monitoring: SUM_SCAN: Buffers scanned in the set
Field Name: SUM_SCAN
Data Element: ORA_SUM_SCAN
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 SUM_SCAN

ORA_SG_BPS-FREE_BUFFER_WAIT table field - Oracle Monitoring: FREE_BUFFER_WAIT: Free buffer wait stat. ▼

Description: Oracle Monitoring: FREE_BUFFER_WAIT: Free buffer wait stat.
Field Name: FREE_BUFFER_WAIT
Data Element: ORA_FREE_BUFFER_WAIT
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 FREE_BUFFER_WAIT

ORA_SG_BPS-WRITE_COMPLETE_W table field - Oracle Monitoring: WRITE_COMPLETE_WAIT: Write complete wait ▼

Description: Oracle Monitoring: WRITE_COMPLETE_WAIT: Write complete wait
Field Name: WRITE_COMPLETE_W
Data Element: ORA_WRITE_COMPLETE_WAIT
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 WRITE_COMPLETE_W

ORA_SG_BPS-BUFFER_BUSY_WAIT table field - Oracle Monitoring: BUFFER_BUSY_WAIT: Buffer busy wait stat. ▼

Description: Oracle Monitoring: BUFFER_BUSY_WAIT: Buffer busy wait stat.
Field Name: BUFFER_BUSY_WAIT
Data Element: ORA_BUFFER_BUSY_WAIT
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 BUFFER_BUSY_WAIT

ORA_SG_BPS-FREE_BUFFER_INSP table field - Oracle Monitoring: FREE_BUFFER_INSPECTED: Free buffer inspec ▼

Description: Oracle Monitoring: FREE_BUFFER_INSPECTED: Free buffer inspec
Field Name: FREE_BUFFER_INSP
Data Element: ORA_FREE_BUFFER_INSPECTED
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 FREE_BUFFER_INSP

ORA_SG_BPS-DIRTY_BUFFERS_IN table field - Oracle Monitoring: DIRTY_BUFFERS_INSPECTED: Dirty buffers in ▼

Description: Oracle Monitoring: DIRTY_BUFFERS_INSPECTED: Dirty buffers in
Field Name: DIRTY_BUFFERS_IN
Data Element: ORA_DIRTY_BUFFERS_INSPECTED
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 DIRTY_BUFFERS_IN

ORA_SG_BPS-DB_BLOCK_CHANGE table field - Oracle Monitoring: DB_BLOCK_CHANGE: Database blocks changed ▼

Description: Oracle Monitoring: DB_BLOCK_CHANGE: Database blocks changed
Field Name: DB_BLOCK_CHANGE
Data Element: ORA_DB_BLOCK_CHANGE
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 DB_BLOCK_CHANGE

ORA_SG_BPS-DB_BLOCK_GETS table field - Oracle Monitoring: DB_BLOCK_GETS: Database blocks gotten ▼

Description: Oracle Monitoring: DB_BLOCK_GETS: Database blocks gotten
Field Name: DB_BLOCK_GETS
Data Element: ORA_DB_BLOCK_GETS
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 DB_BLOCK_GETS

ORA_SG_BPS-CONSISTENT_GETS table field - Oracle Monitoring: CONSISTENT_GETS: Consistent gets statisti ▼

Description: Oracle Monitoring: CONSISTENT_GETS: Consistent gets statisti
Field Name: CONSISTENT_GETS
Data Element: ORA_BPCONSISTENT_GETS
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 CONSISTENT_GETS

ORA_SG_BPS-PHYSICAL_READS table field - Oracle Monitoring: PHYSICAL_READS: Physical reads statistic ▼

Description: Oracle Monitoring: PHYSICAL_READS: Physical reads statistic
Field Name: PHYSICAL_READS
Data Element: ORA_BPPHYSICAL_READS
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 PHYSICAL_READS

ORA_SG_BPS-PHYSICAL_WRITES table field - Oracle Monitoring: PHYSICAL_READS: Physical reads statistic ▼

Description: Oracle Monitoring: PHYSICAL_READS: Physical reads statistic
Field Name: PHYSICAL_WRITES
Data Element: ORA_BPPHYSICAL_READS
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 PHYSICAL_WRITES

ORA_SG_BPS-HITRATIO table field - SDD - Oracle SGA monitor: HITRATIO ▼

Description: SDD - Oracle SGA monitor: HITRATIO
Field Name: HITRATIO
Data Element: ORA_SG_HITRATIO
Data Type: DEC
length (Dec): 22(2)
Check table:
Conversion Routine:
Domain Name: ORA_SG_HITRATIO
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HITRATIO

View list of all SAP tables(S4H/ECC)

Select data from SAP table