With Empower, Oracle's TEMP file grows very fast and continuously - WKB194003
Article number: 194003
SYMPTOMS
- TEMP file grows to 32GB in one or two days
- If another file is added, the second file also grows in one to two days
ENVIRONMENT
- Empower 3 FR5 Enterprise
- Vmware virtual machine
- waters_connect
CAUSE
There was heavy swapping registered in the alert.log. RAM memory was set very low (8GB) and was shared (not dedicated) in the virtual machine.
FIX or WORKAROUND
- In the Vcenter, check the properties of the Virtual Machine and select "Reserve all guest memory".
- Expand the RAM memory to 16 GB. In the standard installation, only Oracle is consuming more than 8 GB.
ADDITIONAL INFORMATION
id194003, SUPWC