SAP SQL_SESS table - Information from V$SQL and V$SESSTAT Combined details in SAP

SAP SQL_SESS table summary

Object Name: SQL_SESS
Dictionary Type: Structure
Description: Information from V$SQL and V$SESSTAT Combined

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

Details

SQL_SESS-USR# table field - User Number ▼

Description: User Number
Field Name: USR#
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USR#

SQL_SESS-USERNAME table field - User Name ▼

Description: User Name
Field Name: USERNAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

SQL_SESS-SQL_DR_PU table field - Disk Reads per User from v$sql ▼

Description: Disk Reads per User from v$sql
Field Name: SQL_DR_PU
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_DR_PU

SQL_SESS-SESS_DR_PU table field - Disk Reads per User from v$sesstat ▼

Description: Disk Reads per User from v$sesstat
Field Name: SESS_DR_PU
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_DR_PU

SQL_SESS-SQL_DR table field - Disk Reads System-Wide from v$sql ▼

Description: Disk Reads System-Wide from v$sql
Field Name: SQL_DR
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_DR

SQL_SESS-SESS_DR table field - Disk Reads System-Wide from v$sesstat ▼

Description: Disk Reads System-Wide from v$sesstat
Field Name: SESS_DR
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_DR

SQL_SESS-SQL_BG_PU table field - Buffer Gets per User from v$sql ▼

Description: Buffer Gets per User from v$sql
Field Name: SQL_BG_PU
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_BG_PU

SQL_SESS-SESS_BG_PU table field - Buffer Gets per User from v$sesstat ▼

Description: Buffer Gets per User from v$sesstat
Field Name: SESS_BG_PU
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_BG_PU

SQL_SESS-SQL_BG table field - Buffer Gets System-Wide from v$sql ▼

Description: Buffer Gets System-Wide from v$sql
Field Name: SQL_BG
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_BG

SQL_SESS-SESS_BG table field - Buffer Gets System-Wide from v$sesstat ▼

Description: Buffer Gets System-Wide from v$sesstat
Field Name: SESS_BG
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_BG

SQL_SESS-SQL_BG_PER table field - Percentage of Buffer Gets per User from v$sql in System BG ▼

Description: Percentage of Buffer Gets per User from v$sql in System BG
Field Name: SQL_BG_PER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_BG_PER

SQL_SESS-SES_BG_PER table field - Percentage of Buffer Gets per User from v$sessta in System B ▼

Description: Percentage of Buffer Gets per User from v$sessta in System B
Field Name: SES_BG_PER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SES_BG_PER

SQL_SESS-SQL_DR_PER table field - Percentage of Disk Reads per User from v$sql in System DR ▼

Description: Percentage of Disk Reads per User from v$sql in System DR
Field Name: SQL_DR_PER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_DR_PER

SQL_SESS-SES_DR_PER table field - Percentage of Disk Reads per User from v$sessta in System DR ▼

Description: Percentage of Disk Reads per User from v$sessta in System DR
Field Name: SES_DR_PER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SES_DR_PER

SQL_SESS-BG_AVG_PER table field - Average of Buffer Gets from v$sql and v$sesstat ▼

Description: Average of Buffer Gets from v$sql and v$sesstat
Field Name: BG_AVG_PER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BG_AVG_PER

SQL_SESS-DR_AVG_PER table field - Average of Disk Reads from v$sql and v$sesstat ▼

Description: Average of Disk Reads from v$sql and v$sesstat
Field Name: DR_AVG_PER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DR_AVG_PER

View list of all SAP tables(S4H/ECC)

Select data from SAP table