SYSTEMSQLEXECUTIONS: Data Dictionary SQL Executions
read only
- Catalogue :
DataDictionary - Schéma :
Invantive - Label: SQL Executions
All SQL statement executions, executed by Invantive's UniversalSQL engine.
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table SYSTEMSQLEXECUTIONS sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
BILLING_ |
varchar2 |
ID de facturation | ID for billing. | ||
DATA_ |
varchar2 |
ID du conteneur de données | Data container ID. | ||
DURATION_ |
double |
Durée (ms) | Duration (ms). | ||
DURATION_ |
int64 |
Durée (ticks) | Duration (ticks). | ||
END_ |
datetime |
Heure de fin | Time at which the SQL fetch was completed (UTC). | ||
GUI_ |
varchar2 |
Adresse IP externe GUI | External IP address of the GUI application. | ||
GUI_ |
uint16 |
Port IP externe de la GUI | External IP port of the GUI application. | ||
HEAP_ |
int64 |
Nombre d'octets alloués dans le tas | Number of bytes allocated on the managed heap by the execution: the sum over the outermost step of every statement of the batch, plus what the workers of a parallel clause allocated on their own threads.Counts bytes allocated rather than bytes retained, so it never decreases. | ||
ID |
guid |
ID | Unique ID of the execution. | ||
INBOUND_ |
varchar2 |
Identifiants de corrélation entrants | Inbound correlation IDs. | ||
IO_ |
int64 |
Octets reçus | Number of bytes received using I/O. | ||
IO_ |
int64 |
Octets envoyés | Number of bytes sent using I/O. | ||
IO_ |
double |
Durée des opérations d'E/S (ms) | Duration of I/O (ms). | ||
IO_ |
int32 |
Nombre de Partitions | Number of partitions accessed through I/O. | ||
IO_ |
int64 |
Nombre de lignes d'E/S | Number of rows retrieved using I/O. | ||
MANAGED_ |
int32 |
ID du fil géré | Managed thread ID. | ||
PARAMETER_ |
varchar2 |
Valeurs de paramètre | Parameter values. | ||
REQUEST_ |
varchar2 |
ID de demande | Request ID. | ||
RESULT_ |
varchar2 |
Nom de l'ensemble de résultats | Name of result set. | ||
ROW_ |
int64 |
Rows | Number of rows retrieved. | ||
SQL_ |
varchar2 |
Instruction SQL | SQL statement. | ||
START_ |
datetime |
Heure de début | Time at which the SQL fetch was started (UTC). | ||
STATEMENT_ |
varchar2 |
Empreinte digitale | Unique finger print of the SQL statement. | ||
STATEMENT_ |
guid |
Référence de la déclaration | Unique ID of the SQL statement. | ||
TASK_ |
int32 |
ID de Tâche | Task ID. | ||
THREAD_ |
int64 |
Temps CPU du thread (ns) | CPU time in nanoseconds, kernel plus user, which the operating system charged to the threads of the execution, including the workers of a parallel clause.CPU time spent rather than wall clock, so a statement which put four workers to work can report more nanoseconds than it lasted. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
SYSTEMSQLEXECUTIONS_ |
STATEMENT_ |
SYSTEMSQLAREA.ID |
Key |
Référencée
- SESSIONIOS
EXECUTION_ID(Textual) - SYSTEMSQLEXECUTIONSLEEPS
EXECUTION_ID(Key) - SYSTEMSQLEXECUTIONSTEPS
EXECUTION_ID(Key)
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :