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

本站中文解释

Oracle视图DBA_SQLSET_STATEMENTS用于显示多个语句在SQL*Plus隐式参数文件中设置的内容。该视图包含定义环境变量SQLSET_STATEMENTS及其值，在这个环境变量下所执行语句的开始时间，执行时间以及已保存的执行结果。

使用方式：

1. 首先需要通过ALTER SESSION SET SQLSET_STATEMENTS=xxx命令将SQL*Plus语句写进隐式参数文件中；

2. 然后可以通过SELECT * FROM DBA_SQLSET_STATEMENTS;命令来查看视图DBA_SQLSET_STATEMENTS；

3. 最后可以通过ALTER SESSION DROP SQLSET_STATEMENTS;命令来删除视图DBA_SQLSET_STATEMENTS的内容。

官方英文解释

DBA_SQLSET_STATEMENTS displays information about the SQL statements, along with their statistics, that form all SQL tuning sets in the database. Its columns, except for PARSING_SCHEMA_ID, are the same as those in ALL_SQLSET_STATEMENTS.

Contains the name of the module that was executing at the time that the SQL statement was first parsed, which is set by calling DBMS_APPLICATION_INFO.SET_MODULE

Contains the name of the action that was executing at the time that the SQL statement was first parsed, which is set by calling DBMS_APPLICATION_INFO.SET_ACTION

Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching

CPU time (in microseconds) used by this cursor for parsing, executing, and fetching

Number of executions that took place on this object since it was brought into the library cache

Number of times this cursor was fully executed since the cursor was brought into the library cache. The value of this statistic in not incremented when the cursor is partially executed, either because it failed during the execution or because only the first few rows produced by this cursor are fetched before the cursor is closed or re-executed. By definition, the value of the END_OF_FETCH_COUNT column should be less than, or equal to, the value of the EXECUTIONS column.

Period of time (in seconds) during which the statistics of the SQL statement were collected

For SQLs captured from the cursor cache, this is the time when the most recent execution of this SQL started

Oracle Database PL/SQL
Packages and Types Reference for more information about the DBMS_APPLICATION_INFO.SET_MODULE procedure

Oracle Database PL/SQL
Packages and Types Reference for more information about the DBMS_APPLICATION_INFO.SET_ACTION procedure

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 视图 DBA_SQLSET_STATEMENTS 官方解释，作用，如何使用详细说明