SYSTEMSQLAREA: Data Dictionary SQL Statements Executed
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: SQL Statements Executed
All SQL statements executed by Invantive's UniversalSQL engine.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMSQLAREA are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
EXECUTIONS |
int32 |
Executions | Number of executions. | ||
FINGER_ |
varchar2 |
Finger Print | Unique finger print | ||
FIRST_ |
datetime |
First End Time | Time at which the SQL was first executed (UTC). | ||
FIRST_ |
datetime |
First Start Time | Time at which the SQL was first executed (UTC). | ||
ID |
guid |
ID | Unique ID. | ||
LAST_ |
datetime |
Last End Time | Time at which the SQL was last executed (UTC). | ||
LAST_ |
datetime |
Last Start Time | Time at which the SQL was last executed (UTC). | ||
MANAGED_ |
int32 |
Managed Thread ID | Managed thread ID. | ||
NUMBER_ |
int32 |
Number of Fields | Number of fields in the result set. | ||
NUMBER_ |
int32 |
Number of Managed Threads | Number of managed threads. | ||
NUMBER_ |
int32 |
Number of Requests | Number of requests. | ||
NUMBER_ |
int32 |
Number of Tasks | Number of tasks. | ||
PARAMETER_ |
varchar2 |
Parameter Values | Parameter values. | ||
REQUEST_ |
varchar2 |
Request ID | Request ID. | ||
ROW_ |
int64 |
Rows | Number of rows retrieved. | ||
SQL_ |
varchar2 |
SQL Statement | SQL statement. | ||
TASK_ |
int32 |
Task ID | Task ID. |
Referenced By
- SESSIONIOS
STATEMENT_ID(Textual) - SYSTEMSQLEXECUTIONS
STATEMENT_ID(Key) - SYSTEMSQLEXECUTIONSLEEPS
STATEMENT_ID(Key) - SYSTEMSQLEXECUTIONSTEPS
STATEMENT_ID(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: