/SDF/INF_TST04 SAP (Statistics: Structure for database information display) Structure details
Description: Statistics: Structure for database information display
Related tables to /SDF/INF_TST04
Access table /SDF/INF_TST04
Structure field list including key, data, relationships and ABAP select examples
/SDF/INF_TST04 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Statistics: Structure for database information display" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_/SDF/INF_TST04 TYPE /SDF/INF_TST04.
The /SDF/INF_TST04 table consists of various fields, each holding specific information or linking keys about Statistics: Structure for database information display data available in SAP. These include BUFREADS (Number of reads from shared memory buffer), DSKREADS (Actual reads from disk), BUFWRITES (Number of writes to shared memory buffer), DSKWRITES (Actual number of writes to disk).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: S - System table, maint. only by SAP, change = modificationDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP /SDF/INF_TST04 structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
BUFSIZETOT | Total size of database shared memory buffer | 0 | |||||||
BUFREADS | Number of reads from shared memory buffer | 0 | |||||||
DSKREADS | Actual reads from disk | 0 | |||||||
BUFWRITES | Number of writes to shared memory buffer | 0 | |||||||
DSKWRITES | Actual number of writes to disk | 0 | |||||||
PLGPAGEWRI | Number of physical log pages written | 0 | |||||||
PLGWRITES | Number of writes to the physical log buffer | 0 | |||||||
LLGPAGEWRI | Number of pages written to logical logs | 0 | |||||||
LLGWRITES | Number of pages written to logical log | 0 | |||||||
BUFPOOLFLU | Number of buffer pool flushes | 0 | |||||||
FGWRITES | Number of foreground writes | 0 | |||||||
LRUWRITES | Number of LRU writes | 0 | |||||||
CHUNKWRITE | Writes resulting from a checkpoint | 0 | |||||||
ISCOMMITS | ISAM commits since database startup | 0 | |||||||
ISROLLBACK | ISAM rollbacks since database startup | 0 | |||||||
ISAMTOT | Total number of ISAM calls since database startup | 0 | |||||||
SEQSCANS | Number of sequential scans since database startup | 0 | |||||||
NUMCKPTS | Number of checkpoints since database startup | 0 | |||||||
READQUAL | Percentage of successful reads from shared memory | 0 | |||||||
WRITEQUAL | Percentage of successful writes for shared memory buffer | 0 | |||||||
PHYSLOG_IO | Average number of kbytes to physical-log per write | 0 | |||||||
LOGLOG_IO | Average number of kbytes to logical log per write | 0 | |||||||
ACTIVESESS | Active database server sessions | 0 | |||||||
TRANS_MIN | Transaction per minute | 0 | |||||||
ISCALLS_TR | ISAM calls per transaction | 0 | |||||||
CKPTCORR | Checkpoint activity since bootup (100% = inactive) | 0 | |||||||
PHYSCORR | Physical log sizing by checkpoint | 0 | |||||||
CORR_3 | Logical log sizing by checkpoint | 0 | |||||||
BUFFERS | Number of regular shared memory buffers | 0 | |||||||
PAGESIZE | System page size (KB) | 0 | |||||||
PHYSBUFF | Size of the two physical log buffers | 0 | |||||||
LOGBUFF | Size of each of the three logical log buffers | 0 | |||||||
CLEANERS | Number of database buffer cleaner processes | 0 | |||||||
LRUS | Number of LRU queues | 0 | |||||||
LRUMAXDIRT | When to begin cleaning LRU queues | 0 | |||||||
LRUMINDIRT | When to stop cleaning LRU queues | 0 | |||||||
CKPTINTVL | Database checkpoint interval (s) | 0 | |||||||
NUMCPUVPS | Number of user (CPU) virtual processors | 0 | |||||||
PHYSFILE | Physical log file size (KB) | 0 | |||||||
LOGSIZ | Size of a single logical log | 0 | |||||||
DBSERVERNA | Name of database server | 0 | |||||||
LTXHWM | High watermark percentage | 0 | |||||||
LOCKS | Max. number of locks | 0 | |||||||
RA_PAGES | Number of pages to read ahead for sequential or index scans | 0 | |||||||
RA_THRESH | Read ahead page trigger | 0 | |||||||
RA_USED | Number of used pages from read ahead data | 0 | |||||||
RA_COUNT | Total number of pages which were read ahead | 0 | |||||||
RA_PERSCAN | Number of sequential scans per read ahead | 0 | |||||||
RA_PCNT | Percentage of pages read ahead actually used | 0 | |||||||
IDL_WRITES | Number of idle writes | 0 | |||||||
PC_SLEEP | Sleep time for page cleaners | 0 | |||||||
OVBUFF | Number of unsuccessful accesses to shared memory buffer | 0 | |||||||
SHMVIRT | Amount of additional virtual shared memory | 0 | |||||||
FLUSHCKPTS | Number of buffer flushes due to checkpointing | 0 | |||||||
SHMTOTAL | Total size of INFORMIX shared memory | 0 | |||||||
NUMAIOVPS | Number of AIO virtual processors | 0 | |||||||
DBFILES | Number of disk files used for INFORMIX database | 0 | |||||||
SHMRES | Resident shared menory portion | 0 | |||||||
SHMMES | Shared memory communications portion | 0 | |||||||
KAIOTHREAD | Number of kaio threads for kernel asynchronous disk I/O | 0 | |||||||
UP_SINCE | Time since DB start in seconds (Informix monitor) | 0 | |||||||
RESET_STAT | Time since last reset statistics in seconds | 0 | |||||||
PAGREADS | Number of Buffer Pages Read | 0 | |||||||
PAGWRITES | Number of Buffer Pages Written | 0 | |||||||
BUFWTS | Number of buffer wait events | 0 | |||||||
BUFWTPCNT | Percentage of buffer wait events | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure /SDF/INF_TST04 using ABAP code?
As /SDF/INF_TST04 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /SDF/INF_TST04 as there is no data to select.How to access SAP table /SDF/INF_TST04
Within an ECC or HANA version of SAP you can also view further information about /SDF/INF_TST04 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects