• Search Forums
    Advanced Search
Prev
Next
Forums Integration / Customization S3 Customization/Development

long running program

 4 Replies
 0 Subscribed to this topic
 18 Subscribed to this forum
Sort:
Author
Messages
Sheila Kendall
New Member
Posts: 0
New 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: 477
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
6/21/2012 10:51 PM
did you try running the verifyoraxx utlility ? That may show any missing indices.
Sheila Kendall
New Member
Posts: 0
New 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
New Poster
New Poster
Congrats on posting!
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.