Recent content by epost

  1. Re: Performance issues with Z-File

    RE: Performance issues with Z-File Tim, 2.5 hours is way too long if you are talking about using the Oracle import utility to import data. I can tell you that contention is occuring somewhere regardless of the method being used. There are quite a few things one would have to look at to...
  2. Moonshot and the R47011

    Not sure what I wrote in the prior thread but here is the gist as it stands now. We performed a bunch of testing on Sunday. Results show on 12 CPU box running Oracle and the Enterprise Server that we could obtain 100,000 sales order lines per hour running about 30 simultaneous R47011's with...
  3. Moonshot and the R47011

    The R47011 job creates a tremendous amount of redo, it even updates address book. A lot of the redo could be eliminated if the F42UI11 and F42UI12 tables could be converted to global temporary tables. If the system crashed the EDI job would need to be reprocessed so losing the information in...
  4. Multiple R47011 Jobs Simultaneously

    It will be interesting to see how much of a bottleneck the JDE application is but we are running this on a very powerful system. The commit rate is high with all JDE jobs so Oracle writing to the logs (LGWR) is going to be the bottleneck. If we can clear that up and increase the number of...
  5. Multiple R47011 Jobs Simultaneously

    Assuming no CPU/disk/database bottlenecks, what are thoughts/concerns on running multiple R47011 jobs simultaneously, each with a different data selection to increase total throughput of sales order lines? Thanks, Ethan Post http://www.geocities.com/epost1...
  6. DBA's XE Index Concerns

    RE: DBA\'s XE Index Concerns No, Oracle would name the index something like SYS#@($(@#&$ if a primary key was defined but not named. In B733.1 JDE simply defined unique indexes to enforce the primary key on each table. So the change is that they have made these unique indexes primary keys in...
  7. Citrix not PCAnywhere!!!

    Don't know if anyone has mentioned www.gotomypc.com but it is very cool. I use it to access my system at home. You could go vice versa very easy with no firewall troubles. Great if your on a cable modem and don't want to dial in, of course you better check with the network admins first :)...
  8. DBA's XE Index Concerns

    RE: DBA\'s XE Index Concerns Thanks for the great advice Justin. Steve Adams' has a script that will help you locate redundant indexes also on his site at www.ixora.com.au. If the first three leading columns of an index are the same on two indexes then it is in all likelihood completely...
  9. DBA's XE Index Concerns

    DBA\'s XE Index Concerns Getting my first chance to dig around on an XE install and have a few questions/concerns. I was a bit surprised to find so many indexes at first on a "tables" tablespace. I soon found out that these are all primary keys. A count of indexes shows that in addition to...
  10. F986110 Performance Impact

    Larry, I have used solution #1 in the past to stop the full table scans and it worked about 70% of the time, however there a number of different statements being executed against the table with very low selectivity. The cost based optimizer is rightly deciding to do FTS's in most cases. We...
  11. F986110 Performance Impact

    Oracle 8.0.4.4 B733.1 HPUX 11 All, I have been perplexed for sometime with a problem of the F986110 table and it's related job queue Oracle processes. I have written about this problem in the past and even offered solutions. However upon more investigation I have found other difficulties...
  12. User access logging

    I think on of the tables stores updates the time when they log in, you could put a trigger on the table to log the action, you could also use a log on trigger on your database is it exists on DB2. JDE might have some standard methods for doing this but I just know the DB stuff. - Ethan Post
  13. Incomplete Receipts

    I agree. We have about 60 such integrity scripts which run daily. Check everything from sales orders to inventory to invoicing to the GL. Stuff falls out for all sorts of reasons. I don't really see how anyone could even operate without these types of checks going on on a regular basis. If...
  14. Logically Unique Key on F4111 Table

    select count(*), count(distinct column1 || ' ' || column2 || '' || column3) from proddta.f4111; play around with that, when you get the same number for both columns you have identified another key - Ethan - San Diego, CA - www.FreeOCP.com
  15. RE: RE: Oracle - Deleted PRODB733 Tables

    RE: RE: Oracle - Deleted PRODB733 Tables Brad, Do you mean separate databases or separate tablespaces? - Ethan
Top