E1: DB: How To Identify The EnterpriseOne Oracle Database Tables That Have Long Execution Time For Data Definition Language (DDL)? And How To Determine The Table Columns If They Are Indexed or Non-indexed ?
(Doc ID 2321260.1)
Last updated on AUGUST 18, 2021
Applies to:
JD Edwards EnterpriseOne Tools - Version 9.1 and later Information in this document applies to any platform.
Purpose
This document shows you how to perform the following actions with regard to EnterpriseOne Oracle Database Server:
Identifying EnterpriseOne Oracle database tables that have long execution time for data definition language (DDL), namely the creation of tables, indexes, and data manipulation language (DML) operations such as select, insert, delete, and update database activities.
Identifying EnterpriseOne Oracle database table columns and determining if they are indexed or non-indexed.
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!