Re: Performance difference between 2 machines

>"To use non-standard block sizes, you must configure sub-caches within the buffer cache >area of the
>SGA memory for all of the non-standard block sizes that you intend to use".

It may be worse than that. If you are DW, you probably are going to be heavily scanning some tables and indices, and you may want to specify they use the recycle buffer pool. I think Daniel may have made a mistake in advising tablespace moves for this case, as you can only use the recycle on what the db considers the primary block size http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch148.htm#REFRN10042 http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:10399270486889 . Maybe 10g is different, I wouldn't know.

jg

--
@home.com is bogus.

http://oxfordblues.blogspot.com/2005/06/at-dolphin-show-we-learned-that-tricks.html