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

(Doc ID 2261558.1)

Last updated on MARCH 09, 2018

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.1.3 and later
Oracle E-Business Suite Performance - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms