Administering a CDB with SQL*Plus

（一）Administrative Tasks Common to CDBs and Non-CDBs

因为以下资源在CDB中是共享的，所以在CDB配置会影响所有pdbs，管理方法同non-cdb，详见alter database语法

1. Managing processes
2. Managing memory
3. Monitoring errors and alerts：A CDB has one alert log for the entire CDB
4. Managing diagnostic data
5. Managing control files
6. Managing the online redo log and the archived redo log files
7. Managing undo: 如果是share undo mode则只能cdb中更改

除了share undo mode，其它表空间在cdb与pdbs是独立配置的

（二）Managing the CDB Undo Mode

SELECT PROPERTY_NAME, PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE  PROPERTY_NAME = 'LOCAL_UNDO_ENABLED';

If the query returns TRUE for the PROPERTY_VALUE, then the CDB is in local undo mode. Otherwise, the CDB is in shared undo mode.

Local undo mode provides increased isolation for each container and improves the efficiency of some operations, such as unplugging the container or performing point-in-time recovery on the container. In addition, local undo mode is required for some operations to be supported, such as relocating a PDB or cloning a PDB that is in open read/write mode.

创建CDB后仍可以更改undo mode

Oracle Database automatically creates an undo tablespace in any container in the CDB that does not have one. If a PDB without an undo tablespace is cloned, relocated, or plugged into a CDB that is configured to use local undo mode, then Oracle Database automatically creates an undo tablespace for the PDB the first time it is opened.

1. local undo mode

Any user who has the appropriate privileges for the current container can create an undo tablespace for the container.

Undo tablespaces are visible in static data dictionary views and dynamic performance (V$) views in every container in the CDB.

1. Shared Undo Mode

Only a common user who has the appropriate privileges and whose current container is the CDB root can create an undo tablespace.

When the current container is not the CDB root, an attempt to create an undo tablespace fails and returns an error.

Undo tablespaces are visible in static data dictionary views and dynamic performance (V$) views when the current container is the CDB root. Undo tablespaces are visible only in dynamic performance views when the current container is a PDB, an application root, or an application PDB.

When you change the undo mode of a CDB, containers in the CDB cannot flash back to a