|
SQL NAME |
SQL TYPE |
CLS |
TYP |
SGN |
LNG |
NUL |
REP |
RDF |
DSP |
|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
S_MUF_ENABLE |
SQL-STMP |
S |
B |
N |
10 |
N |
1 |
N |
0 |
|
S_MUF_DATETIME |
SQL-STMP |
S |
B |
N |
10 |
N |
1 |
N |
10 |
|
S_MUF_TOTALROW |
CHAR |
S |
C |
N |
1 |
N |
1 |
N |
20 |
|
MUF_NAME |
CHAR |
S |
C |
N |
8 |
N |
1 |
N |
21 |
|
BEGIN_TIME |
SQL-STMP |
S |
B |
N |
10 |
N |
1 |
N |
29 |
|
CURRENT_DATETIME |
SQL-STMP |
S |
B |
N |
10 |
N |
1 |
N |
39 |
|
CURRENT_CPU |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
49 |
|
RQ_PENDING_1_10 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
57 |
|
RQ_PENDING_11_20 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
65 |
|
RQ_PENDING_21_30 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
73 |
|
RQ_PENDING_31_40 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
81 |
|
RQ_PENDING_41_50 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
89 |
|
RQ_PENDING_51_60 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
97 |
|
RQ_PENDING_61_70 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
105 |
|
RQ_PENDING_71_80 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
113 |
|
RQ_PENDING_81_90 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
121 |
|
RQ_PENDING_91_100 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
129 |
|
RQ_PENDING_GT_100 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
137 |
|
DB_REQUESTS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
145 |
|
SQL_REQUESTS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
153 |
|
DATA_MGR_REQUESTS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
161 |
|
PHYSICAL_READS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
169 |
|
PHYSICAL_WRITES |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
177 |
|
RECORD_LOCKS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
185 |
|
WAIT_LOCK |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
193 |
|
KEY_ELEMENT_REORG |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
201 |
|
NO_IXX_BUFFER |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
209 |
|
NO_DXX_BUFFER |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
217 |
|
NO_DATA_BUFFER |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
225 |
|
NO_EXPAND_BUFFER |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
233 |
|
IXX_SEQUENCE |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
241 |
|
DXX_SEQUENCE |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
249 |
|
DATA_SEQUENCE |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
257 |
|
EXPAND_SEQUENCE |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
265 |
|
IXX_USED_1 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
273 |
|
IXX_USED_2 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
281 |
|
IXX_USED_3 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
289 |
|
IXX_USED_4 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
297 |
|
IXX_USED_5 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
305 |
|
DXX_USED_1 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
313 |
|
DXX_USED_2 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
321 |
|
DXX_USED_3 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
329 |
|
DXX_USED_4 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
337 |
|
DXX_USED_5 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
345 |
|
DATA_USED_1 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
353 |
|
DATA_USED_2 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
361 |
|
DATA_USED_3 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
369 |
|
DATA_USED_4 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
377 |
|
DATA_USED_5 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
385 |
|
SEQ_READ_AHEAD |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
393 |
|
LOG_PERCENT_FULL |
INTEGER |
S |
B |
Y |
4 |
N |
1 |
N |
401 |
|
SECONDARY_CONFLICT |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
405 |
|
WAIT_TASK |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
413 |
|
WAIT_REQUEST |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
421 |
|
WAIT_SPILL |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
429 |
|
WAIT_ACCOUNTING |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
437 |
|
WAIT_SECURITY |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
445 |
|
INDEX_Q_PROCESSED |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
453 |
|
INDEX_Q_OVERFLOW |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
461 |
|
SPLIT_IXX |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
469 |
|
SPLIT_DXX |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
477 |
|
DELETED_BLOCKS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
485 |
|
CBS_SPILLS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
493 |
|
CBS_ENTRIES |
INTEGER |
S |
B |
Y |
4 |
N |
1 |
N |
501 |
|
CBS_ENTRIES_USED |
INTEGER |
S |
B |
Y |
4 |
N |
1 |
N |
505 |
|
SETS_PROCESSED |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
509 |
|
SETS_WITH_T_INDEX |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
517 |
|
TEMP_INDEX_ENTRIES |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
525 |
|
CBS_MEMORY_ALLOCS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
533 |
|
LOGPEND_WRITES |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
541 |
|
DATASECURE_ONE |
INTEGER |
S |
B |
Y |
4 |
N |
1 |
N |
549 |
|
DATASECURE_TWO |
INTEGER |
S |
B |
Y |
4 |
N |
1 |
N |
553 |
|
REEXPANDS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
557 |
|
NO_TXB_BUFFER |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
565 |
|
INDIRECT_WAIT_IO |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
573 |
|
LOG_WRITE_CONTROL |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
581 |
|
LOG_WRITE_FULL |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
589 |
|
LOG_WRITE_COMMAND |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
597 |
|
LOG_WRITE_OTHER |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
605 |
|
LOG_WRITE_TXB |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
613 |
|
LOG_WRITE_2_PHASE |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
621 |
|
DATA2_USED_1 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
629 |
|
DATA2_USED_2 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
637 |
|
DATA2_USED_3 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
645 |
|
DATA2_USED_4 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
653 |
|
DATA2_USED_5 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
661 |
Primary KEY columns are as follows:
Secondary KEY columns are as follows:
|
Copyright © 2014 CA.
All rights reserved.
|
|