D
Dmitri Levin
Guest
Do not compare the size using promon. Since you did dbanalys on both hp-ux and linux databases, compare those sizes. They should match a little better. And new database on linux should be smaller. All indexes were compacted ( rebuilt ). The unique indexes could shrink several times, I have seen 25:1 ratio index shrink after big table purge. It is actually very much recommended to do idxcompact after a purge. You could also have big RM chains in old database, that was taken care during D&L. And finally compare the speed that dbanalys took on hp-ux vs linux. I bet it was much faster on new db. And thus database will work faster too.
Continue reading...
Continue reading...