6.379 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:
-
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