This video identifies the differences between the traditional Oracle architecture and the new multitenant architecture of Oracle 12c.
- [Instructor] This is the classic oracle architecture. We have one instance it contains a set of bekram processes and various memory caches. The relationship between the database instance and the database storage in this traditional Oracle architecture is one to one. For each Oracle instance, you also have one database storage component. Together they make up what we call the Oracle Database. Oracle 12c changes things up. Oracle 12c introduces a new concept of a multitcontainer database, or CDB.
of a multitcontainer database, or CDB. Container Database, in short. That is the logical name describing a super database. Because in Oracle 12c you can actually have multiple subdatabases called PDBs or Pluggable Databases, multiple subdatabases called PDBs or Pluggable Databases, under a single Oracle instance. So this combination of an Oracle instance and multiple pluggable databases is now called a container database, or a multitenant container database, depending on how verbose you want to be.
You can easily plug in and plug out PDBs from an Oracle 12c server, making your database architecture far more flexible. For example, if your company develops a web application that has to serve many different corporate customers using the new Oracle 12c pluggable database architecture, you can have one PDB per customer. So you separate customer data and increase the sovereignty each customer has. When it comes to adding a new customer, you can just create a dedicated PDB for that customer instead of installing a new database server, which was usually done in the pre-12c Oracle architectures.
So to compare both 12c and pre-12c database architectures, So to compare both 12c and pre-12c database architectures, we went from a model where one Oracle instance connected to only one Oracle database to a more flexible approach, where one Oracle instance can now connect and open multiple Oracle databases. So instead of having to use many individual database servers for many different applications or customers, we can just deploy a single Oracle 12c mutlitenant container database and have multiple pluggable databases inside, each dedicated to a specific customer or application.
Now that's called database consolidation.
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Database Fundamentals: Core Conceptswith Adam Wilbert2h 14m Beginner
Relational Database Fundamentalswith Adam Wilbert2h 40m Beginner
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 58s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.