Databases Reference
In-Depth Information
Oracle Cloud Management Pack for Oracle Database
The Cloud Management Pack enables identification of pooled resources, configu‐
ration of role-based access, definition of service catalogs and chargeback plans, and
supports user requested database resource requests and provisioning where the
database is deployed as a service (DBaaS).
Oracle Data Masking Pack
The Oracle Data Masking Pack enables scanning of an Oracle Database for sensitive
data based on patterns, uses referential relationships when determining data ele‐
ments that should be masked, provides a library of typical masks needed, and sup‐
ports advanced masking techniques such as condition-based masking, compound
masking, deterministic masking, and key-based reversible masking.
Oracle Test Data Management Pack
The Oracle Test Data Management Pack automatically discovers data relationships
and table types, storing them in Application Data Models, and is used to create test
databases from production databases.
Real Application Testing Option
Oracle Database 11
g
introduced the capability to rerun production workloads and test
system changes through the Real Application Testing Option. This database option
includes a Database Replay facility and the SQL Performance Analyzer (SPA). Database
Replay captures production workload information, including concurrency, dependen‐
cies, and timing. It transforms the workload capture files into replay files, provides a
Replay Client for processing the replay files, and provides the means to report on per‐
formance statistics and any errors that might occur. The SQL Performance Analyzer
captures a SQL workload to be analyzed, measures the performance before database
changes and afterward, and identifies performance changes among SQL statements.
Pluggable Databases
As of Oracle Database 12
c
, the database can function as a multitenant container database
(CDB) where the Multitenant Option is licensed and hold one or more pluggable da‐
tabases (PDBs). A PDB is a portable collection of schemas and schema objects that could
be unplugged from one CDB and into another. Since PDBs share resources provided
by the CDB, this increases the number of databases that can be deployed on a given
hardware platform due to more efficient utilization of the resources.
CDBs and PDBs are an important piece of Oracle's DBaaS Cloud strategy as they enable
more rapid provisioning of platforms. Key management tasks are simplified since they
are managed through the CDBs and related to PDBs. Examples of management features
in the CDBs include Active Session History (ASH), alerts, automated database main‐
tenance tasks, ADDM, automatic statistics optimizer collection, Automatic Segment
