My Oracle Support Banner

E1: DB: Guide to Performance Questions and Configuration Settings for EnterpriseOne and Oracle Database (Doc ID 1527286.1)

Last updated on JUNE 29, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 to 9.2 [Release SP24 to 9.2]
Information in this document applies to any platform.



Purpose

 The purpose of this document is to describe some performance and configuration settings for Oracle Database with relation to JDEdwards EnterpriseOne.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Performance Concepts
 Scenario 1: Performance Improvements on Oracle and SQL Server Utilizing Update Statistics
 Scenario 2: Tuning Oracle Database Connections for Performance for EnterpriseOne
 Performance Options
 Scenario 1: Oracle Table Partitioning
 Scenario 2: Is Oracle Database "Parallel Query" Supported with EnterpriseOne?
 Scenario 3: Identifying long-running SQL Queries.
 Database Configuration
 Scenario 1: Oracle Database and National Charactersets  
 Scenario 2: Oracle Database Unlimited Value In User Profile Idle Time Setting For JDE Proxy User
 Scenario 3: How to Kill INACTIVE Sessions in an Oracle Database
 Scenario 4: Impact of Locking Default Oracle Database User Accounts on EnterpriseOne
 Scenario 5: Does EnterpriseOne Use '_optim_peek_user_binds'
 Scenario 6: When update statistics is running, is it ok to use the tables?
 Scenario 7: Is It possible to run update statistics for multiple tables simultaneously?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.