Re: VPD Pre/Post Implementation Issues
- From: Mogens Nørgaard <mln@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 22 Aug 2004 23:37:11 +0200
Ha, good one. Yep, makes sense to get it working first. Sorry if I went
down the wrong path on this thread. Probably did.
By the way, did you try out event 10730, which will show information
about FGAC stuff on the first parse (not, repeat, not after that)? Never
tried it myself, but it should show the extra stuff that is later
hidden. Haven't bothered to test it myself, of course.
Mogens
Raj Jamadagni wrote:
> Mogens,
>
> Very true, but our situation was w/o index the sql wouldn't run. The form
> would freeze and the
> developer insisted that nothing else (except the VPD) will work. So, my
> colleague who was
> attending OOW 2003, checked with Oracle guys who asked "is there a index on
> *those* columns?". We
> didn't have one, created and that process finally started working.
>
> Give the options ...
>
> 1> not working
> and
> 2> does more LIO
>
> I didn't want to think about option 2. ... getting that stupid thing to work
> was a priority. So,
> as we summarized in our case ... the problem wasn't the index but the VPD.
> And don't you love when
> they come up with "1=1" conditions where there is nothing to filter by?
>
> Cheers
> Raj
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
