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

SAP ORA_PROCESSROW table summary

Object Name: ORA_PROCESSROW
Dictionary Type: Structure
Description: Oracle Monitoring: Processes-row type

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

Details

ORA_PROCESSROW-SID table field - Oracle monitoring: SID (Session) ▼

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

ORA_PROCESSROW-INSTANCE_NUMBER table field - Oracle monitoring: instance number ▼

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

ORA_PROCESSROW-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_PROCESSROW-PADDR table field - Oracle monitoring: PADDR: Address of proc. owning the sess. ▼

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

ORA_PROCESSROW-USERNAME table field - Oracle monitoring: USERNAME: Oracle username ▼

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

ORA_PROCESSROW-SQL_ADDRESS table field - Oracle monitoring: SQL_ADDRESS: SQL Statement ID ▼

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

ORA_PROCESSROW-SQL_HASH_VALUE table field - Oracle monitoring: SQL_HASH_VALUE: SQL statement hash ▼

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

ORA_PROCESSROW-SPID table field - Oracle monitoring: Operating system process identifier ▼

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

ORA_PROCESSROW-PROCPROG table field - Oracle monitoring: PROGRAM: Operating system program name ▼

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

ORA_PROCESSROW-PROCESS table field - Oracle monitoring: OS Process Id ▼

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

ORA_PROCESSROW-MACHINE table field - Oracle monitoring: MACHINE: Operating system machine name ▼

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

ORA_PROCESSROW-SESSPROG table field - Oracle monitoring: PROGRAM: Operating system program name ▼

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

ORA_PROCESSROW-COMMAND table field - Oracle monitoring: COMMAND: Command in progress ▼

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

ORA_PROCESSROW-STATUS table field - Oracle monitoring: Current process status ▼

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

ORA_PROCESSROW-TYPE table field - Oracle Monitoring: Type of user or system lock ▼

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

ORA_PROCESSROW-EVENT table field - Oracle monitor: EVENT ▼

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

ORA_PROCESSROW-BLOCK_GETS table field - Oracle monitoring: ORA_BLOCK_GETS: Block gets for this sessi ▼

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

ORA_PROCESSROW-CONSIST_GETS table field - Oracle monitoring: CONSISTENT_GETS: Consistent gets for sess ▼

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

ORA_PROCESSROW-PHYS_READS table field - Oracle monitoring: PHYSICAL_READS: Physical reads for sess. ▼

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

ORA_PROCESSROW-BLOCK_CHG table field - Oracle monitoring: BLOCK_CHANGES: Block changes for session ▼

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

ORA_PROCESSROW-LOGICAL_READS table field - Oracle Monitoring: Logical Reads ▼

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

ORA_PROCESSROW-SECONDS_IN_WAIT table field - Oracle monitoring: SECONDS_IN_WAIT: ▼

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

ORA_PROCESSROW-WAIT_P1TEXT table field - Oracle monitoring: ORA_P1TEXT: Description of 1. param. ▼

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

ORA_PROCESSROW-WAIT_P1 table field - Oracle monitoring: ORA_P1: First additional parameter ▼

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

ORA_PROCESSROW-WAIT_P2TEXT table field - Oracle monitoring: ORA_P1TEXT: Description of 2. param. ▼

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

ORA_PROCESSROW-WAIT_P2 table field - Oracle monitoring: ORA_P2: Second additional parameter ▼

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

ORA_PROCESSROW-WAIT_P3TEXT table field - Oracle monitoring: ORA_P1TEXT: Description of 3. param. ▼

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

ORA_PROCESSROW-WAIT_P3 table field - Oracle monitoring: ORA_P3: Third additional parameter ▼

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

ORA_PROCESSROW-SQLTEXT table field - Oracle Monitoring: SQL_TEXT: SQL Text of current cursor ▼

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

ORA_PROCESSROW-PGA_USED_MEM table field - Oracle monitoring: PGA memory currently used by the process ▼

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

ORA_PROCESSROW-PGA_ALLOC_MEM table field - Oracle monitoring: PGA memory allocated by the process ▼

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

ORA_PROCESSROW-PGA_FREEABLE_MEM table field - Oracle monitoring: Allocated PGA memory which can be freed ▼

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

ORA_PROCESSROW-PGA_MAX_MEM table field - Oracle monitoring: Max PGA memory allocated by the process ▼

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

View list of all SAP tables(S4H/ECC)

Select data from SAP table