Re: How can we avoid reclustering some indexes ??

> Sorry for misunderstanding, I don't give 60% as general recommendation. > Recommendation is to start from 20% and tune up keeping eye on free memory > cushion, onstat -g seg, swapping, etc. 60% is where I stopped for > particular system I just tuned (7.24, 512M RAM, Fourth Generation > Accounting). %cached reads came from 90-91 to 99+, and (talking of DDS) > reports which took couple hours run for 15 min. The point is - if somebody > is buying 1 Gb of extra RAM to rev up performance, not 200 M should be > added to BUFFERS, but much more, maybe almost everything. If you're running an OLTP environment, yes. DSS, probably not-- you'd likely want that memory going to the virtual segment.