Reference Guide > TDV and Business Directory System Tables > SYS_REQUESTS
 
SYS_REQUESTS
The SYS_REQUESTS system table provides a list of current and recent requests and their current status.
Users see no rows unless they have the ACCESS_TOOLS right. If they have this right, they see rows for all requests they own. Users with both ACCESS_TOOLS and READ_ALL_STATUS rights can see all rows.
Column
TDV
JDBC Data Type
Nullable
Description
REQUEST_ID
BIGINT
 
The request's ID.
PARENT_ID
BIGINT
Yes
The parent request’s ID. NULL if there is no parent request.
SESSION_ID
BIGINT
 
The request's session ID.
TRANSACTION_ID
BIGINT
 
The request's transaction ID.
OWNER_ID
INTEGER
 
The request session’s user ID.
OWNER
VARCHAR(255)
 
The request session’s user name.
REQUEST_TYPE
VARCHAR(255)
 
The request type. For example, SQL or SQL Script.
STATUS
VARCHAR(20)
 
The request status can be one of the following:
STARTED—The request is in the process of starting. This status usually lasts only a short time.
WAITING—The request is waiting for enough system resources to start running.
RUNNING—The request is currently executing.
READY—The request has completed execution and results are available.
CLOSING—The request is in the process of closing. This status usually lasts only a short time.
SUCCESS—The request was completed successfully.
FAILED—The request failed.
TERMINATED—The request was terminated.
DESCRIPTION
VARCHAR(65535)
 
The request’s source, or a description of what was called.
START_TIME
TIMESTAMP
 
The time when the request started.
END_TIME
TIMESTAMP
 
The time when the request ended. NULL if it is still running.
TOTAL_DURATION
BIGINT
 
The number of milliseconds the request required to execute.
SERVER_DURATION
BIGINT
 
The number of milliseconds of server-side time that elapsed during request execution.
ROWS_AFFECTED
BIGINT
 
The number of rows affected by the request. For SQL SELECT statements, this is the number of rows read. For other requests, this is the number of rows modified. A value of -1 indicates that the number is not known.
MAX_MEMORY
BIGINT
Yes
The maximum amount of memory reserved by the request during execution.
MAX_DISK
BIGINT
Yes
The maximum amount of disk used by the request during execution.
CURRENT_MEMORY
BIGINT
 
The current amount of memory reserved by the request.
CURRENT_DISK
BIGINT
Yes
The current amount of disk in use by the request.
MESSAGE
VARCHAR(65535)
Yes
A message that is usually set on failure to provide additional information. NULL if no message is available.
MAX_USED_MEMORY
BIGINT
 
The maximum amount of memory used by the request during execution.
CURRENT_USED_MEMORY
BIGINT
 
The current amount of memory in use by the request.