Re: 10gR2 Performance sux!
- From: amit poddar <amit.poddar@xxxxxxxx>
- To: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
- Date: Thu, 14 Jun 2007 09:09:03 -0400
Can you set any parameter the way you mentioned ?
If yes than does thatn mean opt_param is not required at all ?
amit
Christian Antognini wrote:
Amit
don't you mean /*+ opt_param('optimizer_features_enabled', '9.0.1') */
?
No. I meant what I wrote, i.e.: /*+ optimizer_features_enable('9.0.1')
*/
Also notice that the name of the parameter in your example is wrong.
There's no "d"...
HTH
Chris
- Follow-Ups:
- Re: 10gR2 Performance sux!
- From: MVR
- References:
- RE: 10gR2 Performance sux!
- From: Christian Antognini
Other related posts:
- » 10gR2 Performance sux!
- » RE: 10gR2 Performance sux!
- » RE: 10gR2 Performance sux!
- » Re: 10gR2 Performance sux!
- » RE: 10gR2 Performance sux!
- » Re: 10gR2 Performance sux!
- » Re: 10gR2 Performance sux!
- » RE: 10gR2 Performance sux!
- » Re: 10gR2 Performance sux!
- » RE: 10gR2 Performance sux!
- » Re: 10gR2 Performance sux!
- » Re: 10gR2 Performance sux!
- » RE: 10gR2 Performance sux!
- » RE: 10gR2 Performance sux!
- » RE: 10gR2 Performance sux!
- » RE: 10gR2 Performance sux!
- » RE: 10gR2 Performance sux!
- » RE: 10gR2 Performance sux!
- » Re: 10gR2 Performance sux!
- » Re: 10gR2 Performance sux!
Amit
don't you mean /*+ opt_param('optimizer_features_enabled', '9.0.1') */
?
No. I meant what I wrote, i.e.: /*+ optimizer_features_enable('9.0.1')
*/
Also notice that the name of the parameter in your example is wrong.
There's no "d"...
HTH
Chris
- Re: 10gR2 Performance sux!
- From: MVR
- RE: 10gR2 Performance sux!
- From: Christian Antognini