creating new Instance with different Block size tablespace
666246Oct 25 2009 — edited Oct 25 2009Hi,
I am using Oracle 11g (11.1.0.6.0-Production standard edition), default data block size = 8192 bytes.
I have performed some testing to check 'query execution time' after creating 3 different block size tablespaces.
First tablespace is default with 8k block size. Second one is with 4k and Third with 16k block size. I've set db_cache_size for these non-standard block sizes (4k and 16k). There are around 40 tables in each tablespaces.
I have observed very closely that in all the three cases results are same. I don't know why.
Now I want to create another Instance with these non-standard block sizes, let's say with 4k block size tablespace.
How can I create a new Instance with a tablespace of 4k so that I can shift between the instances and see the difference?
I'll appreciate the valuable suggestions.
Thanks.
Regards,
KAM