Reference Guide > TDV and Business Directory System Tables > SYS_STATISTICS
 
SYS_STATISTICS
The SYS_STATISTICS system table provides a list of current and recent sessions 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 resources for which they have READ privilege. Users with both ACCESS_TOOLS and READ_ALL_STATUS rights can see all rows.
Column
TDV JDBC Data Type
Nullable
Description
RESOURCE_ID
INTEGER
 
The resource ID.
RESOURCE_NAME
VARCHAR(255)
 
The resource name.
RESOURCE_TYPE
VARCHAR(255)
 
The resource type. Can be TABLE or DATASOURCE.
OWNER_ID
INTEGER
 
Owner’s user ID.
OWNER
VARCHAR(255)
 
Owner’s name.
PARENT_PATH
VARCHAR(255)
 
Path to the folder that contains the resource.
IS_ENABLED
VARCHAR(20)
 
Indicates if statistics data will be used. Can be true or false.
STATUS
VARCHAR(20)
 
Statistics status: STALE, NOT_LOADED, FAILED, UNKNOWN, or UP.
LAST_REFRESH_END
TIMESTAMP
 
The time the last gather process finished.
LAST_SUCCESS_END
TIMESTAMP
 
The last time gather process finished successfully.
LAST_FAIL_END
TIMESTAMP
 
The last time gather process finished with an error.
LAST_SUCCESS_DURATION
BIGINT
 
Elapsed time (in milliseconds) of the last successful statistics gather process.
LAST_FAIL_DURATION
BIGINT
 
Elapsed time (in milliseconds) of the last failed statistics gather process.
NUM_SUCCESS
INTEGER
 
Number of times stats data was successfully refreshed since last server start.
NUM_FAIL
INTEGER
 
Number of times statistics data failed to refresh since the last time the server started.
MESSAGE
VARCHAR(255)
 
Message that provides additional information for some status types.
CURRENT_REFRESH_START
TIMESTAMP
Yes
The time currently running stats gather process started. NULL if not currently running.
CURRENT_DURATION
BIGINT
Yes
Elapsed time of currently running stats gather process. NULL if not currently running.