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

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


Current Time: Sun Dec 04 08:48:44 CST 2016

Total time taken to generate the page: 0.09497 seconds