3.12.11.1.13 Displaying Application Usage
View a summary of APEX application usage.
To see summary information about recent usage of your APEX applications, use the command apex log
.
SQL> apex log
WORKSPACE APPLICATION_ID APPLICATION_NAME PAGE_VIEWS TOTAL_ELAPSED_TIME AVERAGE_ELAPSED_TIME MINIMUM_ELAPSED_TIME MAXIMUM_ELAPSED_TIME
_________ ______________ ________________ __________ __________________ ____________________ ____________________ ____________________
EXAMPLES 4000 290 335.007 1.15519655172413793 0.017 45.768
EXAMPLES 4550 7 4.344 0.62057142857142857 0.391 0.93
EXAMPLES 4350 5 6.192 1.2384 0.042 2.689
EXAMPLES 4500 5 4.399 0.8798 0.167 2.335
EXAMPLES 4020 24 20.102 0.83758333333333333 0.037 15.437
EXAMPLES 113 List Examples 71 15.63 0.22014084507042214 0.025 2.21
Information also appears for the APEX applications comprising the App Builder itself. These internal applications have ID numbers in the 4000's range. You can
gain additional usage insights by directly querying the APEX dictionary view APEX_WORKSPACE_LOG_SUMMARY
.
Parent topic: Exporting and Importing Using SQLcl