D_BUSINESS_VALUE_DETAILS (BVD)

AutoCollect DELTA Database › Delta Tables › D_BUSINESS_VALUE_DETAILS (BVD)

D_BUSINESS_VALUE_DETAILS (BVD)

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	DB_REQUESTS	DECIMAL	S	D	Y	8	N	1	N	71
D	DATA_MGR_REQUESTS	DECIMAL	S	D	Y	8	N	1	N	79
D	REL_MGR_REQUESTS	DECIMAL	S	D	Y	8	N	1	N	87
D	SQL_REQUESTS	DECIMAL	S	D	Y	8	N	1	N	95
D	REL_SQL_REQUESTS	DECIMAL	S	D	Y	8	N	1	N	103
D	PHYSICAL_IO	DECIMAL	S	D	Y	8	N	1	N	111
D	PHYSICAL_READS	DECIMAL	S	D	Y	8	N	1	N	119
D	REL_PHYS_READS	DECIMAL	S	D	Y	8	N	1	N	127
D	PHYSICAL_WRITES	DECIMAL	S	D	Y	8	N	1	N	135
D	REL_PHYS_WRITES	DECIMAL	S	D	Y	8	N	1	N	143
D	SEQ_READ_AHEAD	DECIMAL	S	D	Y	8	N	1	N	151
D	REL_SEQ_READ_AHEAD	DECIMAL	S	D	Y	8	N	1	N	159
D	ACCOUNTING_IO	DECIMAL	S	D	Y	8	N	1	N	167
D	REL_ACCOUNTING_IO	DECIMAL	S	D	Y	8	N	1	N	175
D	LOGGING_IO	DECIMAL	S	D	Y	8	N	1	N	183
D	REL_LOGGING_IO	DECIMAL	S	D	Y	8	N	1	N	191
D	IXX_USED_5	DECIMAL	S	D	Y	8	N	1	N	199
R	IXX_RATIO_5_TO_1	DECIMAL	S	D	Y	8	N	1	N	207
D	DXX_USED_5	DECIMAL	S	D	Y	8	N	1	N	215
R	DXX_RATIO_5_TO_1	DECIMAL	S	D	Y	8	N	1	N	223
D	DATA_USED_5	DECIMAL	S	D	Y	8	N	1	N	231
R	DATA_RATIO_5_TO_1	DECIMAL	S	D	Y	8	N	1	N	239
D	DATA2_USED_5	DECIMAL	S	D	Y	8	N	1	N	247
R	DATA2_RATIO_5_TO_1	DECIMAL	S	D	Y	8	N	1	N	255
D	NO_IXX_BUFFER	DECIMAL	S	D	Y	8	N	1	N	263
D	NO_DXX_BUFFER	DECIMAL	S	D	Y	8	N	1	N	271
D	NO_DATA_BUFFER	DECIMAL	S	D	Y	8	N	1	N	279
D	NO_EXPAND_BUFFER	DECIMAL	S	D	Y	8	N	1	N	287
D	NO_TXB_BUFFER	DECIMAL	S	D	Y	8	N	1	N	295
L	MEMORY_SIZE_V	DECIMAL	S	D	Y	8	N	1	N	303
D	MRDF_READS_V	DECIMAL	S	D	Y	8	N	1	N	311
D	REL_VIRTUAL_READS	DECIMAL	S	D	Y	8	N	1	N	319
D	VIRTUAL_WRITES	DECIMAL	S	D	Y	8	N	1	N	327
D	REL_VIRTUAL_WRITES	DECIMAL	S	D	Y	8	N	1	N	335
L	MEMORY_SIZE_C	DECIMAL	S	D	Y	8	N	1	N	343
D	MRDF_READS_C	DECIMAL	S	D	Y	8	N	1	N	351
D	REL_COVERED_READS	DECIMAL	S	D	Y	8	N	1	N	359
D	RECORD_LOCKS	DECIMAL	S	D	Y	8	N	1	N	367
D	WAIT_LOCK	DECIMAL	S	D	Y	8	N	1	N	375
D	REL_WAIT_LOCK	DECIMAL	S	D	Y	8	N	1	N	383
D	SECONDARY_CONFLICT	DECIMAL	S	D	Y	8	N	1	N	391
D	REL_SEC_CONFLICT	DECIMAL	S	D	Y	8	N	1	N	399
D	INDIRECT_WAIT_IO	DECIMAL	S	D	Y	8	N	1	N	407
D	WAIT_TASK	DECIMAL	S	D	Y	8	N	1	N	415
D	WAIT_REQUEST	DECIMAL	S	D	Y	8	N	1	N	423
D	WAIT_SPILL	DECIMAL	S	D	Y	8	N	1	N	431
D	WAIT_ACCOUNTING	DECIMAL	S	D	Y	8	N	1	N	439
D	WAIT_SECURITY	DECIMAL	S	D	Y	8	N	1	N	447
D	DB_CODE_COUNT	DECIMAL	S	D	Y	8	N	1	N	455
D	SQL_CODE_COUNT	DECIMAL	S	D	Y	8	N	1	N	463
D	INDEX_Q_OVERFLOW	DECIMAL	S	D	Y	8	N	1	N	471
D	IO_MEM_SHORT	DECIMAL	S	D	Y	8	N	1	N	479
L	LOG_PERCENT_FULL	DECIMAL	S	D	Y	8	N	1	N	487
D	LOGPEND_WRITES	DECIMAL	S	D	Y	8	N	1	N	495
D	LOG_WRITE_CONTROL	DECIMAL	S	D	Y	8	N	1	N	503
D	LOG_WRITE_FULL	DECIMAL	S	D	Y	8	N	1	N	511
D	LOG_WRITE_COMMAND	DECIMAL	S	D	Y	8	N	1	N	519
D	LOG_WRITE_OTHER	DECIMAL	S	D	Y	8	N	1	N	527
D	LOG_WRITE_TXB	DECIMAL	S	D	Y	8	N	1	N	535
D	LOG_WRITE_2_PHASE	DECIMAL	S	D	Y	8	N	1	N	543
D	CBS_SPILLS	DECIMAL	S	D	Y	8	N	1	N	551
L	CBS_ENTRIES	DECIMAL	S	D	Y	8	N	1	N	559
L	CBS_ENTRIES_USED	DECIMAL	S	D	Y	8	N	1	N	567
D	SETS_PROCESSED	DECIMAL	S	D	Y	8	N	1	N	575
D	SETS_WITH_T_INDEX	DECIMAL	S	D	Y	8	N	1	N	583
D	TEMP_INDEX_ENTRIES	DECIMAL	S	D	Y	8	N	1	N	591
D	BREAKS_DONE	DECIMAL	S	D	Y	8	N	1	N	599
D	RQ_PENDING_1_10	DECIMAL	S	D	Y	8	N	1	N	607
D	RQ_PENDING_11_20	DECIMAL	S	D	Y	8	N	1	N	615
D	RQ_PENDING_21_30	DECIMAL	S	D	Y	8	N	1	N	623
D	RQ_PENDING_31_40	DECIMAL	S	D	Y	8	N	1	N	631
D	RQ_PENDING_41_50	DECIMAL	S	D	Y	8	N	1	N	639
D	RQ_PENDING_GT_50	DECIMAL	S	D	Y	8	N	1	N	647
U	D_MUF_USERTAG	CHAR	S	C	N	16	N	1	N	655

Primary KEY columns are as follows:

MUF_NAME
D_MUF_ENABLE
D_MUF_END_DATETIME
D_MUF_TYPE
D_MUF_USERTAG
D_MUF_START_DATETIME

Secondary KEY columns are as follows:

MUF_NAME
D_MUF_ENABLE
D_MUF_END_DATETIME
D_MUF_TYPE
D_MUF_USERTAG
D_MUF_START_DATETIME
D_MUF_DURATION

Copyright © 2014 CA. All rights reserved.