Hi, I am aware of that Oracle supports multi block configuration .... I would like to assign a different block size (16K) for one specific table. I will appreciate if anyone could send me a link to how to configure the same ..... syntax etc?
Regards
Printable View
Hi, I am aware of that Oracle supports multi block configuration .... I would like to assign a different block size (16K) for one specific table. I will appreciate if anyone could send me a link to how to configure the same ..... syntax etc?
Regards
Need to do following before creating table.
1. Create separate 16K buffer (Set parameter db_16k_cache_size )
2. Create separate tablespace with 16K blocksize
3. Create table on tablespace you created with 16K blocksize (you may need to give quota to user in which you are creating table)
Dilipkumar Patel.
Hi,
You want to do this for performance reason or will be moving this tables to other db having 16k blocksize.
Regards,
Satheesh Babu S