Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Manjunath.

Asked: November 23, 2016 - 10:10 am UTC

Last updated: November 24, 2016 - 4:29 am UTC

Version: 12.1.0.2

Viewed 1000+ times

You Asked

Hello Tom & Team,

Can you please shed some light on capacity planning h/w + Oracle database configuration for Oracle 12c - Multitenant Option being used. We are planning to consolidate/upgrade 10 databases using Multitenant architecture. My thoughts are like for sga - sum all 10 database sgas + additional 10% more for 12c additions,etc Any other important aspects to be borne during planning.

Thanks
Manjunath

and Connor said...

The theory behind multi-tenant is that you should be able to reduce some of the memory footprint, on the premise that not all pluggables would be using all of their normal buffer cache at the same time.

Similarly, you'll have a drop in the number of background processes. Note - this doesn't reduce *load* because most background processes do nothing unless requested to, but each one does consume memory, so less of them gives you more memory to allocate elsewhere.

What is critical is that you make sure that all the stuff you currently will work nicely with multi-tenant. A common practice is to move/upgrade just *one* database to multitenant and then use that to identify any mods to scripts etc to work under multitenant.

Rating

  (1 rating)

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

Comments

oracle 12c capacity planning

Manjunath Parame.swara, November 23, 2016 - 1:03 pm UTC

Thank you...so are there any best practices that can be followed to ensure we have smooth transition from non-cdb to pdb ? Dos & Donts
Connor McDonald
November 24, 2016 - 4:29 am UTC

More to Explore

Multitenant

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