|
ID |
SQL NAME |
SQL TYPE |
CL |
TY |
SI |
LE |
NU |
RE |
RD |
DI |
|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
I |
D_MUF_ENABLE |
SQL-STMP |
S |
B |
N |
10 |
N |
1 |
N |
0 |
|
IS |
D_MUF_START_DATETIME |
SQL-STMP |
S |
B |
N |
10 |
N |
1 |
N |
10 |
|
I |
D_MUF_END_DATETIME |
SQL-STMP |
S |
B |
N |
10 |
N |
1 |
N |
20 |
|
I |
D_MUF_TYPE |
CHAR |
S |
C |
N |
10 |
N |
1 |
N |
30 |
|
I |
D_MUF_TOTALROW |
CHAR |
S |
C |
N |
1 |
N |
1 |
N |
40 |
|
D |
D_MUF_DURATION |
DECIMAL |
S |
D |
Y |
6 |
N |
1 |
N |
41 |
|
L |
MUF_NAME |
CHAR |
S |
C |
N |
8 |
N |
1 |
N |
47 |
|
L |
BEGIN_TIME |
SQL-STMP |
S |
B |
N |
10 |
N |
1 |
N |
55 |
|
L |
CURRENT_DATETIME |
SQL-STMP |
S |
B |
N |
10 |
N |
1 |
N |
65 |
|
D |
CURRENT_CPU |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
75 |
|
D |
RQ_PENDING_1_10 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
83 |
|
D |
RQ_PENDING_11_20 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
91 |
|
D |
RQ_PENDING_21_30 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
99 |
|
D |
RQ_PENDING_31_40 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
107 |
|
D |
RQ_PENDING_41_50 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
115 |
|
D |
RQ_PENDING_51_60 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
123 |
|
D |
RQ_PENDING_61_70 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
131 |
|
D |
RQ_PENDING_71_80 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
139 |
|
D |
RQ_PENDING_81_90 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
147 |
|
D |
RQ_PENDING_91_100 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
155 |
|
D |
RQ_PENDING_GT_100 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
163 |
|
D |
DB_REQUESTS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
171 |
|
D |
SQL_REQUESTS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
179 |
|
D |
DATA_MGR_REQUESTS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
187 |
|
D |
PHYSICAL_READS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
195 |
|
D |
PHYSICAL_WRITES |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
203 |
|
D |
RECORD_LOCKS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
211 |
|
D |
WAIT_LOCK |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
219 |
|
D |
KEY_ELEMENT_REORG |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
227 |
|
D |
NO_IXX_BUFFER |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
235 |
|
D |
NO_DXX_BUFFER |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
243 |
|
D |
NO_DATA_BUFFER |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
251 |
|
D |
NO_EXPAND_BUFFER |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
259 |
|
D |
IXX_SEQUENCE |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
267 |
|
D |
DXX_SEQUENCE |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
275 |
|
D |
DATA_SEQUENCE |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
283 |
|
D |
EXPAND_SEQUENCE |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
291 |
|
D |
IXX_USED_1 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
299 |
|
D |
IXX_USED_2 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
307 |
|
D |
IXX_USED_3 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
315 |
|
D |
IXX_USED_4 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
323 |
|
D |
IXX_USED_5 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
331 |
|
D |
DXX_USED_1 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
339 |
|
D |
DXX_USED_2 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
347 |
|
D |
DXX_USED_3 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
355 |
|
D |
DXX_USED_4 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
363 |
|
D |
DXX_USED_5 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
371 |
|
D |
DATA_USED_1 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
379 |
|
D |
DATA_USED_2 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
387 |
|
D |
DATA_USED_3 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
395 |
|
D |
DATA_USED_4 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
403 |
|
D |
DATA_USED_5 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
411 |
|
D |
SEQ_READ_AHEAD |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
419 |
|
L |
LOG_PERCENT_FULL |
INTEGER |
S |
B |
Y |
4 |
N |
1 |
N |
427 |
|
D |
SECONDARY_CONFLICT |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
431 |
|
D |
WAIT_TASK |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
439 |
|
D |
WAIT_REQUEST |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
447 |
|
D |
WAIT_SPILL |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
455 |
|
D |
WAIT_ACCOUNTING |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
463 |
|
D |
WAIT_SECURITY |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
471 |
|
D |
INDEX_Q_PROCESSED |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
479 |
|
D |
INDEX_Q_OVERFLOW |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
487 |
|
D |
SPLIT_IXX |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
495 |
|
D |
SPLIT_DXX |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
503 |
|
D |
DELETED_BLOCKS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
511 |
|
D |
CBS_SPILLS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
519 |
|
L |
CBS_ENTRIES |
INTEGER |
S |
B |
Y |
4 |
N |
1 |
N |
527 |
|
L |
CBS_ENTRIES_USED |
INTEGER |
S |
B |
Y |
4 |
N |
1 |
N |
531 |
|
D |
SETS_PROCESSED |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
535 |
|
D |
SETS_WITH_T_INDEX |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
543 |
|
D |
TEMP_INDEX_ENTRIES |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
551 |
|
D |
CBS_MEMORY_ALLOCS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
559 |
|
D |
LOGPEND_WRITES |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
567 |
|
L |
DATASECURE_ONE |
INTEGER |
S |
B |
Y |
4 |
N |
1 |
N |
575 |
|
L |
DATASECURE_TWO |
INTEGER |
S |
B |
Y |
4 |
N |
1 |
N |
579 |
|
D |
REEXPANDS |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
583 |
|
D |
NO_TXB_BUFFER |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
591 |
|
D |
INDIRECT_WAIT_IO |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
599 |
|
D |
LOG_WRITE_CONTROL |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
607 |
|
D |
LOG_WRITE_FULL |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
615 |
|
D |
LOG_WRITE_COMMAND |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
623 |
|
D |
LOG_WRITE_OTHER |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
631 |
|
D |
LOG_WRITE_TXB |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
639 |
|
D |
LOG_WRITE_2_PHASE |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
647 |
|
D |
DATA2_USED_1 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
655 |
|
D |
DATA2_USED_2 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
663 |
|
D |
DATA2_USED_3 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
671 |
|
D |
DATA2_USED_4 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
679 |
|
D |
DATA2_USED_5 |
DECIMAL |
S |
D |
Y |
8 |
N |
1 |
N |
687 |
|
U |
D_MUF_USERTAG |
CHAR |
S |
C |
N |
16 |
N |
1 |
N |
695 |
Primary KEY columns are as follows:
Secondary KEY columns are as follows:
|
Copyright © 2014 CA.
All rights reserved.
|
|