Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Out of memory

JellySep 28 2024

I created two databases on one server,db version:9.2.0.7.0

Red Hat Enterprise Linux AS release 4 x86_64 GNU/Linux

memory:16G

linux server sysctl.conf

kernel.core_uses_pid = 1
kernel.shmmax=8589934592
kernel.shmmni=4096
kernel.shmall=4194304
kernel.sem=250 32000 100 128

DB1:

sga_max_size 4297038336

shared_pool_size 570425344
db_cache_size 1677721600

DB2:

sga_max_size 8601448992
shared_pool_size 1073741824
db_cache_size 2147483648

DB1 sometimes appears the message:out of memory

How should I modify the parameters or increase the memory?

Comments
Post Details
Added on Sep 28 2024
0 comments
70 views