Total amount of system memory

[Steven E. Protter]

Shalom again:

One more thing as dbc_max_pct was set to 10 it was 100% utilized so I have changed the value of dbc_max_pct to 25. Please

That uses a lot of space for the buffer pool.

I normally use 5 and 7 (max) on an Oracle based system. For 11.11 and below buffer pool increase does not help with Oracle performance anyway.

Changing the buffer pool is extremely expensive for a system in terms of performance. Having those numbers so far apart is bad for overall systems performance.

SEP

[panks]

Thanks Steve!! So you mean I should revert back the value of dbc_mac_pct to 10%. One more question is this parameter only responsible for oracle. And is going to create any problem if utilization of dbc_max_pct is continously at 100% because user has already faced a problem one time and their entire oracle instance hung.

[panks]

Ok I have reduced the value of dbc_max_pct now but still the buf cache is at same value.

[Dennis Handly]

>I have reduced the value of dbc_max_pct now but still the buf cache is at same value.

Which? Size or percent? For the former, it may take some time to reduce it.

[Javed Khan_1]

Also check with dba if kernel tuning is correct with respect to the oracle version running on your system , or may be they need to so some performance tuning at db end

[panks]

What does that mean, do you mean to say if there is not proper tuning at DBA end then system memory will consume more.
Is there any way by which I can cut down the usage of this big amount of system memory and free up it for the use of user processes.

Thanks

[Javed Khan_1]

please paste the output of glance/top showing process based memory utilization