Previous Topic: D_SQL_SQLCODES (SQQ)Next Topic: D_BUSINESS_VALUE_DETAILS (BVD)


D_BUSINESS_VALUE_METRICS (BVM)

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

D

ELAPSED_SECONDS

DECIMAL

S

D

Y

8

N

1

N

55

D

CPU_SECONDS

DECIMAL

S

D

Y

8

N

1

N

63

D

PHYSICAL_IO

DECIMAL

S

D

Y

8

N

1

N

71

D

DB_REQUESTS

DECIMAL

S

D

Y

8

N

1

N

79

D

LOGICAL_IO

DECIMAL

S

D

Y

8

N

1

N

87

D

TOTAL_REQUESTS

DECIMAL

S

D

Y

8

N

1

N

95

D

TOTAL_READS

DECIMAL

S

D

Y

8

N

1

N

103

D

TOTAL_ADDS

DECIMAL

S

D

Y

8

N

1

N

111

D

TOTAL_DELETES

DECIMAL

S

D

Y

8

N

1

N

119

D

TOTAL_UPDATES

DECIMAL

S

D

Y

8

N

1

N

127

R

REQUESTS_PER_SEC

DECIMAL

S

D

Y

8

N

1

N

135

R

REQUESTS_PER_CPU_SEC

DECIMAL

S

D

Y

8

N

1

N

143

R

REQUESTS_PER_PHYS_IO

DECIMAL

S

D

Y

8

N

1

N

151

U

D_MUF_USERTAG

CHAR

S

C

N

16

N

1

N

159

Primary KEY columns are as follows:

Secondary KEY columns are as follows: