Output File Of PLSQL Based Concurrent Requests Are Generated of Size Zero Intermittently
Last updated on OCTOBER 20, 2017
Applies to:Oracle Concurrent Processing - Version 22.214.171.124 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
PLSQL Type Concurrent Programs
***Checked for relevance on 20-Oct-2017***
Output files of zero file size are generated intermittently for PLSQL based concurrent programs. The issue vanishes temporarily when you restart the concurrent managers however it starts happening again after sometime.
Also observed that when issue happens the same temporary file is being used. The below SQL can be used to verify the usage of temp file when launching the concurrent programs.
As can be seen the temp file name for all the requests are *1016752.tmp.This is a problem !
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms