Expand all | Collapse all

Archive and Purge question

  • 1.  Archive and Purge question

    Posted 06-16-2020 00:51
    ​We are trying Purge Order management and AR tables using standard programs.. Both of them are having performance issues.. Could you please advise if anyone has come across this problem? If Yes, Did Oracle help you with improving the performance or did you guys develop custom solution.. Please advise..

    Thank you very much,,

    Sri Naga Venkata Krishna Kancharla
    Senior Functional Analyst
    First American Financial Corporation
    Santa Ana CA
    (714) 250-3128

  • 2.  RE: Archive and Purge question

    Posted 06-17-2020 15:39
    It is not unheard of for the standard programs to take a long time if this is the first time running them.  It is a good idea to always run gather schema stats before the purge programs run.  The purge programs also have very low priority and if the Invoice Workbench or Order Entry forms are open, they will just wait to acquire locks on the tables.  

    Jason Lim
    Centric Consulting
    (614) 314-3946​
    Follow us: LinkedIn | Twitter | Facebook

    Jason Lim
    Centric Consulting
    O: (888) 781-7567 | M: (614) 314-3946
    Follow us: LinkedIn | Twitter | Facebook

  • 3.  RE: Archive and Purge question

    GEO Leader
    Posted 06-18-2020 07:19
    Another thing to look at is to do them in smaller batches if you have not done so and the standard job has parameters to pick subsets of the data.  That reduces the amount of redo being generated as you said you have not run this prior.

    Joseph Imbimbo
    Oracle Applications DBA
    PPG Industries, Inc.
    Pittsburgh PA
    (412) -7193

  • 4.  RE: Archive and Purge question

    Posted 06-18-2020 08:52

    These programs should always be executed during off peak hours.  I do not recollect the exact details, but if there are parameters then provide with the smallest range. Also execute them in a lower instance to get a sense of timing.




    McGraw-Hill logo.

    Rajeev Malkan

    McGraw-Hill |Manager, ERP Support & SCM - Global Technology Services

    860 Taylor Station Rd. Blacklick, OH 43004

    P: (380) 202-3250|C: (614) 806-1125 * |



    The information contained in this message may be confidential and/or constitute a privileged attorney-client document.  If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.  If you have received this communication in error, please notify McGraw-Hill immediately by replying to the message and deleting it from your computer.  Thank you.