SAP MSQ_PACCES table - Contains data from sysperfinfo on accesses physical&logical details in SAP

SAP MSQ_PACCES table summary

Object Name: MSQ_PACCES
Dictionary Type: Structure
Description: Contains data from sysperfinfo on accesses physical&logical

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

Details

MSQ_PACCES-FULLSCANS table field - Number of unrestricted base table or index scans ▼

Description: Number of unrestricted base table or index scans
Field Name: FULLSCANS
Data Element: MSQPAFULLS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FULLSCANS

MSQ_PACCES-INDEXSRCH table field - Number of index searches. ▼

Description: Number of index searches.
Field Name: INDEXSRCH
Data Element: MSQPAIDXSR
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEXSRCH

MSQ_PACCES-EXTALLOCS table field - Number of extents allocated to database objects ▼

Description: Number of extents allocated to database objects
Field Name: EXTALLOCS
Data Element: MSQPAEXAL
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTALLOCS

MSQ_PACCES-EXTDEALLS table field - Number of extents deallocated in a database ▼

Description: Number of extents deallocated in a database
Field Name: EXTDEALLS
Data Element: MSQPAEXDE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTDEALLS

MSQ_PACCES-PAGEALLOCS table field - Number of pages allocated to database objects ▼

Description: Number of pages allocated to database objects
Field Name: PAGEALLOCS
Data Element: MSQPAPGAL
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGEALLOCS

MSQ_PACCES-PAGEDEALLS table field - Number of pages deallocated in a database ▼

Description: Number of pages deallocated in a database
Field Name: PAGEDEALLS
Data Element: MSQPAPGDE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGEDEALLS

MSQ_PACCES-PAGESPLITS table field - Number of index page splits in a database ▼

Description: Number of index page splits in a database
Field Name: PAGESPLITS
Data Element: MSQPAPGSPL
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGESPLITS

MSQ_PACCES-PROBESCANS table field - Number of probe scans in a database ▼

Description: Number of probe scans in a database
Field Name: PROBESCANS
Data Element: MSQPAPRBSN
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROBESCANS

MSQ_PACCES-RANGESCANS table field - Number of range scans through indexes ▼

Description: Number of range scans through indexes
Field Name: RANGESCANS
Data Element: MSQPARNGSN
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RANGESCANS

MSQ_PACCES-WORKFILES table field - Number of work files created ▼

Description: Number of work files created
Field Name: WORKFILES
Data Element: MSQPAWFCRE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WORKFILES

MSQ_PACCES-WORKTABLES table field - Number of work tables created ▼

Description: Number of work tables created
Field Name: WORKTABLES
Data Element: MSQPAWTCRE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WORKTABLES

MSQ_PACCES-LAZYWRITES table field - Number of buffers written by the lazy writer ▼

Description: Number of buffers written by the lazy writer
Field Name: LAZYWRITES
Data Element: MSQPBLZWTS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAZYWRITES

MSQ_PACCES-PAGEREADS table field - Number of physical page reads ▼

Description: Number of physical page reads
Field Name: PAGEREADS
Data Element: MSQPBPGRDS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGEREADS

MSQ_PACCES-PAGEWRITES table field - Number of physical page writes ▼

Description: Number of physical page writes
Field Name: PAGEWRITES
Data Element: MSQPBPGWRT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGEWRITES

MSQ_PACCES-REQBUFFPG table field - Number of requests for buffer pages. ▼

Description: Number of requests for buffer pages.
Field Name: REQBUFFPG
Data Element: MSQPBUFREQ
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQBUFFPG

MSQ_PACCES-READAHEAD table field - Number of requests to prefetch pages. ▼

Description: Number of requests to prefetch pages.
Field Name: READAHEAD
Data Element: MSQPBRAPGS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field READAHEAD

MSQ_PACCES-AUTOPARAM table field - Number of auto-parameterization attempts ▼

Description: Number of auto-parameterization attempts
Field Name: AUTOPARAM
Data Element: MSQPSAUTO
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTOPARAM

MSQ_PACCES-SQLBATCHS table field - Number of Transact-SQL batches received. ▼

Description: Number of Transact-SQL batches received.
Field Name: SQLBATCHS
Data Element: MSQPSBATCH
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLBATCHS

MSQ_PACCES-SQLCOMPILE table field - Number of SQL compilations. ▼

Description: Number of SQL compilations.
Field Name: SQLCOMPILE
Data Element: MSQPSQLCMP
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLCOMPILE

MSQ_PACCES-AVGLTCHWT table field - Average latch wait time in ms for latch requests that wait ▼

Description: Average latch wait time in ms for latch requests that wait
Field Name: AVGLTCHWT
Data Element: MSQPSALTWT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGLTCHWT

MSQ_PACCES-LATCHWAITS table field - Number of latch requests per second that weren't satisfied ▼

Description: Number of latch requests per second that weren't satisfied
Field Name: LATCHWAITS
Data Element: MSQPSLTHWT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LATCHWAITS

View list of all SAP tables(S4H/ECC)

Select data from SAP table