Re: Oracle partitioning

From: Billy <vslabs_at_onwe.co.za>
Date: 23 Aug 2005 06:20:04 -0700
Message-ID: <1124803204.512830.60070@g49g2000cwa.googlegroups.com>

bdb..._at_gmail.com wrote:

> As far as actually using VPN and FGAC, good for you. I've read notes
> whereby such features place additional stress upon the shared pool and
> could push a database instance that was close to 4031 land over the
> edge.

That must surely depend on how the FGAC functions are implemented - and the amount of non-shareable SQL they generate. I can just see how some would code literals into the FGAC return values instead of properly using context functions... Or having a unique and different predicate per VPDB user (which puts a questionmark on the lack of a common security model).

Am I missing something in saying that FGAC predicates should generate shareable SQL?

> I guess it really depends upon if you're used to running fewer
> databases on EE on larger servers, or more dbs on (many more) SE one
> pizza boxes.

SE on pizza boxes works great. Heck, EE on a bunch of RAC'ed and stacked pizza boxes work even better. :-)

--
Billy

Received on Tue Aug 23 2005 - 08:20:04 CDT