SAP ORASESS table - Oracle: Sessions details in SAP

SAP ORASESS table summary

Object Name: ORASESS
Dictionary Type: Structure
Description: Oracle: Sessions

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

Details

ORASESS-SESS_TYPE table field - Oracle: Session type (user, background, etc.) ▼

Description: Oracle: Session type (user, background, etc.)
Field Name: SESS_TYPE
Data Element: SESS_TYPE
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_TYPE

ORASESS-CLIENT1 table field - Oracle: Client of an Oracle session ▼

Description: Oracle: Client of an Oracle session
Field Name: CLIENT1
Data Element: ORACLIENT
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: CHAR32
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENT1

ORASESS-CLIENT2 table field - Oracle: Client of an Oracle session ▼

Description: Oracle: Client of an Oracle session
Field Name: CLIENT2
Data Element: ORACLIENT
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: CHAR32
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENT2

ORASESS-SESSCOUNT table field - Oracle: Number of sessions per session type and client ▼

Description: Oracle: Number of sessions per session type and client
Field Name: SESSCOUNT
Data Element: ORASESSC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESSCOUNT

ORASESS-WAIT_TOTAL table field - Oracle: Time_Waited (V$System_Event, V$Session_Event) ▼

Description: Oracle: Time_Waited (V$System_Event, V$Session_Event)
Field Name: WAIT_TOTAL
Data Element: TIME_WAIT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_TOTAL

ORASESS-WAIT_BUSY table field - Oracle: Time_Waited (V$System_Event, V$Session_Event) ▼

Description: Oracle: Time_Waited (V$System_Event, V$Session_Event)
Field Name: WAIT_BUSY
Data Element: TIME_WAIT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_BUSY

View list of all SAP tables(S4H/ECC)

Select data from SAP table