Database Administration (MOSC)

MOSC Banner

Setting of db_cache_size seems strange...?

edited Apr 10, 2013 4:11AM in Database Administration (MOSC) 11 commentsAnswered
11.2.0.2

Hi,

I got a recommendation from Support to set hard values as we have seen a lot of resize operations.

alter system set memory_target=7G scope=both;

alter system set shared_pool_size=1G scope=both;
alter system set db_cache_size=5000M scope=both;

alter system set db_cache_size = 5000M
alter system set db_cache_size = 5000M
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00384: Insufficient memory to grow cache

I set it at 3500MB.

sho parameter db_c
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_cache_size big integer 16M

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center