on 06-27-2006 7:57 PM
Hi,
I was going over DB02 T-code. I need to know, how to read the <b>missing indexes</b> info. I saw some info that if any indexes supplied by SAP in DDIC is deleted, this error may popup.
Can anyone help me out, to get more detailed info and interpertations of DB02 monitoring.
mail me at bapujeenaidu@gmail.com and I'll send u good docs for database and workload analysis.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
the importart info that you can find on DB02, are:
->space critical obj (ex. no space in tablespace)
->refresh -->dbcheck&update (if is not scheluded in db13)
->check-->db e abap dictionary
->current/statistics/free of tablespace (ex to know the size and history of the tablespace)
About the missing index, this monitor checks possible problems with the db index: if some index will not result, problably the search on db can be veeeery slow (ex. the missing it's possible after a reorg).
Regards
Cristian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.