APEX 4.0: New Columns in APEX_WORKSPACE_ACTIVITY_LOG
Over a year ago I wrote about how to permanently store some of the log information from APEX: http://www.talkapex.com/2009/05/apex-logs-storing-log-data.html APEX 4.0 has some additional columns in APEX_WORKSPACE_ACTIVITY_LOG which you may want to store as well. The following query identifies the new columns:
Note: This query assumes you still have an old instance of APEX 3.2 and a new instance of APEX 4.0 on your database
SELECT column_name FROM all_tab_columns WHERE owner = 'APEX_040000' AND table_name = 'APEX_WORKSPACE_ACTIVITY_LOG' MINUS SELECT column_name FROM all_tab_columns WHERE owner = 'APEX_030200' AND table_name = 'APEX_WORKSPACE_ACTIVITY_LOG' ORDER BY column_nameIn case you don't have an old 3.2 instance on your database the new columns are:
CONTENT_LENGTH INTERACTIVE_REPORT_ID IR_SAVED_REPORT_ID IR_SEARCH WS_APPLICATION_ID WS_DATAGRID_ID WS_PAGE_ID
If you permanently store the log information you may want to update your tables and scripts to store the new information.