Oracle教程 2023-04-01

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

本站中文解释

Oracle视图ALL_STATEMENTS是DBA_STATEMENTS的子集，它继承了父视图的所有特性。它以简要的方式显示当前用户已经运行的所有非结构化SQL语句，以及此用户所有的数据库操作，包括游标，流量，DDL语句和优化器等信息。

ALL_STATEMENTS可以帮助DBA在系统上监控用户访问最近运行的查询以及所有结构化查询语句，从而帮助DBA更好地理解服务器负载，找出性能瓶颈，优化数据库性能，以及指定起始和结束时间等信息。

使用ALL_STATEMENTS，可以通过以下语句来访问它：
SELECT * FROM ALL_STATEMENTS;

官方英文解释

ALL_STATEMENTS describes all SQL statements in stored PL/SQL objects accessible to the user.

Related Views

DBA_STATEMENTS describes SQL statements in stored PL/SQL objects accessible to SYS.
USER_STATEMENTS describes SQL statements in stored PL/SQL objects accessible to the user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the statement
`SIGNATURE`	`VARCHAR2(32)`		Signature of the statement. Every statement type has a unique PL/Scope signature that identifies that instance of th statement.
`TYPE`	`VARCHAR2(17)`		Type of the statement. Statement types correspond to statements that can be used in PL/SQL to execute or otherwise interact with SQL: `SELECT` `UPDATE` `INSERT` `DELETE` `MERGE` `CLOSE` `FETCH` `OPEN` `SAVEPOINT` `COMMIT` `SET_TRANSACTION` `ROLLBACK` `LOCK_TABLE` `EXECUTE_IMMEDIATE`
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object where the statement usage occurred
`OBJECT_TYPE`	`VARCHAR2(12)`		Type of the object where the statement usage occurred
`USAGE_ID`	`NUMBER`		Unique key for a statement usage within the object
`LINE`	`NUMBER`		Line number of the statement usage
`COL`	`NUMBER`		Column number of the statement usage
`USAGE_CONTEXT_ID`	`NUMBER`		Context USAGE_ID of an statement usage
`SQL_ID`	`VARCHAR2(13)`		SQL ID of the SQL statement. The value of this column is null for statements that do not have a SQL ID.
`HAS_HINT`	`VARCHAR2(3)`		`YES` if the SQL statement contains a hint, `NO` otherwise. If a hint appears inside of a subquery, then `HAS_HINT` will be `YES` for the containing statement or statements of the subquery as well as for the subquery itself.
`HAS_INTO_BULK`	`VARCHAR2(3)`		Indicates whether the statement contains a `BULK_COLLECT` clause (`YES`) or not (`NO`)
`HAS_INTO_RETURNING`	`VARCHAR2(3)`		Indicates whether the statement contains a `RETURNING_INTO` clause (`YES`) or not (`NO`)
`HAS_INTO_RECORD`	`VARCHAR2(3)`		Indicates whether the statement returns results into a PL/SQL record (`YES`) or not (`NO`)
`HAS_CURRENT_OF`	`VARCHAR2(3)`		Indicates whether the statement contains a `HAS_CURRENT_OF` clause (`YES`) or not (`NO`)
`HAS_FOR_UPDATE`	`VARCHAR2(3)`		Indicates whether the statement contains a `HAS_FOR_UPDATE` clause (`YES`) or not (`NO`)
`HAS_IN_BINDS`	`VARCHAR2(3)`		Indicates whether the statement contains an `IN_BINDS` clause (`YES`) or not (`NO`)
`TEXT`	`VARCHAR2(4000)`		The normalized form of the statement, when the statement has a normalized form. These are typically the same statements that have a SQL ID. The column value is null when the statement does not have a normalized form.
`FULL_TEXT`	`CLOB`		Clob text of the SQL statement
`ORIGIN_CON_ID`	`NUMBER`		The ID of the container where the data originates. Possible values include: `0`: This value is used for rows in non-CDBs. This value is not used for CDBs. n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root)

本站中文解释

官方英文解释

相关推荐