SAP ORA_PROCESSROW table - Oracle Monitoring: Processes-row type details in SAP

Description: Oracle monitoring: SID (Session)
Field Name: SID
Data Element: ORA_SID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SID

Description: Oracle monitoring: instance number
Field Name: INSTANCE_NUMBER
Data Element: ORA_INSTANCE_NUMBER
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSTANCE_NUMBER

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

Description: Oracle monitoring: PADDR: Address of proc. owning the sess.
Field Name: PADDR
Data Element: ORA_PADDR
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_PADDR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PADDR

Description: Oracle monitoring: USERNAME: Oracle username
Field Name: USERNAME
Data Element: ORA_USERNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_USERNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

Description: Oracle monitoring: SQL_ADDRESS: SQL Statement ID
Field Name: SQL_ADDRESS
Data Element: ORA_SQL_ADDRESS
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_SQL_ADDRESS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_ADDRESS

Description: Oracle monitoring: SQL_HASH_VALUE: SQL statement hash
Field Name: SQL_HASH_VALUE
Data Element: ORA_SQL_HASH_VALUE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SQL_HASH_VALUE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_HASH_VALUE

Description: Oracle monitoring: Operating system process identifier
Field Name: SPID
Data Element: ORA_SPID
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPID

Description: Oracle monitoring: PROGRAM: Operating system program name
Field Name: PROCPROG
Data Element: ORA_PROGRAM
Data Type: CHAR
length (Dec): 48(0)
Check table:
Conversion Routine:
Domain Name: ORA_PROGRAM
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCPROG

Description: Oracle monitoring: OS Process Id
Field Name: PROCESS
Data Element: ORA_PROCESS
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: ORA_PROCESS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCESS

Description: Oracle monitoring: MACHINE: Operating system machine name
Field Name: MACHINE
Data Element: ORA_MACHINE
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORA_MACHINE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MACHINE

Description: Oracle monitoring: PROGRAM: Operating system program name
Field Name: SESSPROG
Data Element: ORA_PROGRAM
Data Type: CHAR
length (Dec): 48(0)
Check table:
Conversion Routine:
Domain Name: ORA_PROGRAM
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESSPROG

Description: Oracle monitoring: COMMAND: Command in progress
Field Name: COMMAND
Data Element: ORA_COMMAND
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_COMMAND
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND

Description: Oracle monitoring: Current process status
Field Name: STATUS
Data Element: ORA_STATUS
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

Description: Oracle Monitoring: Type of user or system lock
Field Name: TYPE
Data Element: ORA_TYPE
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: ORA_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TYPE

Description: Oracle monitor: EVENT
Field Name: EVENT
Data Element: ORA_EVENT
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_64
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EVENT

Description: Oracle monitoring: ORA_BLOCK_GETS: Block gets for this sessi
Field Name: BLOCK_GETS
Data Element: ORA_BLOCK_GETS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_BLOCK_GETS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCK_GETS

Description: Oracle monitoring: CONSISTENT_GETS: Consistent gets for sess
Field Name: CONSIST_GETS
Data Element: ORA_CONSISTENT_GETS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_CONSISTENT_GETS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONSIST_GETS

Description: Oracle monitoring: PHYSICAL_READS: Physical reads for sess.
Field Name: PHYS_READS
Data Element: ORA_PHYSICAL_READS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_PHYSICAL_READS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHYS_READS

Description: Oracle monitoring: BLOCK_CHANGES: Block changes for session
Field Name: BLOCK_CHG
Data Element: ORA_BLOCK_CHANGES
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_BLOCK_CHANGES
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCK_CHG

Description: Oracle Monitoring: Logical Reads
Field Name: LOGICAL_READS
Data Element: ORA_LOGICAL_READS
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_BLOCK_CHANGES
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGICAL_READS

Description: Oracle monitoring: SECONDS_IN_WAIT:
Field Name: SECONDS_IN_WAIT
Data Element: ORA_SECONDS_IN_WAIT
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SECONDS_IN_WAIT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SECONDS_IN_WAIT

Description: Oracle monitoring: ORA_P1TEXT: Description of 1. param.
Field Name: WAIT_P1TEXT
Data Element: ORA_P1TEXT
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORA_P1TEXT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_P1TEXT

Description: Oracle monitoring: ORA_P1: First additional parameter
Field Name: WAIT_P1
Data Element: ORA_P1
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_P1
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_P1

Description: Oracle monitoring: ORA_P1TEXT: Description of 2. param.
Field Name: WAIT_P2TEXT
Data Element: ORA_P2TEXT
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORA_P2TEXT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_P2TEXT

Description: Oracle monitoring: ORA_P2: Second additional parameter
Field Name: WAIT_P2
Data Element: ORA_P2
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_P2
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_P2

Description: Oracle monitoring: ORA_P1TEXT: Description of 3. param.
Field Name: WAIT_P3TEXT
Data Element: ORA_P3TEXT
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORA_P3TEXT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_P3TEXT

Description: Oracle monitoring: ORA_P3: Third additional parameter
Field Name: WAIT_P3
Data Element: ORA_P3
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_P3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_P3

Description: Oracle Monitoring: SQL_TEXT: SQL Text of current cursor
Field Name: SQLTEXT
Data Element: ORA_SQL_TEXT
Data Type: LCHR
length (Dec): 1000(0)
Check table:
Conversion Routine:
Domain Name: ORA_CHAR_1000
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLTEXT

Description: Oracle monitoring: PGA memory currently used by the process
Field Name: PGA_USED_MEM
Data Element: ORA_PGA_USED_MEM
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 PGA_USED_MEM

Description: Oracle monitoring: PGA memory allocated by the process
Field Name: PGA_ALLOC_MEM
Data Element: ORA_PGA_ALLOC_MEM
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 PGA_ALLOC_MEM

Description: Oracle monitoring: Allocated PGA memory which can be freed
Field Name: PGA_FREEABLE_MEM
Data Element: ORA_PGA_FREEABLE_MEM
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 PGA_FREEABLE_MEM

Description: Oracle monitoring: Max PGA memory allocated by the process
Field Name: PGA_MAX_MEM
Data Element: ORA_PGA_MAX_MEM
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 PGA_MAX_MEM