Data Element list used by SAP ABAP Table TST04INF64 (Statistics: Structure for Database Information Display)
SAP ABAP Table
TST04INF64 (Statistics: Structure for Database Information Display) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
![]() |
![]() |
|||
1 | ![]() |
ACTIVE_SES | Active database server sessions | |
2 | ![]() |
AIOVPS | Number of AIO virtual processors | |
3 | ![]() |
BUFFERS | Number of regular shared memory buffers | |
4 | ![]() |
BUFFERSPAC | Total size of database shared memory buffer | |
5 | ![]() |
BUFPOOLFLU | Number of buffer pool flushes | |
6 | ![]() |
BUFREADS64 | Number of reads from shared memory buffer | |
7 | ![]() |
BUFSIZ | System page size (KB) | |
8 | ![]() |
BUFWAITS64 | Number of Buffer Wait Events | |
9 | ![]() |
BUFWRITS64 | Number of writes to shared memory buffer | |
10 | ![]() |
BUFWTPCNT | Percentage of Buffer Wait Events | |
11 | ![]() |
CHKWRITS64 | Writes resulting from a checkpoint | |
12 | ![]() |
CKPTINTVL | Database checkpoint interval (s) | |
13 | ![]() |
CLEANERS | Number of database buffer cleaner processes | |
14 | ![]() |
COM_SHMSIZ | Shared memory communications portion | |
15 | ![]() |
CORR_1 | Checkpoint activity since bootup (100% = inactive) | |
16 | ![]() |
CORR_2 | Physical log sizing by checkpoint | |
17 | ![]() |
CORR_3 | Logical log sizing by checkpoint | |
18 | ![]() |
DBFILES | Number of disk files used for INFORMIX database | |
19 | ![]() |
DBSERVERNA | Name of database server | |
20 | ![]() |
DEADLCKS | Number of Deadlocks | |
21 | ![]() |
DISKSORTS | Number of Sort Events in Memory | |
22 | ![]() |
DSKREADS64 | Actual reads (I/O requests) from disk | |
23 | ![]() |
DSKWRITS64 | Actual number of writes (I/O requests) to disk | |
24 | ![]() |
DSMAXQUERY | DS Max Queries | |
25 | ![]() |
DSMAXSCANS | DS Max Scans | |
26 | ![]() |
DSTOTALMEM | DS Total Memory | |
27 | ![]() |
FGWRITES64 | Number of foreground writes | |
28 | ![]() |
FLUSHCKPTS | Number of buffer flushes due to checkpointing | |
29 | ![]() |
IDL_WRITES | Number of idle writes | |
30 | ![]() |
ISAMTOT64 | Total number of ISAM calls | |
31 | ![]() |
ISCALLS_SE | Transaction per minute | |
32 | ![]() |
ISCALLS_TR | ISAM calls per transaction | |
33 | ![]() |
ISCOMMIT64 | ISAM commits since database startup | |
34 | ![]() |
ISDELETE64 | ISAM Delete Calls | |
35 | ![]() |
ISREADS64 | ISAM Read Calls | |
36 | ![]() |
ISREWRIT64 | ISAM Rewrite Calls | |
37 | ![]() |
ISROLLBK64 | ISAM rollbacks since database startup | |
38 | ![]() |
ISSTARTS64 | ISAM Start Calls (Index read) | |
39 | ![]() |
ISWRITES64 | ISAM Write Calls | |
40 | ![]() |
KAIOTHREAD | Number of kaio threads for kernel asynchronous disk I/O | |
41 | ![]() |
LLGPGWRI64 | Number of logical log pages written | |
42 | ![]() |
LLGWRITS64 | Number of writes to the logical log | |
43 | ![]() |
LOCKREQS64 | Number of Lock Requests | |
44 | ![]() |
LOCKS | Max. number of locks | |
45 | ![]() |
LOCKSCURR | Locks currently held | |
46 | ![]() |
LOCKTOUTS | Number of Lock Timeout Events | |
47 | ![]() |
LOCKWAIT64 | Number of Lock Wait Events | |
48 | ![]() |
LOCKWTPCNT | Lock Wait Events per Lock Requests (ppm) | |
49 | ![]() |
LOGBUFF | Size of each of the three logical log buffers | |
50 | ![]() |
LOGFILES | Number of Log Files | |
51 | ![]() |
LOGSIZ | Size of a single logical log | |
52 | ![]() |
LOGSIZETOT | Total Size of Logical Log (Kb) | |
53 | ![]() |
LONG_TX | Number of Long Transactions (aborted) | |
54 | ![]() |
LRUMAXDIRT | When to begin cleaning LRU queues | |
55 | ![]() |
LRUMINDIRT | When to stop cleaning LRU queues | |
56 | ![]() |
LRUS | Number of LRU queues | |
57 | ![]() |
LRUWRITS64 | Number of lru writes | |
58 | ![]() |
LTXHWM | High watermark percentage | |
59 | ![]() |
MAXPDQPRIO | Max PDQ Priority | |
60 | ![]() |
MAXSORTSPC | Max Sort Space | |
61 | ![]() |
MEMSORTS | Number of Sort Events in Memory | |
62 | ![]() |
NUMCKPTS | Number of checkpoints since database startup | |
63 | ![]() |
NUMCPUVPS | Number of user (CPU) virtual processors | |
64 | ![]() |
OVBUFF | Number of unsuccessful accesses to shared memory buffer | |
65 | ![]() |
PAGES_PC_1 | Percentage of physical log buffer per write | |
66 | ![]() |
PAGES_PC_2 | Percentage of logical log buffer per write | |
67 | ![]() |
PAGREADS64 | Number of Buffer Pages read from Disk | |
68 | ![]() |
PAGWRITS64 | Number of Buffer Pages written to Disk | |
69 | ![]() |
PC_SLEEP | Sleep time for page cleaners | |
70 | ![]() |
PHYSBUFF | Size of the two physical log buffers | |
71 | ![]() |
PHYSFILE | Physical log file size (KB) | |
72 | ![]() |
PLGPGWRI64 | Number of physical log pages written | |
73 | ![]() |
PLGWRITS64 | Number of writes to the physical log | |
74 | ![]() |
RA_COUNT64 | Sum of read ahead pages | |
75 | ![]() |
RA_PAGES | Number of pages to read ahead for sequential or index scans | |
76 | ![]() |
RA_PCNT | Percentage of pages read ahead actually used | |
77 | ![]() |
RA_PERSCAN | Number of sequential scans per read ahead | |
78 | ![]() |
RA_THRESH | Read ahead page trigger | |
79 | ![]() |
RA_USED64 | Read ahead pages used | |
80 | ![]() |
READ_QUALI | Percentage of successful reads from shared memory | |
81 | ![]() |
RESET_STAT | Time since last reset statistics in seconds | |
82 | ![]() |
RES_SHMSIZ | Resident shared menory portion | |
83 | ![]() |
SEQSCANS64 | Number of sequential scans | |
84 | ![]() |
SHMVSEGCNT | Number of Virtual Shared Memory Segments | |
85 | ![]() |
SQLREADLD | Load of SQL read activity: buffer reads / (isreads+isstart) | |
86 | ![]() |
TOT_SHMSIZ | Total size of INFORMIX shared memory | |
87 | ![]() |
UPSINCE | Time since DB start in seconds (Informix monitor) | |
88 | ![]() |
WRITEACTIV | Percentage of Write Activity over Read Activity | |
89 | ![]() |
WRITE_QUAL | Percentage of successful writes for shared memory buffer | |
90 | ![]() |
XMEM_ALLOC | Amount of additional virtual shared memory |