Originally posted by ljayanth
Hi hacketta1,

Ur setup is gud. set db_file_multiblock_read_count to 16 as 89 is default. but having all the data in one datafile is bad idea.
did u segregate the index, rollback segments and temp segments into other TS?? if not its again a bad practice. need not worry abt number of segments as u have db_block_size as 8K, cos 8K is less very size.

Did i asnwer ur question?
Jayanth

hmmm where did you get that 89 from....?!

and no, there is no need to seperate index and data in different tablespaces unless you want to do that for administration purposes