Database Administration (MOSC)

MOSC Banner

ORA-04031

edited Feb 5, 2018 4:03AM in Database Administration (MOSC) 1 commentAnswered

Hello,

I am getting the error ORA-04031 Cannot allocate 376 Byte des Shared Memorys

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

ORACLE_HOME = /opt/oracle/product/12.1.0.2.0

System name:    Linux

Node name:    node1

Release:    2.6.32-642.3.1.el6.x86_64

Version:    #1 SMP Sun Jun 26 18:16:44 EDT 2016

Machine:    x86_64

sga_max_size 9632M

sga_target  9632M

shared_pool_reserved_size 72142028

shared-pool_size 0

Question: what can be done to better investigate / resolve this problems (it happens already 2 times.)

Thank you

regards

......

<txt>Archived Log entry 165424 added for thread 1 sequence 163162 ID 0x3816ca45 dest 1:

</txt>

</msg>

Tagged:

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