ORA-4031

From: Kader Ben <kaderb_at_yahoo.com>
Date: Tue, 5 Sep 2000 13:31:19 -0700 (PDT)
Message-Id: <10610.116246@fatcity.com>

Hi friends,
I have a perl script that load file content into a table, since this morning I am facing with the following error:

FATAL ERROR: (DBD::Oracle::db do failed: ORA-04031: unable to allocate 52 bytes of shared memory ("shared pool","insert into grille values ('...","sql area","strdef : prsstr") (DBD ERROR: OCIStmtExecute) at infinit.pm line 123, <FILE> chunk 1.
)

I have increased the shared_pool-size and parameter in init.ora and I still running the same problem. I don't know what I can do else ;)

This is fragment from my init.ora:

shared_pool_size = 36000000
shared_pool_reserved_size = 160000000
shared_pool_reserved_min_alloc = 8000000

sort_area_size = 2000000

Thank you for your help in advance,

Kader

Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere! Received on Tue Sep 05 2000 - 15:31:19 CDT