Functions and Views for All Products > apt_v_execution_tracking
  
Version 10.0.01
apt_v_execution_tracking
The data in the apt_v_execution_tracking view provides a historical record of the execution of report templates. This view provides a means of identifying slow-running reports.
Table 5 apt_v_execution_tracking
Column Name
Data Type
Description
db_elapsed_time_ms
NUMBER
Time taken for database access
elapsed_time_ms
NUMBER
Elapsed time in milliseconds
page_size
NUMBER
Page size
params
STRING
Report parameters
report_template_id
NUMBER
Report Template ID
report_template_name
STRING
Report Template Name
system_name
STRING
System name
transaction_timestamp
DATE
Transaction timestamp
ui_elapsed_time_ms
NUMBER
Time taken for user-interface processing
user_id
NUMBER
User ID
user_name
STRING
User Name