invantive documentation
Invantive Support ForumsLog In / Sign Up

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_PRINT varchar2(240) Finger Print Unique finger print
FIRST_END_TIME datetime First End Time Time at which the SQL was first executed (UTC).
FIRST_START_TIME datetime First Start Time Time at which the SQL was first executed (UTC).
ID guid ID Unique ID.
LAST_END_TIME datetime Last End Time Time at which the SQL was last executed (UTC).
LAST_START_TIME datetime Last Start Time Time at which the SQL was last executed (UTC).
MANAGED_THREAD_ID int32 Managed Thread ID Managed thread ID.
NUMBER_OF_FIELDS int32 Number of Fields Number of fields in the result set.
NUMBER_OF_MANAGED_THREADS int32 Number of Managed Threads Number of managed threads.
NUMBER_OF_REQUESTS int32 Number of Requests Number of requests.
NUMBER_OF_TASKS int32 Number of Tasks Number of tasks.
PARAMETER_VALUES varchar2(4000) Parameter Values Parameter values.
REQUEST_ID varchar2(60) Request ID Request ID.
ROW_COUNT int64 Rows Number of rows retrieved.
SQL_STATEMENT varchar2 SQL Statement SQL statement.
TASK_ID int32 Task ID Task ID.

Referenced By

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: