Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

creating new Instance with different Block size tablespace

666246Oct 25 2009 — edited Oct 25 2009
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 22 2009
Added on Oct 25 2009
6 comments
1,020 views