SHARED POOL contents [message #282704] |
Fri, 23 November 2007 02:01 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
I read somewhere
"We should allocate enough space for Library Cache so that Oracle can keep parsed and executable staments in SHARED POOL" .
can someone explain why oracle has to keep this parsed and executable statment in SHARED POOL .Statements are session specific and users will be executing different queries ..then what is the point in keeping these in SHARED POOL .
Regards,
|
|
|
|
|
Re: SHARED POOL contents [message #282727 is a reply to message #282718] |
Fri, 23 November 2007 03:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
It is not necessary but Oracle doesn't know it. It is built to share the statements.
They stay as long as they are used and no space is requested.
Regards
Michel
|
|
|