My Oracle Support Banner

Output File Of PLSQL Based Concurrent Requests Are Generated of Size Zero Intermittently (Doc ID 821408.1)

Last updated on JULY 28, 2023

Applies to:

Oracle Concurrent Processing - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Oracle Concurrent Processing - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.
PLSQL Type Concurrent Programs

Symptoms

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 !

Changes

 

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
Changes
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.