Oracle多租户体系,使用Oracle数据库综合的多租户架构.pdf

Database Consolidation using Oracle Multitenant

Pini Dibask, Product Manager for Database Solutions

October 1st , 2017

About Me

• Pini Dibask, Product Manager, Database Monitoring Solutions (Quest)

• Based in Israel

• Oracle DBA since 2006 (started with version 9i)

• Oracle Certified Professional DBA (OCP)

• Public Speaker: Oracle OpenWorld, IOUG Collaborate, DOAG, OUGN, AOUG

• Blogger: OracleDBPro.BlogSOracleDBPro.BlogS

Pini.Dibask@Q

http://L/in/ pinidibask

@pini_dibask

2 Confidential

About

• Quest is now an independent company again!

• Simplifies IT management

• # 1 independent software company for Database Tools

• Driven by innovation

“Spend lesstime on what you need to do, and more time on what you want to do! ”

• Committed to providing great products and superior support

3

Confidential

Agenda

• Introduction to Database Consolidation

• Oracle Multitenant Concepts

• Ensuring QoS in Multitenant Environments

• RAC and Multitenant

• Performance Monitoring for Multitenant Environments

4

Confidential

Introduction to Database Consolidation

Database Consolidation - Prior to Oracle 12c

Server Consolidation

 Multiple databases reside on a single server

6

Confidential

Database Consolidation - Prior to Oracle 12c (Cont’d)

Database Consolidation

 Single database with multiple schemas

7

Confidential

Database Consolidation with Schema Separation - Challenges

 Name Collisions

 Same schema name or same public synonym name

 Security

 DBA can access data of both applications

 Upgrades

 You cannot