SAP ORA_SM_SESSIONS table - SDD - Oracle session monitor: session list details in SAP

SAP ORA_SM_SESSIONS table summary

Object Name: ORA_SM_SESSIONS
Dictionary Type: Structure
Description: SDD - Oracle session monitor: session list

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

Details

ORA_SM_SESSIONS-SID table field - SDD - Oracle lock monitor: SID ▼

Description: SDD - Oracle lock monitor: SID
Field Name: SID
Data Element: ORA_LK_SID
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_LK_SID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SID

ORA_SM_SESSIONS-INSTANCE_NUMBER table field - SDD - Oracle lock monitor: Instance ID ▼

Description: SDD - Oracle lock monitor: Instance ID
Field Name: INSTANCE_NUMBER
Data Element: ORA_LK_INSTID
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_LK_INSTID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSTANCE_NUMBER

ORA_SM_SESSIONS-INSTANCE_NAME table field - SDD - Oracle lock monitor: INSTNAME ▼

Description: SDD - Oracle lock monitor: INSTNAME
Field Name: INSTANCE_NAME
Data Element: ORA_LK_INSTNAME
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_SM_SESSIONS-PADDR table field - SDD - Oracle lock monitor: PADDR ▼

Description: SDD - Oracle lock monitor: PADDR
Field Name: PADDR
Data Element: ORA_LK_PADDR
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_LK_PADDR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PADDR

ORA_SM_SESSIONS-USERNAME table field - SDD - Oracle lock monitor: USERNAME ▼

Description: SDD - Oracle lock monitor: USERNAME
Field Name: USERNAME
Data Element: ORA_SM_USERNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_USERNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

ORA_SM_SESSIONS-SQL_ADDRESS table field - SDD - Oracle lock monitor: SQLADDR ▼

Description: SDD - Oracle lock monitor: SQLADDR
Field Name: SQL_ADDRESS
Data Element: ORA_LK_SQLADDR
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: ORA_LK_SQLADDR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_ADDRESS

ORA_SM_SESSIONS-SQL_HASH_VALUE table field - SDD - Oracle lock monitor: SQLHASH ▼

Description: SDD - Oracle lock monitor: SQLHASH
Field Name: SQL_HASH_VALUE
Data Element: ORA_LK_SQLHASH
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_LK_SQLHASH
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_HASH_VALUE

ORA_SM_SESSIONS-SPID table field - SDD - Oracle lock monitor: SPID ▼

Description: SDD - Oracle lock monitor: SPID
Field Name: SPID
Data Element: ORA_LK_SPID
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: ORA_LK_SPID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPID

ORA_SM_SESSIONS-PROCPROG table field - SDD - Oracle lock monitor: PROCPROG ▼

Description: SDD - Oracle lock monitor: PROCPROG
Field Name: PROCPROG
Data Element: ORA_SM_PROCPROG
Data Type: CHAR
length (Dec): 48(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_PROCPROG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCPROG

ORA_SM_SESSIONS-PROCESS table field - SDD - Oracle lock monitor: PROCESS ▼

Description: SDD - Oracle lock monitor: PROCESS
Field Name: PROCESS
Data Element: ORA_SM_PROCESS
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_PROCESS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCESS

ORA_SM_SESSIONS-MACHINE table field - SDD - Oracle lock monitor: MACHINE ▼

Description: SDD - Oracle lock monitor: MACHINE
Field Name: MACHINE
Data Element: ORA_SM_MACHINE
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_MACHINE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MACHINE

ORA_SM_SESSIONS-SESSPROG table field - SDD - Oracle lock monitor: SESSPROG ▼

Description: SDD - Oracle lock monitor: SESSPROG
Field Name: SESSPROG
Data Element: ORA_SM_SESSPROG
Data Type: CHAR
length (Dec): 48(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_SESSPROG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESSPROG

ORA_SM_SESSIONS-COMMAND table field - SDD - Oracle lock monitor: COMMAND ▼

Description: SDD - Oracle lock monitor: COMMAND
Field Name: COMMAND
Data Element: ORA_SM_COMMAND
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_COMMAND
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND

ORA_SM_SESSIONS-STATUS table field - SDD - Oracle lock monitor: STATUS ▼

Description: SDD - Oracle lock monitor: STATUS
Field Name: STATUS
Data Element: ORA_SM_STATUS
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

ORA_SM_SESSIONS-TYPE table field - SDD - Oracle lock monitor: TYPE ▼

Description: SDD - Oracle lock monitor: TYPE
Field Name: TYPE
Data Element: ORA_SM_TYPE
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TYPE

ORA_SM_SESSIONS-EVENT table field - SDD - Oracle lock monitor: EVENT ▼

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

See all SAP tables containing field EVENT

ORA_SM_SESSIONS-BLOCK_GETS table field - SDD - Oracle lock monitor: BLGETS ▼

Description: SDD - Oracle lock monitor: BLGETS
Field Name: BLOCK_GETS
Data Element: ORA_SM_BLGETS
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_BLGETS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCK_GETS

ORA_SM_SESSIONS-CONSIST_GETS table field - SDD - Oracle lock monitor: COGETS ▼

Description: SDD - Oracle lock monitor: COGETS
Field Name: CONSIST_GETS
Data Element: ORA_SM_COGETS
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_COGETS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONSIST_GETS

ORA_SM_SESSIONS-PHYS_READS table field - SDD - Oracle lock monitor: PHYREADS ▼

Description: SDD - Oracle lock monitor: PHYREADS
Field Name: PHYS_READS
Data Element: ORA_SM_PHYREADS
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_PHYREADS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHYS_READS

ORA_SM_SESSIONS-BLOCK_CHG table field - SDD - Oracle lock monitor: BLKCHG ▼

Description: SDD - Oracle lock monitor: BLKCHG
Field Name: BLOCK_CHG
Data Element: ORA_SM_BLKCHG
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_BLKCHG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCK_CHG

ORA_SM_SESSIONS-LOGICAL_READS table field - SDD - Oracle lock monitor: LOGREAD ▼

Description: SDD - Oracle lock monitor: LOGREAD
Field Name: LOGICAL_READS
Data Element: ORA_SM_LOGREAD
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_LOGREAD
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGICAL_READS

ORA_SM_SESSIONS-SECONDS_IN_WAIT table field - SDD - Oracle lock monitor: SECIWAIT ▼

Description: SDD - Oracle lock monitor: SECIWAIT
Field Name: SECONDS_IN_WAIT
Data Element: ORA_SM_SECIWAIT
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_SECIWAIT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SECONDS_IN_WAIT

ORA_SM_SESSIONS-WAIT_P1TEXT table field - SDD - Oracle lock monitor: WAITPT ▼

Description: SDD - Oracle lock monitor: WAITPT
Field Name: WAIT_P1TEXT
Data Element: ORA_SM_WAITPT
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_WAITPT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_P1TEXT

ORA_SM_SESSIONS-WAIT_P1 table field - SDD - Oracle lock monitor: WAITP ▼

Description: SDD - Oracle lock monitor: WAITP
Field Name: WAIT_P1
Data Element: ORA_SM_WAITP
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_WAITP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_P1

ORA_SM_SESSIONS-WAIT_P2TEXT table field - SDD - Oracle lock monitor: WAITPT ▼

Description: SDD - Oracle lock monitor: WAITPT
Field Name: WAIT_P2TEXT
Data Element: ORA_SM_WAITPT
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_WAITPT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_P2TEXT

ORA_SM_SESSIONS-WAIT_P2 table field - SDD - Oracle lock monitor: WAITP ▼

Description: SDD - Oracle lock monitor: WAITP
Field Name: WAIT_P2
Data Element: ORA_SM_WAITP
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_WAITP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_P2

ORA_SM_SESSIONS-WAIT_P3TEXT table field - SDD - Oracle lock monitor: WAITPT ▼

Description: SDD - Oracle lock monitor: WAITPT
Field Name: WAIT_P3TEXT
Data Element: ORA_SM_WAITPT
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_WAITPT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_P3TEXT

ORA_SM_SESSIONS-WAIT_P3 table field - SDD - Oracle lock monitor: WAITP ▼

Description: SDD - Oracle lock monitor: WAITP
Field Name: WAIT_P3
Data Element: ORA_SM_WAITP
Data Type: NUMC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_WAITP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_P3

ORA_SM_SESSIONS-SQLTEXT table field - SDD - Oracle lock monitor: SQLTEXT ▼

Description: SDD - Oracle lock monitor: SQLTEXT
Field Name: SQLTEXT
Data Element: ORA_SM_SQLTEXT
Data Type: CHAR
length (Dec): 1000(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_SQLTEXT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLTEXT

ORA_SM_SESSIONS-PGA_USED_MEM table field - SDD - Oracle lock monitor: USEDMEM ▼

Description: SDD - Oracle lock monitor: USEDMEM
Field Name: PGA_USED_MEM
Data Element: ORA_SM_USEDMEM
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_USEDMEM
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PGA_USED_MEM

ORA_SM_SESSIONS-PGA_ALLOC_MEM table field - SDD - Oracle lock monitor: ALLOMEM ▼

Description: SDD - Oracle lock monitor: ALLOMEM
Field Name: PGA_ALLOC_MEM
Data Element: ORA_SM_ALLOMEM
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_ALLOMEM
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PGA_ALLOC_MEM

ORA_SM_SESSIONS-PGA_FREEABLE_MEM table field - SDD - Oracle lock monitor: FREEMEM ▼

Description: SDD - Oracle lock monitor: FREEMEM
Field Name: PGA_FREEABLE_MEM
Data Element: ORA_SM_FREEMEM
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_FREEMEM
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PGA_FREEABLE_MEM

ORA_SM_SESSIONS-PGA_MAX_MEM table field - SDD - Oracle lock monitor: MAXMEM ▼

Description: SDD - Oracle lock monitor: MAXMEM
Field Name: PGA_MAX_MEM
Data Element: ORA_SM_MAXMEM
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_SM_MAXMEM
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