Oracle教程 2023-04-04

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

V$SESSION_FIX_CONTROL视图用来显示当前会话的特定修复选项的状态。

Oracle的表段修复选项用于防止删除或者更新失败，大多数是可以在会话级别上定义的。

这个视图可用于查看不同的表段修复选项的启用/禁用状态，对当前会话中的表段修复操作有一定的了解和使用帮助。
使用它，可以查看会话级别上已经启用了哪些修复选项，它们是什么时候启用的，还有配置了哪些参数。

使用方法：
1.查看已经启用的修复选项：

SELECT * FROM V$SESSION_FIX_CONTROL;

2.查看某会话中已经启用的修复选项：

SELECT * FROM V$SESSION_FIX_CONTROL WHERE SID = sid;

3.查看某数据库中启用的修复选项：

SELECT * FROM V$SESSION_FIX_CONTROL WHERE INSTANCE_NUMBER = instno;

4.查看某库的特定修复选项的状态：

SELECT * FROM V$SESSION_FIX_CONTROL WHERE FIX_CONTROL_NAME = ‘fix_name’ AND INSTANCE_NUMBER = instno;

V$SESSION_FIX_CONTROL displays information about Fix Control (enabled/disabled) for the current session.

Column	Datatype	Description
`SESSION_ID`	`NUMBER`	Session identifier (can be used to join this view with `V$SESSION`)
`BUGNO`	`NUMBER`	Bug number (as fix control identifier)
`VALUE`	`NUMBER`	Current value set for the fix control
`SQL_FEATURE`	`VARCHAR2(64)`	Feature control ID
`DESCRIPTION`	`VARCHAR2(64)`	Description of the fix control
`OPTIMIZER_FEATURE_ENABLE`	`VARCHAR2(25)`	Version on (and after) which the fix is enabled by default
`EVENT`	`NUMBER`	Event formerly used to control the fix
`IS_DEFAULT`	`NUMBER`	Indicates whether the current value is the same as the default (`1`) or not (`0`)
`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

分享到：