Author
David Yahalom
Released
3/22/2017- Pluggable databases (PDB)
- Enabling the new multitenant container database (CDB) architecture
- Connecting to the CDB
- Creating a new PDB
- Unplugging and cloning a PDB
- Backing up and restoring a PDB using RMAN
- Using the new In-Memory Column Store
- Using improved default column values
- Enabling and using extended 32K VARCHARs
- Exploring improved Top-N queries
- Using Oracle temporary undo
- New database partitioning features
- Using adaptive execution plans
- Restoring a table to a specific point in time using RMAN
Skill Level Intermediate
Duration
Views
- Hi! I'm David, and welcome to Oracle 12: Seeing New Features. In this course, there will be many hands-on demos that will show you how to leverage powerful features such as cloning pluggable databases, boosting analytical performance, enhancing backup and recovery, and much more. The new 12c multi-tenant architecture can help you reduce IT costs, simplify database provisioning, and make easy upgrades to position it as the ideal, next-generation cloud database platform.
The in-memory column store can dramatically accelerate performance for data warehouses and mixed workloads without any application changes required. Then, we'll take a look at adaptive execution plans, which can greatly improve the performance of your SQL queries. So get comfortable, and let's take a deep dive into what makes Oracle 12c such a groundbreaking new database version.
-
Introduction
-
Welcome59s
-
Exercise files48s
-
-
1. Oracle 12c Multitenant Architecture
-
Pre-12c: Dedicated servers4m 11s
-
The CDB architecture5m 53s
-
The root container1m 52s
-
Pluggable databases (PDBs)4m 19s
-
The SEED PDB and PDB cloning2m 34s
-
Connect to the CDB3m 7s
-
Unplug a PDB8m 18s
-
Clone a PDB5m 45s
-
Create a local user in a PDB5m 17s
-
2. Oracle 12c In-Memory Database
-
Create the demo environment4m 10s
-
3. Create the Demo Environment
-
4. Improved Column Default Values
-
5. Increased Size Limits for VARCHAR Data Types
-
Enable extended 32K VARCHARs4m 43s
-
Use extended 32K VARCHARs3m 28s
-
-
6. Improved "Top-n" Queries
-
7. Partitioning Features
-
Move partitions online8m 8s
-
-
8. Adaptive Execution Plans
-
Use adaptive execution plans7m 49s
-
9. Temporary Undo
-
What is temporary undo?3m 37s
-
-
10. RMAN Backup and Recovery
-
Backup the CDB and PDB5m 7s
-
New SYSBACKUP permission5m 52s
-
Conclusion
-
Next steps1m 41s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Welcome