OOW 2012: What’s next for Oracle Database

Database Consolidation challenges:

- Reduce IT costs by consolidating more servers
Reduces TCO and increase ROI
- Reduce numbers of databases
- Keep database applications isolated and unchanged
Pluggable databases
- Container database with one set of background processes and one set of memory
- Plug database (PDB) in Container databases (CDB) and shared resources
- Recommended upgrade to 12c:
Upgrade database to 12c and then migrate non-CDB to CDB. Plug individual databases in 12c container database. Completely integrated in EM12c
- Highly efficient:
Up to 6x less resources, up to 5x more scalable compared to separate databases
- Simplify Patching and upgrades
Create new CBD and plug database in new CBD, enables you to test upgraded PBD  individually
- Backup CDB as a whole and as a PDB, also for restore
- Standby database for whole CDB
- Very fast cloning of databases for Test and Development, especially in combination with copy on write filesystems
- Pluggable databases as Saas (Software as a Service) because of quick provisioning
- NO changes to applications!
- Tom Kyte, yeah! Top 12 features in 12c
1. Even better PL/SQL from SQL
2. Improved defaults, eg sequence assignment
3. Increase size limits for VARCHAR2, NVARCHAR2 and RAW Databse types up to 32K
4. Easy Top-N and pagination queries, easy clauses in sql statement
5. Row pattern matching, describe the pattern in sql with single sql statement
6. Adaptive execution plans, add extra steps in plan and adapt dynamically
7. Enhanced statistics, hybrid histograms gives good insight in skewed data
8. Temporary UNDO, undo for temporary segments, bypass redo
9. Data optimization, where are the hot and coldspots, moves data arround based on usage
10. Application Continuity, guarantee transaction, transparent to the application
11. Database security, data redaction, filter out data without influence for the application
12. Pluggable databases! No namespace collisions anymore
Database Testing Challenges
- Rigorously test all consolidated workloads
- Be able to scale teting of testing of database workloads
- Control allocation of resources across workloads
With Consolidated Replay you are able to replay captures concurrently on databases consolidated in a CDB
So you can identify problems within CDB and use resource manager, implement a resource plan on the PDB involved
Filed under: Uncategorized