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 -> time attributable to FGAC rewrite

time attributable to FGAC rewrite

From: robert <gnuoytr_at_rcn.com>
Date: 13 Jul 2004 07:39:51 -0700
Message-ID: <da3c2186.0407130639.46c3d316@posting.google.com>


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

Original text of this message

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