My Oracle Support Banner

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

Last updated on FEBRUARY 24, 2019

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


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