Did you get anything in the "Recommendations" or
"Restructure" section ?
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 2nd
"Christian Antognini" <christian.antognini_at_trivadis.com> wrote in message
news:41373f3b_at_post.usenet.com...
> **** Post for FREE via your newsreader at post.usenet.com ****
>
> Hello
>
> I'm testing SQL profiles on a 10g Enterprise Edition 10.1.0.3.0 running on
> SLES8-SP3.
> All tests are performed in SQL*Plus via the PL/SQL API, i.e. I use no
> Grid/Database Control for them.
>
> When a SQL profile is generated and I accept it, everything works fine.
>
> But, for a specific query, no SQL profile is proposed even if cardinality
> estimations are bad. Unfortunately I didn't find the possibility to force
> DBMS_SQLTUNE to generate a SQL profile.
>
> It is really not possible to force the generation of a SQL profile? Did
> somebody have the same problem or did a similar observation?
>
> Thanks a lot of any tip and have lot of fun with Oracle!
>
> Chris
>
>
Received on Thu Sep 02 2004 - 15:23:33 CDT
