Prev
Next
Forums Integration / Customization S3 Customization/Development

long running program

 4 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Sheila Kendall
Advanced Member
Posts: 29
Advanced Member
6/21/2012 10:25 PM
    We have two custom programs that read in PMTOUT.  One program read the employee table to get the employee status (so was a direct read).  On one server/productline,  it took 17 minutes.  On the other productline (productin unfortunately),  it took 1 and 1/2 hours.  Then we took the database read out, so that it was just reading in PMTOUT and writing out a revised PMTOUT.  It now takes 5 seconds in both productlines.
    The second program is similar but we need to keep the database reads in (to read a history table).  It takes 1 1/2 hours in one server and 5 hours on the other.

    Our system staff do not see any unusual activity.  ANy clues anyone? 

    THis is by the way, since we went to 9.0.1 application and environment, Oracle 11 g and we are on AIX 6
    Ragu Raghavan
    Veteran Member
    Posts: 476
    Veteran Member
    6/21/2012 10:51 PM
      did you try running the verifyoraxx utlility ? That may show any missing indices.
      Sheila Kendall
      Advanced Member
      Posts: 29
      Advanced Member
      6/30/2012 1:22 AM
        Yes,  the dba checked that.  We are also having intermittent performance issues with online access.  Not sure if they are related or not.    We have all of the environment patches in at this point.
        JudeBac
        Veteran Member
        Posts: 129
        Veteran Member
        6/30/2012 1:55 AM
          Add the company code, then the employee number. This will help you index

          David Arago
          Basic Member
          Posts: 4
          Basic Member
          6/30/2012 1:57 AM
            I am on vacation until July 9th. If you need help please e-mail the helpdesk.