Building Database Clouds in Oracle 12c

4. Schema Consolidation in Enterprise Manager 12c

Schema as a service provides database consolidation by allowing administrators to host multiple application schemas within a single database. This offers the capability of database as a service (DBaaS) to possibly hundreds of application users without creating database sprawl. Users can perform day-to-day actions such as provisioning, monitoring, and backup all from a single self-service console. Schema as a service leverages database features such as Oracle Resource Manager and Oracle Database Vault to isolate users of the cloud. These features are complemented by metering and showback/chargeback capabilities, which provide visibility and transparency into resource consumption by each user.