2 Replies Latest reply on May 9, 2017 12:10 PM by Shaik

    WF tables huge growth

    Shaik

      Hi All

       

       

      Architecture:

      OS: Hp Unix Itanium 11.31

      Database: 11.2.0.3 - two node rac

      Apps: R12.1.3

       

      I observed huge growth in WF tables which mentioned below , due to this we are getting peformance issues in Workflow

       

      • wf_items
      • wf_item_activity_statuses
      • wf_item_activity_statuses_h
      • wf_item_attribute_values
      • wf_notifications
      • wf_notification_attributes
      • wf_comments

       

      Here i followed the steps from Note 1587923.1 - How to Close and Purge excessive WFERROR workflows and DEFAULT_EVENT_ERROR notifications from Workflow and reduced the records in wf_notifications but size not released, later i executed "alter table wf_notifications shrink space;"  and size released from 700 mb to 90mb.

       

       

      Please suggest for other tables how we can achieve the same result.

       

       

      Regards

      Shaik