-
Hi: In Oracle 9i my machine has enough memory(vmstat 5)
and I execute "alter system set db_cache_size=128M scope=both;" the error is "ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00384: Insufficient memory to grow cache"
the parameter sga_max_size is very large can not be exceed? what is the error? Thanks !!!
-
Did you see the parameter db_block_buffers in the init.ora ???
-
Take care that u are not trying to exceed the sga_max_size. Verify u'r sga_max_size.
Execute the same statement with lesser value for db_cache_size that is below sga_max_size. That should work.
Cheers.
