Home » RDBMS Server » Performance Tuning » shared pool
shared pool [message #247206] Mon, 25 June 2007 01:16 Go to next message
Messages: 69
Registered: January 2007
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: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"executions" means executions, parses is in "parse_calls".

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

Current Time: Tue Oct 25 00:20:02 CDT 2016

Total time taken to generate the page: 0.12812 seconds