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 laterOracle 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
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
Symptoms |
Cause |
Solution |
References |