I havent played around with the 10053 trace. No time. I was hoping for something simple at the db level. i mean i put in a hint and the plan doesnt change. oracle can choose to ignore hints. thanks anyway. > > From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx> > Date: 2004/02/06 Fri PM 12:30:50 EST > To: oracle-l@xxxxxxxxxxxxx > Subject: Re: Re: how to get oracle to ignore an index > > On 02/06/2004 12:25:29 PM, ryan.gaffuri@xxxxxxx wrote: > > i forgot to mention, oracle is ignoring all hints in this case. Sorry > > about that. anything at the database level? > > > > > > How can oracle "ignore all hints"? Have you tried with the event 10053? > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------