Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> time attributable to FGAC rewrite
been looking through this group, and what docs i have, but can't
find an estimate/definitive measure of how much (additional) time
to execute an arbitrary query might be attributable to FGAC.
from what i've read, oracle does lots of query re-writing as a matter of course. one msg said 30% increase in response time, but didn't provide anything further.
assuming that such data is not published, but is known to be derivable; any references on how to get that? yes, there is the brute force approach: boot the machine, start the instance, run a query; repeat, but add the FGAC policy. subtract.
thanks,
robert
Received on Tue Jul 13 2004 - 09:39:51 CDT
![]() |
![]() |