We are just about to upgrade to 9i and I'm planning to reconfigure the architecture.
With variable block sizes I'm right in assumming that tables where many,many rows are required for certain transactions (say a mass update of a certain column) would benefit from having larger Block Sizes? So I'd put these tables in a TBS with a larger block size than the other smaller transaction tables?

Is there a tried and trusted simple query on the V$views I can run to see if transactions on an object would benefit from a larger block size?