Hi,
SQL> select name, value from v$parameter
where name in ('db_cache_size','db_keep_cache_size','db_recycle_cache_size','shared_pool_size') ;
NAME VALUE
------------------------------ --------------------
shared_pool_size 318767104
db_keep_cache_size 0
db_recycle_cache_size 0
db_cache_size 637534208
SQL> alter system set db_keep_cache_size=100M;
alter system set db_keep_cache_size=100M
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00384: Insufficient memory to grow cache
why I'm not able to set the parameter db_keep_cache_size having value 100M.
Regards.
[Updated on: Wed, 02 July 2008 04:51] by Moderator
Report message to a moderator