Heavy Usage of /TMP Space with DG4MQL 11.2
Last updated on JANUARY 18, 2017
Applies to:Oracle Database Gateway for SQL Server - Version 184.108.40.206 to 220.127.116.11 [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 18.104.22.168-22.214.171.124
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