Oracle Database Characteristics

When a database deployment is created on Oracle Database Exadata Cloud at Customer, an Oracle database is created using information provided in the Create Instance wizard:

Wizard Page and Field How Used When Creating the Database

Software Release on the Instance page

Determines which version of Oracle Database is used.

DB Name on the Instance Details page

The database system identifier (SID) of the database.

PDB Name on the Instance Details page (only for Oracle Database 12c, or later)

The name of the default pluggable database (PDB) that is created in the container database.

Administrator Password on the Instance Details page

The password used for the SYS and SYSTEM database users.

Application Type on the Instance Details page (for a starter database deployment only)

Adjusts Oracle Database parameter settings:

  • Transactional (OLTP) — configures the database for a transactional workload, with a bias towards high volumes of random data access.

  • Decision Support or Data Warehouse — configures the database for a decision support or data warehouse workload, with a bias towards large data scanning operations.

Character Set on the Instance Details page

The database character set.

National Character Set on the Instance Details page

The database national character set.

Database Type on the Instance page

Specifies the type of database deployment, which determines key configuration attributes such as whether or not Oracle Data Guard is configured, for example.

Hostnames on the Instance Details page

Specifies the placement of database instances on the compute nodes.

Oracle Home Name on the Instance Details page

Specifies the placement of the Oracle Home directory (containing the Oracle Database binaries) on the compute nodes.