Previous Topic: S_MUF_SRB_ZIIP (MZI)Next Topic: S_MUF_TABLE_STATS (MFT)


S_MUF_SYSTEM_STATS (MFS)

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: