Re: 12c pluggable database shared SGA question
Date: Thu, 11 Sep 2014 18:23:52 +0200
Message-ID: <1410452632.22184.9.camel_at_dhoogfr-lpt1>
<The price of the option (which is extortionate) aside, I can see lots <of uses for this in my current company.
This has me wondering since the moment I saw the cost for this option.
Has anyone a real business case in which the reduction in in memory
footprint and such has lowered the cost in such amount that it outweighs
the additional cost of the option?
Aside from sharing resources, what are the things that would make
managing PDB's so much more efficient that it justifies the price Oracle
charges you?
Kind regards,
Freek
On do, 2014-09-11 at 08:41 +0100, Tim Hall wrote:
> I think we have to keep in mind this is Multitenant 1.0 (or 1.1 if you
> are using 12.1.0.2). Lessons will be learned from this and I'm sure in
> the future we will have the options to alter the way undo and redo
> work in multitenant. Also, limiting memory on a per-PDB basis etc.
>
> I think Seth's point about schema is probably the key thing here.
> Ignoring lone-PDB (single-tenant) setups, mutlitenant only really
> works well for consolidation purposes. You only ever consolidate
> certain types of schema/databases. If you are running your petabyte DW
> on the same hardware as your mission critical OLTP system you are an
> idiot (insert caveats). You would not try to put your DW into a schema
> in the same database as your OLTP system. With that in mind, why would
> you even consider consolidating in this way for PDBs? (point about
> dodgy slides noted :) ).
>
> The price of the option (which is extortionate) aside, I can see lots
> of uses for this in my current company. In some ways, the current
> limitations are a plus point because it makes the decisions a little
> more clear cut. There are lots of people running loads of crappy
> little databases that are important, but have no major performance
> needs. These are prime for consolidation into separate schema, or as
> PDBs if the extra separation is needed...
>
> It's all about context...
>
> Cheers
>
> Tim...
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 11 2014 - 18:23:52 CEST