12.2 E-Business Suite Applications Performance Database Healthcheck Shows SQL Query 'SELECT VALUE FROM V$PARAMETER WHERE NAME = 'utl_file_dir' With Excessive Executions And High CPU Usage
Last updated on MAY 08, 2017
Applies to:Oracle E-Business Suite Technology Stack - Version 12.2 and later
Oracle E-Business Suite Performance - Version 12.2 and later
Information in this document applies to any platform.
E-Business Suite 12.2 Applications Performance, System Tuning related issues
While performing a system health check on the E-Business Suite database, the following query is listed as the top query:
SELECT VALUE FROM V$PARAMETER WHERE NAME = 'utl_file_dir' executing abnormally high number of times in E-Business Suite 12.2.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms