Defragment workflow related tables in r12 References- 1. How to Reorganize Workflow Tables? (Doc ID 388672.1) 2. EBS Workflow (WF) Analyzer (Doc ID 1369938.1) Points to Remember – Some workflow tables are associated to queues so that it is necessary to use the advance queuing instructions to reorganize them. For tables other than queue tables, please refer to different notes created by RDBMS team to reorganize tables. This activity depends on the RDBMS version. Defragment tables in workflow r12 Verify tables are not associated to queues – SQL> select queue_table from dba_queue_tables 2 where queue_table like '%WF%'; QUEUE_TABLE ------------------------------ WF_CONTROL WF_DEFERRED WF_DEFERRED_TABLE_M WF_ERROR WF_IN WF_INBOUND_TABLE WF_JAVA_DEFERRED WF_JAVA_ERROR WF_JMS_IN WF_JMS_JMS_OUT WF_JMS_OUT WF_NOTIFICATION_IN WF...
