Re: FGAC predicate - problem with plan/execution time

dnh wrote:
>
> Hi
>
> I am currently using the fgac functionality to limit users view of data. I
> am having a problem in that in a particular case I am getting a different
> explain plan and much slower execution times on running it as a user to whom
> the predicate is applied than if I manually run the same query (supposedly!)
> as a user for whom I build a null predicate.
>
> I am running oracle 8.1.7.4 on a SUN/Solaris platform.
>
> I have not posted the query as I am initially looking for any ideas as to
> why I am getting different plans and run times for what is essentially the
> same query. Has anybody else come across this problem?? I do get the same
> results from both queries
>
> cheers
> nigel

you can dump out some info with event 10530 which may assist in tracking this down

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"