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 11.2.0.2 to 11.2.0.4 [Release 11.2]Information in this document applies to any platform.
Symptoms
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.
Changes
The issue was introduced with 11.2.0.2-11.2.0.3
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 |