Home » RDBMS Server » Performance Tuning » SHARED POOL contents
SHARED POOL contents [message #282704] Fri, 23 November 2007 02:01 Go to next message
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 #282705 is a reply to message #282704] Fri, 23 November 2007 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Statements (texts) are shared among all sessions.

Regards
Michel
Re: SHARED POOL contents [message #282718 is a reply to message #282704] Fri, 23 November 2007 02:56 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
But it is not necessary to use same query by other users right?
Also how long these statements can be in Cache ?
Re: SHARED POOL contents [message #282727 is a reply to message #282718] Fri, 23 November 2007 03:15 Go to previous message
Michel Cadot
Messages: 64098
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
Previous Topic: Similar SQLs : Index Usage/Non-usage
Next Topic: recovery of drop table
Goto Forum:
  


Current Time: Fri Dec 02 12:03:17 CST 2016

Total time taken to generate the page: 0.16829 seconds