Oracle教程 2023-02-24

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

Oracle视图V$SQL_REDIRECTION存储着所有已重定向SQL语句的记录，可以用来帮助管理客户端连接服务器时的SQL重定向功能。

* 使用方法：

1、查看用户对某表重定向后被转换为查询服务器上的SQL：

SELECT * FROM v$sql_redirection WHERE sql_text LIKE ‘%表名%’;

2、查看指定用户执行某SQL需要重定向到其他服务器：

SELECT * FROM v$sql_redirection WHERE sql_text LIKE ‘%SQL 语句%’ AND username = ‘用户名’;

V$SQL_REDIRECTION displays SQL statements that are redirected.

Column	Datatype	Description
`ADDRESS`	`RAW(4 \| 8)`	Address of the cursor handle
`PARENT_HANDLE`	`RAW(4 \| 8)`	Address of the parent cursor handle
`HASH_VALUE`	`NUMBER`	Hash value of the SQL statement
`SQL_ID`	`VARCHAR2(13)`	SQL identifier of the SQL statement
`CHILD_NUMBER`	`NUMBER`	Number of the child (instance) for the hash
`PARSING_USER_ID`	`NUMBER`	Parsing user ID
`PARSING_SCHEMA_ID`	`NUMBER`	Parsing schema ID
`COMMAND_TYPE`	`NUMBER`	`SELECT`, `UPDATE`, `INSERT`, `MERGE`
`REASON`	`VARCHAR2(14)`	Reason for redirection (`'INVALID OBJECT'`, `'ROWID'`, `'QUERY REWRITE'`, `'READ ONLY'`)
`ERROR_CODE`	`NUMBER`	Error code for local parse
`POSITION`	`NUMBER`	Error position, 0 if unknown
`SQL_TEXT_PIECE`	`VARCHAR2(1000)`	SQL Text containing position, usually a (qualified) identifier
`ERROR_MESSAGE`	`VARCHAR2(1000)`	Error code’s corresponding error message resolved in the database language, no arguments resolved
`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

分享到：