Oracle apex charging debug

SELECT adb.APEX_USER,
       adb.APPLICATION_ID, wal.APPLICATION_NAME, adb.PAGE_ID,
       adb.MESSAGE, adb.MESSAGE_TIMESTAMP,
       adb.PAGE_VIEW_ID, adb.SESSION_ID
FROM APEX_WORKSPACE_ACTIVITY_LOG wal
INNER JOIN APEX_DEBUG_MESSAGES adb
ON wal.DEBUG_PAGE_VIEW_ID = adb.PAGE_VIEW_ID;

Source: blogs.infomentum.com

Oracle apex charging debug

SELECT * FROM APEX_WORKSPACE_ACTIVITY_LOG 
    WHERE WORKSPACE = 'wks_name'
    AND APEX_USER = 'user_name'
    AND APPLICATION_ID = 'app_id';
    
SELECT * FROM APEX_DEBUG_MESSAGES;

Source: blogs.infomentum.com

Similar codes

0 vote378 views1 answer
Delete hangfire retries list
SQL
5 votes319 views1 answer
How to check port number for postgresql
SQL
0 vote341 views1 answer
Kill mysqld_safe process mariadb
SQL
19 votes363 views5 answers
Display table in sql
SQL
6 votes339 views1 answer
Identify primary key in oracle table
SQL
1 vote376 views1 answer
How to set up a trigger in sql
SQL
0 vote338 views1 answer
Search mysql database for column
SQL
0 vote324 views1 answer
Sql_inner_join
SQL
1 vote341 views1 answer
Mysql drop key
SQL
0 vote313 views1 answer
Linked server delete openquery
SQL