Oracle教程 2023-04-01

Oracle 视图 V$OPTION 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图V$OPTION表示数据库当前启用的可选功能。该视图允许用户查看SQL *Plus、RDBMS、ANSI、Oracle内部和平台特定的功能。

V$OPTION用途：

1. 用户可以使用V$OPTION来查看当前可用的功能，它们是选项控制文件中将要应用的可选功能。

2. 通过在该视图中查询可以某种功能是否打开以及当前数据库可以支持哪些可选功能，此外，还可以通过在该视图中查看已开启某项功能的特定版本是否正确。

使用V$OPTION视图：

查看当前数据库已启用的功能：

SELECT parameter, value
FROM V$OPTION
WHERE value=’TRUE’;

查看某个功能是否被启用：
SELECT value
FROM V$OPTION
WHERE parameter=’功能名称’;

官方英文解释

V$OPTION displays Oracle Database options and features.

Typically, although not always, options must be separately licensed, whereas features come with the product and are enabled based on the product that is running (for example, Enterprise Edition).

Column Datatype Description

Column	Datatype	Description
`PARAMETER`	`VARCHAR2(64)`	Name of the option (or feature)
`VALUE`	`VARCHAR2(64)`	Indicates whether the option (or feature) is installed (`TRUE`) or not (`FALSE`)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

PARAMETER

VARCHAR2(64)

Name of the option (or feature)

VALUE

VARCHAR2(64)

Indicates whether the option (or feature) is installed (TRUE) or not (FALSE)

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
1: This value is used for rows containing data that pertain to only the root
n: Where n is the applicable container ID for the rows containing data

本站中文解释

官方英文解释

相关推荐