Thousands of Zero Byte Files Are Created Under $APPLCSF/$APPLOUT Causing Performance Hit
(Doc ID 2143614.1)
Last updated on DECEMBER 01, 2024
Applies to:
Oracle Concurrent Processing - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]Oracle Concurrent Processing - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.
Reviewed for Relevance 24 Aug 2016.
Symptoms
Around 40,000 zero byte files exists under $APPLCSF/$APPLOUT.
Aproximately 1000 zero byte files are created daily.
These zero byte files are created for programs which don't generate an output.
This is just an example.
=============================
-rw-r--r-- 1 username groupname 0 timestamp oxxxxxx.out
-rw-r--r-- 1 username groupname 0 timestamp oxxxxxx.out
***************************
FNDWFBG module: Workflow Background Process
+---------------------------------------------------------------------------+
Current system time is timestamp
+---------------------------------------------------------------------------+
**Starts**timestamp
**Ends**timestamp
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Successfully resubmitted concurrent program FNDWFBG with request ID xxxxxx to start at timestamp (ROUTINE=AFPSRS)
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
0
******************************************************
*********************** Another case *****************
******************************************************
FNDWFBG module: Workflow Background Process
+---------------------------------------------------------------------------+
Current system time is timestamp
+---------------------------------------------------------------------------+
**Starts**timestamp
**Ends**timestamp
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Successfully resubmitted concurrent program FNDWFBG with request ID xxxxxx to start at timestamp (ROUTINE=AFPSRS)
+---------------------------------------------------------------------------+
Executing request completion options...
Need a way to remove the files or prevent the out files from being created as it is causing a performance hit.
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 |