Home » RDBMS Server » Performance Tuning » shared pool
shared pool [message #247206] Mon, 25 June 2007 01:16 Go to next message
sajut
Messages: 69
Registered: January 2007
Member
I have few questions regarding the reuse of queries in our application. A look at v$sql for a particular query shows the number of executions varying at different times. Does this means that this particular query is parsed again, (we use bind variables). Do I need to increase the shared pool size
Any help welcome

Report message to a moderator

Re: shared pool [message #247213 is a reply to message #247206] Mon, 25 June 2007 01:39 Go to previous message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"executions" means executions, parses is in "parse_calls".

Regards
Michel

Report message to a moderator

Previous Topic: 10.1 much slower than 10.2? help!
Next Topic: Finally moving to LMT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 23:47:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.