-
Ora-04031
Hi Guys,
When I am trying to execute a PL/SQL script in my DB I am getting the following error
ORA-04031-Unable to allocate 4096 bytes of shared memory ( "Shared pool" "BAMIMA Bam buffer" )
I guess that there is not enough free memory in shared pool. we need to increase the shared_pool_size.What do u guys suggest?
Oracle - 8.1.7
OS -Sun Solaris
Regards
Joe
-
Hi
Hi
1. Restart your database and run the PL/SQL procedure
or
2. Run the statement " ALTER SYSTEM FLUSH SHARED_POOL;" and run the PL/SQL procedure
If dosen't work after wards, it seems to be a bug. Please post the minor version of the database, ie 8.1.7.xxx.. The value of xxx?
Thanks
Thomas
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|