E1: DB: Guide to Performance Questions and Configuration Settings for EnterpriseOne and Oracle Database
(Doc ID 1527286.1)
Last updated on MAY 03, 2023
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 |