Re: function based index and DB - startupparameters

fuxs <me_at_privacy.net> wrote in message news:<oprwdegio9ldvfnp_at_news.individual.de>...
> On Wed, 01 Oct 2003 21:36:22 +1000, Howard J. Rogers
> <howardjr2000_at_yahoo.com.au> wrote:
>
> > fuxs wrote:
> >
> >> ORA SQL - Ref for 9i Release 2 advises to set two startup - paramerters
> >> to
> >> work with function based indexes:
> >>
> >> <quote>
> >> In addition, in order for Oracle to use
> >> function-based indexes in queries, the QUERY_REWRITE_ENABLED parameter
> >> must be set to TRUE, and the QUERY_REWRITE_INTEGRITY parameter must be
> >> set
> >> to TRUSTED.
> >> </quote>
> >>
> >> Is it really necessary to set QUERY_REWRITE_INTEGRITY to TRUSTED? I'd
> >> like
> >> staying with 'ENFORCED'.
> >>
> >
> > It's necessary, unfortunately. It's a well-known issue that the setting
> > you
> > want for function-based index use conflicts with what you may well want
> > for
> > the use of (say) materialized views.
> >
> > Jonathan Lewis mentions it in his practical Oracle 8i book, amongst other
> > sources.
> >
> > Regards
> > HJR
>
> Thank you for your quick response!
> Within a test - scenario (ORA 9.2.0.3 on W2K Srv SP4) a function based
> index is used for according selects, even though
> 'QUERY_REWRITE_INTEGRITY=ENFORCED' is used. What do I miss?

your xdb listener is vulnerable.
apply the 9.2.0.4 patchset, or comment out the XDB listener.

that is all.

Pd

"There is no privacy. Get over it".
- Scott McNealy Received on Wed Oct 01 2003 - 23:47:36 CDT