Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-4031
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 = 8000000sort_area_size = 2000000
Thank you for your help in advance,
Kader
![]() |
![]() |