Introduction to Oracle Database Multitenant Architecture

Ahmed Baraka
A free video tutorial from Ahmed Baraka
Snr. Database Administrator
4.6 instructor rating • 7 courses • 4,169 students

Lecture description

By the end of this lecture, you should be able to:

  • Understand the business challenges that the Multitenant option is addressing
  • Understand the basic structure of the Oracle Multitenant
  • and finally describe the benefits of Oracle Multitenant 

Learn more from the full course

Oracle 12c Multitenant Architecture Administration

Learn how to build and manage an Oracle 12c Multitenant Architecture database.

10:18:37 of on-demand video • Updated July 2020

  • Describe the Oracle 12c multitenant architecture
  • Create multitenant container database
  • Create a pluggable database using different methods
  • Create and manage common and local user accounts
  • Manage PDB lockdown profiles
  • Perform backup and recovery
  • Perform PITR and flashback
  • Use the Resource Manager in a container database
  • Use Data Pump utility with PDBs
  • Manage the applications and application containers
English [Auto] Hi everybody allow me to welcome you in the first theater lecture in the course in this lecture I would introduce to you the Oracle Database multitenant architecture by the end of this lecture you should be able to understand the business changes that the multitenant option is addressing. Understand the basic structure of the Oracle multitenant and finally describe the benefits of Oracle multi-tenant architecture. Before I introduce the Oracle multitenant architecture Let's talk about what are the problem. The Oracle multi-tenancy is trying to solve as the I.T. systems are growing in the enterprises it's information infrastructure houses hundreds or thousands of databases. Often these databases on different platforms on multiple physical servers. Let's point out the challenges that raises as a result of that. Suppose you have a server that is hosting a database that database consumes an average of nine gigabyte out of its total 16 gigabyte memory and it utilizes 20 percent of its 4C be used. And it takes up half terabyte out of its one terabyte disk space. You may have a number of database servers with similar resources consumption and average based on this. If you have a total of 10 servers then you have a total of 70 gigabyte unused memory 80 percent of the 40 cb use is not utilized and a total of 5 terabyte over 40 unused disk space. In summary a fair percentage of the hardware resources is not being utilized. Consider the case when it is required to apply a release upgrade or a patch set update. If the process takes up three hours for one server you will need a total of 30 VBA working hours. Usually this leads to having a team of D-B is just as sheave this sort routine task. What applies for applying batch set also applies for normal VBA tasks. You need DBI is to perform the normal database administration tasks on every database server as a result. Large number of D-B is required to take care of those databases. In summary having the database is installed in many servers lead that underutilization of the I.T. infrastructure resources and efficient use of the DB resources. Generally speaking. Handling those challenges is done by finding a way to consolidate a group of databases together. You will see in the next slide the consideration options that were there before the oracle multitenant architecture came to the I.T. industry. Are the constellation options that were available for DBMS before Oracle it to FC was released. The first option is to create multiple virtual machines on a single physical server. Then Oracle databases are created in those machines. But out of sight this solution is easy to implement. It reduces the physical management of the server and it provides a very good level of databases isolation on the negative side an extra layer of administration is added to the business which is to manage the virtual machines themselves in addition to that every database has its own background processes and it's a area taken from the memory. The second option is to create multiple databases in the same physical set of this solution provides a little bit better resources utilization and less physical server administration work because you only have a single server instead of a group of servers. On the other side however with this solution every database still has its own memory consumption and its background processes that I think which limits the resources utilization in the server. The last option is to use this schema consideration with this option. You basically put every application data in a separate schema or a virtual private database although this option provides high consideration density. It practically may lead to a lot of issues. For example some application requirements on its database may conflict with the requirements of some other applications. This lack of agility is a big constraint in the solution. As you progress with the course you will learn how Oracle tools see multi-tenancy addresses all those issues in high level description. When Oracle database multitenant option is used you consolidate one or more databases into a single housing container database. This container database is called Seabee root database or just a root database for the sake of simplicity this database does not typically have any application data. It just has the meta data of the other databases that you will create to hold the application data in them. On the top of the CVB you create one or more application databases like for example the edge R system database. Those databases hold the data that will be accessed by the application. The application is not normally aware about the CVB it communicates with its databases as if it was a stand alone database dedicated to the application. You can create more databases on the top of the CD to save more other applications like sales or CRM applications and Oracle multi-tenancy theorems those databases are called pluggable databases or PDB is an oracle tool series is one you can create up to 252 PDB as in Oracle it will serialist to. You can create up to four thousand and 96 PDB as as I said earlier Petey's are the databases that the applications Konik to each PDB is virtually isolated from the other databases. No PDB is aware about the existence of the other PTB. This is a high description of the article that is multi-tenancy in the next lecture you will get into the details of its structure. As a consolation solution what are the advantages of Oracle multitenant option. First of all it addresses the constellation challenges it provides the best resources utilization among all the other considerations solutions. The number of DBI is required to manage the application. Databases are less than is needed if the databases were installed in stand alone separate databases. This will become clear to you when you understand the Oracle multitenant architecture in the next lecture. Secondly generally speaking when you move your existing application databases to an Oracle database multi-tenant environment you don't have to change anything in the application schema or in the application code that connects to its database. In the multi-tenant environment exactly the same way it used to connect to it before moving it to the multi-tenant environment. Thirdly regardless of how many Digby's you have in your oracle multitenant instant every PDB is virtually isolated from each other. Unless it was configured no PDB can even connect to any other PDP. The fourth or some benefit of using the Oracle multitenant is the ease of moving the PDP. As you will see in the course moving a PDB from one container to another or cloning it within the same container is very easy and in some cases it is even more efficient than any other method. The fifth advantage is that you can perform point in time recovery within a single PDB without affecting the other PDP. This feature has been used in a 12 series too and it is a fantastic improvement in that release. You will feel all of those features in Oracle multitenant architecture as you progress and the cause in my personal opinion what you call multitenant architecture is the most dramatic change that has been developed in Oracle database in a decade. In this lecture I have introduced to you Oracle tool C architecture. You should have by now an understanding about the business challenges that the multitenant option is addressing. You should be able to understand in high level how Oracle multitenant works and you should be able to describe the benefits of using Oracle multitenant option in the next lecture or you will learn more details about the Oracle multitenant architecture. Thanks for listening to me. See you in the next lecture.