query tuning
- From: rjamya <rjamya@xxxxxxxxx>
- To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 1 Dec 2006 12:09:15 -0500
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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
