My Oracle Support Banner

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 OCTOBER 08, 2019

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.


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.