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.