Hi,
I need to create a tablespace with non standard block size, (16K)
But when I try to set db_16k_cache_size parameter, I get following
error. I tried smaller values also, but still the same error...
Which all parameters I need to consider while using non standard block size..
I am using O9iR2 WinXP 512MB RAM
ThanksCode:db_cache_size 25165824 db_block_size 8192 SQL> alter system set db_16k_cache_size=12M; alter system set db_16k_cache_size=12M * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-00384: Insufficient memory to grow cache SQL> show sga Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes SQL>
Sameer




Reply With Quote