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