Home » RDBMS Server » Server Administration » Setting db_keep_cache_size (9.2.0.7, HP -UX)
Setting db_keep_cache_size [message #331056] Wed, 02 July 2008 04:19 Go to previous message
nazbrian
Messages: 36
Registered: July 2008
Member
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

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: FRA & DIAG (CM merged 2)
Next Topic: Question about - Implement Oracle RAC
Goto Forum:
  


Current Time: Fri Mar 29 07:57:21 CDT 2024