4.101 ALL_SQLSET_STATEMENTS
ALL_SQLSET_STATEMENTS
displays information about the SQL statements, along with their statistics, that form all SQL tuning sets accessible to the current user.
Related Views
-
DBA_SQLSET_STATEMENTS
displays information about the SQL statements, along with their statistics, that form all SQL tuning sets in the database. -
USER_SQLSET_STATEMENTS
displays information about the SQL statements, along with their statistics, that form the SQL tuning sets owned by the current user. This view does not display theSQLSET_OWNER
column.
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 |
|
|
|
Hash value for the plan corresponding to statistics in this record |
|
|
|
Bind data |
|
|
|
Binds captured |
|
|
|
Contains the name of the module that was executing when the SQL statement was first parsed, which is set by calling |
|
|
|
Contains the name of the action that was executing when 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 |
|
|
|
Time (in seconds) during which the statistics of the SQL statement were collected |
|
|
|
Effective 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 |
|
|
Amount of shared memory used by the child cursor (in bytes) |
|
|
|
Signature calculated on the normalized SQL text. The normalization includes the removal of white space and the uppercasing of all non-literal strings. |
|
|
|
Number of result cache executions |
|
|
|
SQL profile used for this statement, if any |
|
|
|
SQL plan baseline used for this statement, if any |
|
|
|
SQL patch used for this statement, if any |
|
|
|
Average hard parse time (in microseconds) used by this cursor |
|
|
|
User I/O Wait Time (in microseconds); updated as the statement executes |
|
|
|
Number of I/O bytes exchanged between Oracle Database and the storage system |
|
|
|
Name of the parsing user |
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