The Application Express engine records activity logs to capture usage and performance data. This information displays in various reports. If a particular page is accessed extensively or a page renders slowly then these reports can help you identify problematic pages. You can then further analyze the problematic pages. For example, you can run a report query in SQL Developer to review the Explain Plan.
Another method of determining expensive elements within a page or process is to review the Application Express Debug mode.
An Instance administrator can delete activity log files and manage the interval at which log file information is retained. If you wish to keep the activity log files indefinitely, you must create a batch job to copy records from the activity log table to another table.
"Managing Logs and Files" in Oracle Application Express Administration Guide
To view the Application Dashboard:
The Application home page appears.
The Application Dashboard appears. The first two regions on the left, Application Overview, and Pages by Types, list detailed information and statistics about the current application. The remaining regions are divided into the following sections:
Security lists the current authentication scheme, number of public and non public pages, and the number of authorization schemes used within the current application.
Templates contains links to reports of templates used within the current application.
Pages by Type lists pages by type.
Application Components contains links to reports of application-level controls and logic, including lists of values, tabs, lists, application items, application processes, and application computations.
Page Components contains links to reports of page-level controls and logic, including items, buttons, processes, regions, branches, validations, and dynamic actions.
Workspace administrators are users who perform administrator tasks specific to a workspace. Workspace administrators can access the following activity reports:
Page Views - Contains reports of page views organized by view, user, application, application and page, day, hour, and by interactive report.
Developer Activity - Offers reports of developer activity organized by developer, day, application, application changes, and day or month.
Page View Analysis - Contains reports analyzing page views, such most viewed pages, page views by day, usage by day (chart), weighted page performance, and Websheet page views.
Sessions - Lists active sessions with the current workspace (report or chart).
Login Attempts - Offers reports listing login attempts, login attempts by authentication result, and a developer login summary.
Environment - Contains reports of environments organized by user agent, browser, external clicks, or operating system.
Application Errors - Contains a report of application errors.
Workspace Schema Reports - Offers summaries of schema tablespace utilization and database privileges by schema, workspace schemas, and report tablespace utilization.
"Monitoring Activity Within a Workspace" in Oracle Application Express Administration Guide
Instance administrators are superusers that manage an entire hosted instance using the Application Express Administration Services application. Instance administrators can access the following activity reports:
"Monitoring Activity Across a Development Instance" in Oracle Application Express Administration Guide and "About Oracle Application Express Administrator Roles"