Database Memory & 4030/4031 (MOSC)

MOSC Banner

ORA-04031: unable to allocate 4192 bytes of shared memory ("shared pool","unknown object","sga heap(

edited Jul 19, 2010 2:56AM in Database Memory & 4030/4031 (MOSC) 7 commentsAnswered
SQL> insert into  cost values (128696, 155873714, 1, 0.35, 1000, sysdate, sysdate, 1000); insert into  cost values (128696, 155873714, 1, 0.35, 1000, sysdate, sysdate, 1000)
                   *
ERROR at line 1:
ORA-04031: unable to allocate 4192 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","modification ")


while rest of insert statements on other tables works fine....
Just for this table its showing the above error..

DB is 10.2.0.4.0 - 64bit Production

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