ASM disk groups with ASM disks consisting of Exadata Grid Disks.

ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

Database files stored in ZFS and accessed using conventional NFS mounts.

Database files stored in ZFS and accessed using the Oracle Direct NFS feature

Database files stored in any file system and accessed using the Oracle Direct NFS feature

ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

They are tied to a specific statement or SQL id.

They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

They are used to gather only missing statistics.

They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

They instruct the optimizer to create only column group statistics.

Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

Building and implementing SQL profiles

Recommending the optimization of materialized views

Checking query objects for missing and stale statistics

Recommending bitmap, function-based, and B-tree indexes

Recommending the restructuring of SQL queries that are using bad plans

Merge partitions of a list partitioned table

Drop partitions of a list partitioned table

Coalesce partitions of a hash-partitioned global index.

Move partitions of a range-partitioned table

Rename partitions of a range partitioned table

Merge partitions of a reference partitioned index

All administration tasks must be done to a specific pluggable database.

The pluggable databases increase patching time.

The pluggable databases reduce administration effort.

The pluggable databases are patched together.

Pluggable databases are only used for database consolidation.

Increasing the priority of the job class to which the job belongs

Increasing the job's relative priority within the Job class to which it belongs

Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window

Moving the job to an existing higher priority scheduler window with the same schedule and duration

Increasing the value of the JOB_QUEUE_PROCESSES parameter

Increasing the priority of the scheduler window to which the job belongs

Each pluggable database (PDB) has its own set of background processes.

A PDB can have a private temp tablespace.

PDBs can share the sysaux tablespace.

Log switches occur only at the multitenant container database (CDB) level.

Different PDBs can have different default block sizes.

PDBs share a common system tablespace.

Instance recovery is always performed at the CDB level.