Update on 07/06/11: Please also watch this video tutorial from
Tanel Poder after you read this article Nowadays, I am working
on performance tuning guide of 10gR2 and I found it is worthy to
write about shared pool management after reading the metalink
note Note:396940.1 Troubleshooting and Diagnosing ORA-4031
Error. Note: This blog entry is my summary of the references at
the bottom and to be honest I wrote this long entry for myself
for not to get lost between those references again Shared pool
is used to cache different types of data such as textual and
executable forms of PL/SQL blocks and SQL statements, dictionary
cache data, and other data. If you use shared pool effectively
you can reduce resource consumption in at least four ways -
Parse overhead is avoided if the SQL statement is already in the
shared pool. This saves CPU resources on the host and elapsed
time for the end user. - Latching resource usage is
significantly reduced, which results in greater scalability. -
Shared pool memory requirements