EXA_DBA_AUDIT_SQL
This system table contains all executed SQL statements if auditing is enabled. This system table can be cleared by the statement TRUNCATE AUDIT LOGS. Only users with the SELECT ANY DICTIONARY
system privilege have access to the table.
Column Name | Description |
---|---|
SESSION_ID
|
ID of the session |
STMT_ID
|
Serially numbered ID of statement within a session |
COMMAND_NAME
|
Name of the statement (for example, SELECT , COMMIT ,
or MERGE )
|
COMMAND_CLASS
|
Class of statement (for example, DQL , TRANSACTION ,
or DML )
|
DURATION
|
Duration of the statement in seconds |
START_TIME
|
Timestamp at the start of the statement |
STOP_TIME
|
Timestamp at the stop of the statement |
CPU
|
CPU usage as percentage of total system CPU resources available |
TEMP_DB_RAM_PEAK
|
Maximum usage of temporary DB memory of the query in MiB (overall nodes) |
PERSISTENT_DB_RAM_PEAK
|
Maximum usage of modified, persistent DB memory of the query in MiB (overall nodes) |
HDD_READ
|
Hard disk maximum read ratio in MiB per second (per node, averaged over the duration)
If this value is larger than 0, then data had to be loaded into the main memory. |
HDD_WRITE
|
Hard disk maximum
write ratio in MiB per
second (per node, averaged over the duration)
This column reflects only the data
written during a |
LOCAL_READ_SIZE
|
Total size of data read from local (non-cache) storage in MiB (sum over all nodes) |
LOCAL_READ_DURATION
|
Time spent reading data from local (non-cache) storage in seconds (maximum over all nodes) |
LOCAL_WRITE_SIZE
|
Total size of data written to local (non-cache) storage in MiB (sum over all nodes) This column reflects only the data
written during a |
LOCAL_WRITE_DURATION
|
Time spent writing data to local (non-cache) storage in seconds (maximum over all nodes) This column reflects only the data
written during a |
CACHE_READ_SIZE
|
Total size of data read from cache in MiB (sum over all nodes) |
CACHE_READ_DURATION
|
Time spent reading data from cache in seconds (maximum over all nodes) |
CACHE_WRITE_SIZE
|
Total size of data written to cache in MiB (sum over all nodes) |
CACHE_WRITE_DURATION
|
Time spent in writing data to cache in seconds (maximum over all nodes) |
REMOTE_READ_SIZE
|
Total size of data read from remote storage in MiB (sum over all nodes) |
REMOTE_READ_DURATION
|
Time spent in reading data from remote storage in seconds (maximum over all nodes) |
REMOTE_WRITE_SIZE
|
Total size of data written to remote storage in MiB (sum over all nodes). This column reflects only the data
written during a |
REMOTE_WRITE_DURATION
|
Time spent writing data to remote storage in seconds (maximum over all nodes). This column reflects only the data
written during a |
NET
|
Network traffic ratio in MiB per second (sum of send/receive, per node, averaged over the duration) |
SUCCESS
|
|
ERROR_CODE
|
Error code if the statement failed |
ERROR_TEXT
|
Error text if the statement failed |
SCOPE_SCHEMA
|
Schema that was explicitly opened by means of a connection parameter or OPEN SCHEMA command before statement execution |
CONSUMER_GROUP
|
Consumer group at query start |
NICE
|
NICE attribute |
RESOURCES
|
Share of the CPU allocated to this query, expressed in percentage. This depends on factors such as number of queries running in parallel and consumer groups |
ROW_COUNT
|
Number of result rows for queries, or number of affected rows for DML and DDL statements |
EXECUTION_MODE
|
The following execution modes are supported:
|
CLUSTER_NAME
|
Name of the cluster where the SQL was executed |
SQL_TEXT
|
SQL text limited to 2,000,000 characters |
SNAPSHOT_MODE
|
The snapshot execution mode for this query:
|