> Oracle PUBLIC Access
> Oracle Security Architecture
> JDE Bolt-Ons
> JDE Oracle Refreshes
> JDE Job Performance
> JDE Oracle Performance

>JDE Oracle Performance

Because JDE is not optimized for Oracle, it does not perform operations on sets of data at a time. It tends to operate on Oracle data a single record-at-a-time, which presents unique challenges to the Oracle DBA as historical data accumulates in the database.

DBConnect Solutions has extensive experience evaluating database performance and addressing performance issues through the use of Oracle statistics, including histograms and SQL profiles, as well as setting up appropriate techniques for calculating Oracle statistics. We have also written data archival utilities to move data from a master set of JDE Oracle tables to archival tables to maintain good performance within the system.

Interested or have questions? Call or email us.