Re: Can you execute a function in an Oracle comment/hint?

If nothing works, you could put the table(s) under dbms_rls policy and attach a meaningless predicate that would be different each time it is generated. generate it from a sequence or combination if random text using dbms_random.

e.g.

select blah from t1, t2, where t1.x = t2.x and some_randomstring = some_randomstring <<<< added by policy /

Be warned though these constant predicates _may_ affect cbo behavior.

rjamya

On 5/4/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> I'd like to inject a function that would cause every execution of the
> query to have a different hash value and therefore be hard parsed into its
> own cursor, having its bind variables peeked at to enable proper
> optimization and the most efficient explain plan.
>

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