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,

Report message to a moderator

- 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: 68757
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Statements (texts) are shared among all sessions.

Regards
Michel

Report message to a moderator

- 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 ?

Report message to a moderator

- 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: 68757
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

Report message to a moderator

Previous Topic: Similar SQLs : Index Usage/Non-usage
Next Topic: recovery of drop table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 28 07:19:41 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.