Re: Poor performance after oracle 8i upgrade

rreeve_at_goldcoast.qld.gov.au (Ruth) wrote in message news:<7d088242.0409071533.7aecc8f0_at_posting.google.com>...
> Hi all,
>
> Thanks for your responses. I forward them on to the DBA's and this is
> their reply :)
>
> regards
> Ruth
>
> 272,336 90,685 3.0 11.7 1786727592
> SELECT /*+ INDEX_ASC (ANL_ENTITY iANL_ENTITY_0) Index Hint */ ae
> _application_no, ae_entity_number, ae_animal_type, ae_tariff, ae
> _breed, ae_second_breed, ae_sex, ae_description, ae_name, ae_bal
> ance, ae_other_id_type, ae_other_id, ae_other_date, ae_microchip
> _id, ae_microchip_date, ae_exempt, ae_exempt_status, ae_nusiance
>
>
> 272,259 90,685 3.0 11.7 3296768686
> SELECT /*+ INDEX_ASC (ANL_APPLIC iANL_APPLIC_0) Index Hint */ aa
> _applic_number, aa_pension_concession, aa_contact_type, aa_conta
> ct_entity, aa_status, aa_status_ymd, aa_creation_ymd, aa_modifie
> d_ymd ,rowid FROM ANL_APPLIC WHERE ( AA_APPLIC_NUMBER > :w0 )
> ORDER BY AA_APPLIC_NUMBER ASC
>
>
> Jacek

What is meant by "In Oracle 8.1.7 you can't force Oracle Optimizer to ignore SQL hints. This option is in Oracle 9i."

If the DBA's have somehow disabled the use of hints then since the SQL is hinted the CBO is not running the SQL as the hints dictate. That would be a definite possible cause of the problem.

HTH -- Mark D Powell -- Received on Thu Sep 09 2004 - 16:24:23 CEST