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 |
PERSISTENT_DB_RAM_PEAK |
Maximum
usage of modified, persistent DB memory of the query in MiB |
HDD_READ |
Hard disk 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 write ratio in MiB per
second (per node, averaged over the duration)
This column reflects only the data written during a COMMIT. For other statements its value is NULL. |
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 where the user was located |
PRIORITY | Priority 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:
|
SQL_TEXT | SQL text limited to 2,000,000 characters |