| SHARED POOL contents [message #282704] |
Fri, 23 November 2007 02:01  |
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  |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
