Re: 12c pluggable database shared SGA question
Date: Wed, 10 Sep 2014 15:28:36 -0500
Message-ID: <CA+fnDAZ-imPV_BRGcoCh1iR3L+wkjRcEc_HU0=d6KR6q=DhjTQ_at_mail.gmail.com>
On Wed, Sep 10, 2014 at 2:56 PM, Glenn Travis <Glenn.Travis_at_sas.com> wrote:
>
>
> You would NOT put a heavy DSS type application in the same database as a
> heavy OLTP application. And by application, you can assume 'schema'.
> These are two entirely different beasts with entirely different tuning
> challenges/strategies. So, to follow, you would not put a DSS PDB in the
> same CDB as a OTLP PDB. Correct?
>
If you're talking about systems with a heavy workload, then they probably shouldn't be on the same server anyway. And in most cases they shouldn't share storage either.
I think the slides you're linking are generic product slides though. Those slides look like they were put together by someone in sales - they're just trying to think of some generic example database names. Probably "DW" was a poor choice... but these slides are meant to be a generic illustration of PDB separation and shouldn't be taken seriously as any kind of architectural advice.
-J
-- http://about.me/jeremy_schneider -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 10 2014 - 22:28:36 CEST