Table 42. Usage Tracking Data
|
|
CACHE_IND_FLG |
Default is N. Y indicates a cache hit for the query, N indicates a cache miss. |
COMPILE_TIME_SEC |
The time in seconds required to compile the query. |
CUM_DB_TIME_SEC |
The total amount of time in seconds that the Oracle BI Server waited for back-end physical databases on behalf of a logical query. |
CUM_NUM_DB_ROW |
The total number of rows returned by the back-end databases. |
END_DT |
The date the logical query was completed. |
END_HOUR_MIN |
The hour and minute the logical query was completed. |
END_TS |
The date and time the logical query finished. The start and end timestamps also reflect any time the query spent waiting for resources to become available. |
ERROR_TEXT |
Default is Null. Varchar(250) Error message from the back-end database. This column is only applicable if the SUCCESS_FLG is set to a value other than 0 (zero). Multiple messages will concatenate and will not be parsed by Oracle BI Server. |
NODE_ID |
Reserved for future use. |
NUM_CACHE_HITS |
Default is Null. Number(10,0). NOTE: For DB2, the data type and length is Decimal(10,0).
Indicates the number of times existing cache was returned. |
NUM_CACHE_INSERTED |
Default is Null. Number(10,0). NOTE: For DB2, the data type and length is Decimal(10,0).
Indicates the number of times query generated cache was returned. |
NUM_DB_QUERY |
The number of queries submitted to back-end databases in order to satisfy the logical query request. For successful queries (SuccessFlag = 0) this number will be 1 or greater. |
PRESENTATION_NAME |
Default is Null. Varchar(128) Name of the Presentation Catalog in Oracle BI Presentation Services. |
QUERY_SRC_CD |
The source of the request, for example, Drill or Report. |
QUERY_TEXT |
The SQL submitted for the query. |
REPOSITORY_NAME |
The name of the repository the query accesses. |
ROW_COUNT |
The number of rows returned to the query client. |
RUNAS_USER_NAME |
Default is Null. Varchar(128) User Id of impersonated user. If the request is not run as an impersonated user, the value will be NULL. |
SAW_DASHBOARD |
Path of the dashboard. If the query was not submitted through an Interactive Dashboard, the value will be NULL. |
SAW_DASHBOARD_PG |
Default is Null. Varchar(150) Page name in the Interactive Dashboard. If the request is not a dashboard request, the value will be NULL. |
SAW_SRC_PATH |
The path name in the Oracle BI Presentation Catalog for the request. |
START_DT |
The date the logical query was submitted. |
START_HOUR_MIN |
The hour and minute the logical query was submitted. |
START_TS |
The date and time the logical query was submitted. |
SUBJECT_AREA_NAME |
The name of the business model being accessed. |
SUCCESS_FLG |
The completion status of the query: 0 - The query completed successfully with no errors. 1 - The query timed out. 2 - The query failed because row limits were exceeded. 3 - The query failed due to some other reason. |
TOTAL_TIME_SEC |
The time in seconds that the Oracle BI Server spent working on the query while the client waited for responses to its query requests. |
USER_NAME |
The name of the user who submitted the query. |