Thousands of Zero Byte Files Are Created Under $APPLCSF/$APPLOUT Causing Performance Hit (Doc ID 2143614.1)

Last updated on OCTOBER 28, 2023

Applies to:

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

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