Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> FGAC and that 30%

FGAC and that 30%

From: robert <gnuoytr_at_rcn.com>
Date: 16 Jul 2004 05:33:16 -0700
Message-ID: <da3c2186.0407160433.1b3339f4@posting.google.com>


(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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US