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 vote312 views1 answer
Mysql timeout 30 seconds
SQL
0 vote351 views1 answer
Ajax error exception handeling
SQL
6 votes375 views2 answers
Mysql execute file
SQL
31 votes363 views2 answers
Grant all priviledges to mysql user
SQL
34 votes416 views6 answers
Alter table add foreign key mysql
SQL
22 votes336 views3 answers
Sql cheat sheet
SQL
0 vote359 views1 answer
Postgresql show owner of database
SQL
0 vote317 views1 answer
Oracle list dblink
SQL
5 votes404 views1 answer
Oracle get ddl
SQL
2 votes347 views2 answers
How to check data type in sql server
SQL