RE: Performance issues with Z-File
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...
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...
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...
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...
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?
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...
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 :)...
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...
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...
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...
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...
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
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...
select count(*), count(distinct column1 || ' ' || column2 || '' || column3)
play around with that, when you get the same number for both columns you
have identified another key
- San Diego, CA