Data Element list used by SAP ABAP Table TST04INF (Statistics: Structure for Database Information Display)
SAP ABAP Table TST04INF (Statistics: Structure for Database Information Display) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | ACTIVE_SES | Active database server sessions | |
2 | Data Element | AIOVPS | Number of AIO virtual processors | |
3 | Data Element | BUFFERS | Number of regular shared memory buffers | |
4 | Data Element | BUFFERSPAC | Total size of database shared memory buffer | |
5 | Data Element | BUFPOOLFLU | Number of buffer pool flushes | |
6 | Data Element | BUFREADSI | Number of reads from shared memory buffer | |
7 | Data Element | BUFSIZ | System page size (KB) | |
8 | Data Element | BUFWRITES | Number of writes to shared memory buffer | |
9 | Data Element | BUFWTPCNT | Percentage of Buffer Wait Events | |
10 | Data Element | BUFWTS | Number of Buffer Wait Events | |
11 | Data Element | CHUNKWRITE | Writes resulting from a checkpoint | |
12 | Data Element | CKPTINTVL | Database checkpoint interval (s) | |
13 | Data Element | CLEANERS | Number of database buffer cleaner processes | |
14 | Data Element | COM_SHMSIZ | Shared memory communications portion | |
15 | Data Element | CORR_1 | Checkpoint activity since bootup (100% = inactive) | |
16 | Data Element | CORR_2 | Physical log sizing by checkpoint | |
17 | Data Element | CORR_3 | Logical log sizing by checkpoint | |
18 | Data Element | DBFILES | Number of disk files used for INFORMIX database | |
19 | Data Element | DBSERVERNA | Name of database server | |
20 | Data Element | DSKREADS | Actual reads from disk | |
21 | Data Element | DSKWRITES | Actual number of writes to disk | |
22 | Data Element | FGWRITES | Number of foreground writes | |
23 | Data Element | FLUSHCKPTS | Number of buffer flushes due to checkpointing | |
24 | Data Element | IDL_WRITES | Number of idle writes | |
25 | Data Element | ISAMTOT | Total number of ISAM calls since database startup | |
26 | Data Element | ISCALLS_SE | Transaction per minute | |
27 | Data Element | ISCALLS_TR | ISAM calls per transaction | |
28 | Data Element | ISCOMMITS | ISAM commits since database startup | |
29 | Data Element | ISROLLBACK | ISAM rollbacks since database startup | |
30 | Data Element | KAIOTHREAD | Number of kaio threads for kernel asynchronous disk I/O | |
31 | Data Element | LLGPAGEWRI | Number of pages written to logical logs | |
32 | Data Element | LLGWRITES | Number of pages written to logical log | |
33 | Data Element | LOCKS | Max. number of locks | |
34 | Data Element | LOGBUFF | Size of each of the three logical log buffers | |
35 | Data Element | LOGSIZ | Size of a single logical log | |
36 | Data Element | LRUMAXDIRT | When to begin cleaning LRU queues | |
37 | Data Element | LRUMINDIRT | When to stop cleaning LRU queues | |
38 | Data Element | LRUS | Number of LRU queues | |
39 | Data Element | LRUWRITES | Number of LRU writes | |
40 | Data Element | LTXHWM | High watermark percentage | |
41 | Data Element | NUMCKPTS | Number of checkpoints since database startup | |
42 | Data Element | NUMCPUVPS | Number of user (CPU) virtual processors | |
43 | Data Element | OVBUFF | Number of unsuccessful accesses to shared memory buffer | |
44 | Data Element | PAGES_IO_1 | Average number of kbytes to physical-log per write | |
45 | Data Element | PAGES_IO_2 | Average number of kbytes to logical log per write | |
46 | Data Element | PAGREADS | Number of Buffer Pages Read | |
47 | Data Element | PAGWRITES | Number of Buffer Pages Written | |
48 | Data Element | PC_SLEEP | Sleep time for page cleaners | |
49 | Data Element | PHYSBUFF | Size of the two physical log buffers | |
50 | Data Element | PHYSFILE | Physical log file size (KB) | |
51 | Data Element | PLGPAGEWRI | Number of physical log pages written | |
52 | Data Element | PLGWRITES | Number of writes to the physical log buffer | |
53 | Data Element | RA_COUNT | Total number of pages which were read ahead | |
54 | Data Element | RA_PAGES | Number of pages to read ahead for sequential or index scans | |
55 | Data Element | RA_PCNT | Percentage of pages read ahead actually used | |
56 | Data Element | RA_PERSCAN | Number of sequential scans per read ahead | |
57 | Data Element | RA_THRESH | Read ahead page trigger | |
58 | Data Element | RA_USED | Number of used pages from read ahead data | |
59 | Data Element | READ_QUALI | Percentage of successful reads from shared memory | |
60 | Data Element | RESET_STAT | Time since last reset statistics in seconds | |
61 | Data Element | RES_SHMSIZ | Resident shared menory portion | |
62 | Data Element | SEQSCANS | Number of sequential scans since database startup | |
63 | Data Element | TOT_SHMSIZ | Total size of INFORMIX shared memory | |
64 | Data Element | UPSINCE | Time since DB start in seconds (Informix monitor) | |
65 | Data Element | WRITE_QUAL | Percentage of successful writes for shared memory buffer | |
66 | Data Element | XMEM_ALLOC | Amount of additional virtual shared memory |