Heavy Usage of /TMP Space with DG4MQL 11.2
(Doc ID 1606928.1)
Last updated on FEBRUARY 25, 2022
Applies to:Oracle Database Gateway for SQL Server - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
Information in this document applies to any platform.
While running complex queries the /tmp filesystem is heavily used by the Database Gateway for SQL*Server (DG4MSQL) processes.
Use the following unix commands to verify the usage -
- ps-ef |grep dg4msql
>>>> take note of process id (PID)
- for each PID found with the above command check file descriptors used by the relevant processes -
ls -l /proc/PID_x/fd
- and check file names in /tmp
- while leaving dg4msql running check size with -
ls -l /tmp
On Windows systems, the impacted file system are \temp or the directory specified in user/system enviroment variable as TEMP.
The issue was introduced with 126.96.36.199-188.8.131.52
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