RE: Query-rewrite-* params: still required to use FBI's?
Date: Wed, 4 Mar 2009 09:50:37 -0500
Message-ID: <49ae953a.04c2f10a.14d1.0928_at_mx.google.com>
This is excellent follow up. Thank you all. One more case closed.
-----Original Message-----
From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Sent: Wednesday, March 04, 2009 3:38 AM
To: FMHabash <fmhabash_at_gmail.com>
Cc: oracle-l_at_freelists.org
Subject: RE: Query-rewrite-* params: still required to use FBI's?
Hi
Excerpt of page 391 of TOP:
Up to Oracle9i Release 2 patchset 9.2.0.3, in order to create a
function-based index, a user requires
the system privilege query rewrite. In addition, the query optimizer
takes such an index into consideration
only when the initialization parameter query_rewrite_enabled is set to
TRUE and the initialization parameter
query_rewrite_integrity is set to either trusted or stale_tolerated. As
described in MetaLink
note "Bug 2799028" (2799028.8), these requirements are no longer
necessary as of patchset 9.2.0.4.
HTH
Chris Antognini
Troubleshooting Oracle Performance, Apress 2008 http://top.antognini.ch
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 04 2009 - 08:50:37 CST