Previous Topic: D_MUF_SRB_ZIIP (MZI)Next Topic: D_MUF_TABLE_STATS (MFT)


D_MUF_SYSTEM_STATS (MFS)

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: