Re: Can you execute a function in an Oracle comment/hint?
- From: rjamya <rjamya@xxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx
- Date: Fri, 4 May 2007 14:37:36 -0400
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@xxxxxxxxxxx> 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.
Other related posts:
