View Only
  • 1.  Archive and Purge question

    Posted 06-16-2020 12:51 AM
    ​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 03:39 PM
    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 AM
    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 AM

    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.

  • 5.  RE: Archive and Purge question

    OATUG Star Partner
    Posted 12-19-2021 03:01 PM
    Edited by Andy Haack 12-19-2021 03:01 PM
    Hi, I just came across this old question. Is the problem resolved meanwhile?
    From my experience, the ​​#1 performance issue ​of EBS systems is not having the database (SGA+PGA) configured to use all the available physical memory, so that there is more IO wait time than necessary.
    You can use the DBA SGA+PGA Memory Configuration or DBA AWR SQL Performance Summary blitz reports to identify such issues, or DBA Blocking Sessions to identify blocking sessions.
    Or send me a private message and I'm happy to have a quick look if the process is still slow.

    Andy Haack
    Managing Director
    Küsnacht, Switzerland