Databases Reference
In-Depth Information
Chapter 2: Oracle Architecture
This chapter describes concepts and structures at the core of the Oracle database. Fea‐
tures new or modified in Oracle Database 12
c
or changed and mentioned here include:
Multitenant Container Database (CDB)
Operations and entities that apply to an Oracle instance are implemented here and
are intended to operate across multiple separate Pluggable Databases (PDBs).
Pluggable Database (PDB)
Pluggable databases are plugged into container databases (CDB) and contain the
database schema. PDBs are useful for database consolidation, provisioning of new
databases, copying existing databases, and upgrades or patching.
Database Resource Manager
Now also manages resource allocation between PDBs.
Minimum Initialization Parameters
Only CONTROL_FILES, DB_NAME, and MEMORY_TARGET need be specified.
Others parameters are set to default values.
PGA_AGGREGATE_LIMIT
A parameter used to place a limit on the total memory available to the PGA.
Chapter 3: Installing and Running Oracle
Although the standard installation and runtime operations of the Oracle database re‐
main essentially the same, the installation process was improved such that it could take
only 20 minutes on a desktop configuration. A few Oracle Database 12
c
enhancements
covered in this chapter include:
Global Data Services
Enables widely geographically dispersed databases to participate in a single global
service.
Database Resident Connection Pooling
Connection pooling implemented in the database server instead of a middle tier.
Flashback Query improvement
Flashback query support extended to queries on temporal validity dimensions.
Chapter 4: Data Structures
This chapter covers the basic data structures and optimization technology in the Oracle
database. New features include:
