Re: Poor Oracle performance? getting rid of bind variables
Re: Poor Oracle performance? getting rid of bind variables
- Subject: Re: Poor Oracle performance? getting rid of bind variables
- From: Pascal Robert <email@hidden>
- Date: Wed, 22 Aug 2007 11:36:53 -0400
Le 07-08-22 à 11:34, Guido Neitzer a écrit :
On 22.08.2007, at 07:06, Mike Schrag wrote:
Yes, this is REEEALLY important, as you found. It's the same with
Postgresql, too,
Yeah, but there it is really easy to get it to update statistics
automatically with autovacuum which works really well if it is
correctly set up. Not sure about Oracle but as far as I know, there
is a similar thing to autovacuum that looks at how many changes
were done and updates the statistics accordingly.
This thing is :
EXEC dbms_stats.gather_schema_stats(ownname => 'XXXXX',options =>
'GATHER AUTO', cascade => TRUE);
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden