Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question.

Asked: December 06, 2016 - 3:30 pm UTC

Last updated: December 10, 2016 - 1:25 am UTC

Version: 12c

Viewed 1000+ times

You Asked

hi - we are preparing to upgrade our databases from 11g rel 2 to 12c. we have around 50 databases between non prod and prod and 100s of schemas. Trying to determine the best candidates for cdb/pdb. are there any criteria to make that determination ?

Thanks.

and Connor said...

Until you get to 12.2, you dont have a lot resource control at the pdb level, so if one pdb goes "rogue" than it can impact others (eg consume all the cpu, io, etc) so that would be a factor in your considerations.

Similarly, some functions (eg flashback) cannot be done at the pdb level until 12.2. Patching etc is typically at the container level rather than pdb.

So I would pick databases that have similar performance profiles and uptime requirements to be candidates to sit under a single container. For that reason alone, you would be unlikely to mix and match prod and non-prod databases in a single container.

Hope this helps.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, December 07, 2016 - 3:30 pm UTC

Thank you. Those are definitely good points to take into consideration. Also, what is the easiest and best way to upgrade from 11g to 12c. We have a lot of databases and wondering if there is something new in 12c that we can leverage.
Connor McDonald
December 10, 2016 - 1:25 am UTC

The "easiest and best way" to upgrade to 12c is to do good testing :-)

But the key risk elements people are seeing is changes to the optimizer, so take a look here

https://blogs.oracle.com/optimizer/entry/upgrade_to_oracle_database_12c1


More to Explore

Multitenant

Need more information on Multitenant? Check out the Multitenant docs for the Oracle Database