Re: 12c pluggable database shared SGA question

  • From: Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>
  • To: Glenn.Travis@xxxxxxx
  • Date: Wed, 10 Sep 2014 15:28:36 -0500

On Wed, Sep 10, 2014 at 2:56 PM, Glenn Travis <Glenn.Travis@xxxxxxx> 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

Other related posts: