All Oracle Error CodesOracle DBA Forum

ORA-04031:

unable to allocate string bytes of shared memory ("string","string","string","string")
Cause: More shared memory is needed than was allocated in the shared pool.
Action: If the shared pool is out of memory, either use the dbms_shared_pool package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the INIT.ORA parameters "shared_pool_reserved_size" and "shared_pool_size". If the large pool is out of memory, increase the INIT.ORA parameter "large_pool_size".
 SubjectReplies
1.Why we should use bind variables when we write ...12
2.A VLDB contest10
3.ORA-40318
4.ora-4031 & large_pool8
5.RMAN memory issue7
6.ora-040317
7.problems with memory7
8.gather_stats_job died due to AUTO SGA error6
9.x$kghlu, Steve's shared_pool_lru_stats5
10.Shared pool from 8i to 9i5
11.ORA-04031: unable to allocate 4200 bytes of sha...4
12.relation shared pool elements phys mem4
13.difference between child and parent latches?3
14.ora-4031 & large_pool3
15.Oracle 10 on linux3
16.ora-4031 & large_pool3
17.Wanted - pointers to Good articles on P_A_T2
18.optimizer time reported as?2
19.Top Shared Pool Consumers2
20.ora-040312
21."session param valu" in x$ksmlru2
22.SGA Free memory2
23.Strange 4031 issue.2
24.Streams2
25.ORA-4031 (10.1.0.5 on solaris)2
26.Cursor_sharing=similar.....failed2
27.ora-040311
28.Shared pool from 8i to 9i1
29.Shared pool from 8i to 9i1
30.ORa-4030 on 9.2.0.51