Thousands of Zero Byte Files Are Created Under $APPLCSF/$APPLOUT Causing Performance Hit

(Doc ID 2143614.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Oracle Concurrent Processing - Version 12.1.3 to 12.2 [Release 12.1 to 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 applprod dba 0 Nov 14 04:17 o2910394.out
-rw-r--r-- 1 applprod dba 0 Nov 14 04:20 o2910395.out


***************************


FNDWFBG module: Workflow Background Process
+---------------------------------------------------------------------------+

Current system time is 14-NOV-2015 04:17:22

+---------------------------------------------------------------------------+

**Starts**14-NOV-2015 04:17:23
**Ends**14-NOV-2015 04:17:23
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Successfully resubmitted concurrent program FNDWFBG with request ID 2910396 to start at 14-NOV-2015 04:20:39 (ROUTINE=AFPSRS)


+---------------------------------------------------------------------------+
Executing request completion options...

Output file size:
0


******************************************************
*********************** Another case *****************
******************************************************


FNDWFBG module: Workflow Background Process
+---------------------------------------------------------------------------+

Current system time is 14-NOV-2015 04:20:07

+---------------------------------------------------------------------------+

**Starts**14-NOV-2015 04:20:07
**Ends**14-NOV-2015 04:20:07
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Successfully resubmitted concurrent program FNDWFBG with request ID 2910397 to start at 14-NOV-2015 04:21:35 (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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms