on 11-19-2013 1:40 PM
Hi Guru's ,
Can any one tell me a report to anlayse all the bad quality index in SAP .
Is there any report for this in SAP .
Thanks,
Pradeep.
Hy you can look up to HW970538.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
another option would be to run a query from sap
"Transaction DBACOCKPIT -- Performance -- Additional Functions -- SQL Command Editor"
SELECT
INDEX_NAME,
NUM_ROWS,
ROWLEN,
LEAVES,
NET_MB,
GROSS_MB,
QUALITY
FROM
( SELECT
SUBSTR(I.INDEX_NAME, 1, 20) INDEX_NAME,
I.NUM_ROWS NUM_ROWS,
SUM(TC.AVG_COL_LEN + 1) + 7 ROWLEN,
I.LEAF_BLOCKS LEAVES,
ROUND((SUM(TC.AVG_COL_LEN + 1) + 7) * I.NUM_ROWS /
1000000, 0) NET_MB,
ROUND(I.LEAF_BLOCKS * (8079 - 23 * NVL(I.INI_TRANS, 2)) *
(1 - NVL(I.PCT_FREE, 10) / 100) / 1000000, 0) GROSS_MB,
ROUND((SUM(TC.AVG_COL_LEN + 1) + 7) * I.NUM_ROWS /
(I.LEAF_BLOCKS * (8079 - 23 * NVL(I.INI_TRANS, 2)) *
(1 - NVL(I.PCT_FREE, 10) / 100)) * 100, 0) QUALITY
FROM
DBA_INDEXES I,
DBA_IND_COLUMNS IC,
DBA_TAB_COLUMNS TC
WHERE
I.INDEX_NAME = IC.INDEX_NAME AND
I.OWNER = IC.INDEX_OWNER AND
TC.TABLE_NAME = IC.TABLE_NAME AND
TC.OWNER = IC.INDEX_OWNER AND
TC.COLUMN_NAME = IC.COLUMN_NAME AND
I.INDEX_TYPE = 'NORMAL' AND
I.LEAF_BLOCKS > 1000
GROUP BY
I.NUM_ROWS,
I.LEAF_BLOCKS,
I.INDEX_NAME,
I.INI_TRANS,
I.PCT_FREE
)
WHERE
QUALITY <= 30
ORDER BY
QUALITY;
and analyze the list
best regards
marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.