|
[oracle-l]
||
[Date Prev]
[12-2006 Date Index]
[Date Next]
||
[Thread Prev]
[12-2006 Thread Index]
[Thread Next]
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?
--
http://www.freelists.org/webpage/oracle-l
|
|
