Oracle教程

Oracle 参数 CONTAINER_DATA 官方解释，作用，如何配置最优化建议

本站中文解释

：

CONTAINER_DATA参数指定容器存储介质的位置。容器存储介质是指在空间管理中用于存储Data Guard的常规和归档日志文件的磁盘空间。容器存储介质可以是物理磁盘或一个正确配置的ASM实例。 CONTAINER_DATA参数用于指定数据库中容器存储介质的位置，用户也可以选择在创建物理操作系统文件或ASM实例后，再指定CONTAINER_DATA参数的值。

正确设置CONTAINER_DATA参数的方法如下：
（1）在物理操作系统上，为容器创建一个文件夹。
（2）在Oracle控制文件中指定CONTAINER_DATA参数的值，以指向上述文件夹。
（3）如果你选择使用ASM实例，使用ASMCA应用程序创建ASM实例，并重新指定CONTAINER_DATA参数的值，以指向ASM实例。

官方英文解释

Use CONTAINER_DATA to control whether queries on extended data-linked objects from within a PDB return rows from both the root and the PDB, or rows from only the PDB.

Property Description

Parameter type

String

Syntax

CONTAINER_DATA = { ALL | CURRENT | CURRENT_DICTIONARY }

Default value

ALL

Modifiable

ALTER SESSION

Modifiable in a PDB

Yes

Basic

No

Oracle RAC

Different instances can use different values.

This parameter controls the behavior of queries on the following types of objects:

  • Extended data-linked application common objects

    This type of object stores shared data in an application root, and also allows application PDBs to store local data that is unique to each application PDB.

    When this type of object is queried from an application root, only the shared data in the application root is returned.

    When this type of object is queried from an application PDB, the value of the CONTAINER_DATA initialization parameter controls the query result as follows:

    • ALL: The query returns both the shared data in the application root and the local data pertaining to the application PDB

    • CURRENT: The query returns only the local data pertaining to the application PDB

    • CURRENT_DICTIONARY: The query returns both the shared data in the application root and the local data pertaining to the application PDB

  • Extended data-linked Oracle-supplied data dictionary objects

    This type of object stores data pertaining to the CDB root, as well as data pertaining to individual PDBs.

    When this type of object is queried from the CDB root, only data pertaining to the CDB root is returned.

    When this type of object is queried from a PDB, the value of the CONTAINER_DATA initialization parameter controls the query result as follows:

    • ALL: The query returns data pertaining to both the CDB root and the PDB

    • CURRENT: The query returns only data pertaining to the PDB

    • CURRENT_DICTIONARY: The query returns only data pertaining to the PDB


数据运维技术 » Oracle 参数 CONTAINER_DATA 官方解释，作用，如何配置最优化建议
分享到：

相关推荐