query tuning

From: rjamya <rjamya_at_gmail.com>
Date: Fri, 1 Dec 2006 12:09:15 -0500
Message-ID: <9177895d0612010909j351fbde1i8da750d74fd94e35@mail.gmail.com>

Has anyone figured out a tried and true solution to tune this query issued by sqlplus

SELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS
WHERE (UPPER(:"SYS_B_0") UPPER(PRODUCT)) AND (UPPER(USER) = USERID) /

I tried a FBI on upper(product) and upper(user) but no avail, due to like clause it prefers to do a FTS.

db is 9204
TIA
rjamya

---

Got RAC?

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 01 2006 - 11:09:15 CST