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.
The purpose of this document is to describe some performance and configuration settings for Oracle Database with relation to JDEdwards EnterpriseOne.
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
|Scenario 1: Performance Improvements on Oracle and SQL Server Utilizing Update Statistics|
|Scenario 2: Tuning Oracle Database Connections for Performance for EnterpriseOne|
|Scenario 1: Oracle Table Partitioning|
|Scenario 2: Is Oracle Database "Parallel Query" Supported with EnterpriseOne?|
|Scenario 3: Identifying long-running SQL Queries.|
|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?|