G
George Potemkin
Guest
Dbanalys reports the information that mainly is not stored anywhere. That is why VSTs are not able to substitute dbanalys. Workarounds: 1) Track the changes /after/ dbanalys using _TableStat/_IndexStat. Save the results before every db shutdown; 2) Parse the contents of the object blocks. It's sad that prostrct statistics does no report the block statistics per objects in SAT2; 3) You can almost instantly estimate the number of index levels. It's an indirect and very rough estimation of the table's sizes.
Continue reading...
Continue reading...