Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> FGAC and that 30%
(when i use Google, i can't reply to a thread garnered with search,
so here goes)
You should be aware that Option 2 may have a significant impact on performance. FGAC has to execute a PL/SQL function, modify the query and parse every time you query that table now. Option 1 would avoid that. In some situations, I've since FGAC add 30% overhead to an application.
Good Luck,
Richard Kuhler
did you ever find out where that 30% went? was it lack of indexing, or actual function execution? a bit of both?
thanks,
robert
Received on Fri Jul 16 2004 - 07:33:16 CDT
![]() |
![]() |