Re: time attributable to FGAC rewrite

robert wrote:

> 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

No blanket percent increase is possible as what happens depends on what you've written. But from my experience the difference is small enough to be insignificant in most situations.

Daniel Morgan Received on Tue Jul 13 2004 - 19:31:29 CDT