Oracle 视图 DBA_SQLSET_STATEMENTS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_SQLSET_STATEMENTS用于显示多个语句在SQL*Plus隐式参数文件中设置的内容。该视图包含定义环境变量SQLSET_STATEMENTS及其值，在这个环境变量下所执行语句的开始时间，执行时间以及已保存的执行结果。
使用方式：
1. 首先需要通过ALTER SESSION SET SQLSET_STATEMENTS=命令将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.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the SQL tuning set for the statement |
|
|
|
User name of the SQL tuning set owner |
|
|
|
|
|
ID of the SQL tuning set for the statement |
|
|
|
|
The database ID of the PDB |
|
|
|
|
SQL identifier of the parent cursor in the library cache |
|
|
|
|
The signature used when the |
|
|
|
Full text for the SQL statement exposed as a CLOB column. |
|
|
|
|
Name of the user in whose schema the statement was parsed |
|
|
|
|
ID of the schema in which the statement was parsed |
|
|
|
|
|
Hash value for the plan corresponding to statistics in this record |
|
|
|
Bind data |
|
|
|
|
Binds captured |
|
|
|
|
Contains the name of the module that was executing at the time that the SQL statement was first parsed, which is set by calling |
|
|
|
|
Contains the name of the action that was executing at the time that the SQL statement was first parsed, which is set by calling |
|
|
|
|
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 buffer gets for this child cursor |
|
|
|
|
Number of disk reads for this child cursor |
|
|
|
|
Number of direct writes for this child cursor |
|
|
|
|
Total number of rows that the parsed SQL statement returns |
|
|
|
|
Number of fetches associated with the SQL statement |
|
|
|
|
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 |
|
|
|
|
Cost of this query, given by the optimizer |
|
|
|
|
Optimizer environment |
|
|
|
|
User-defined priority |
|
|
|
|
Oracle command type definition |
|
|
|
|
Timestamp of the parent creation time |
|
|
|
|
Period of time (in seconds) during which the statistics of the SQL statement were collected |
|
|
|
|
Effective period of time (in seconds) during which the SQL statement was active |
|
|
|
|
Client data, specified by the user, for this statement |
|
|
|
|
Timestamp for the plan corresponding to the statistics in this record |
|
|
|
|
|
SQL sequence |
|
|
|
For SQLs captured from the cursor cache, this is the time when the most recent execution of this SQL started |
See Also:
-
“ALL_SQLSET_STATEMENTS”
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_APPLICATION_INFO.SET_MODULEprocedure -
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_APPLICATION_INFO.SET_ACTIONprocedure
