Oracle VSS Memory Leak Issue
Oracle volume shadow copy service is used for taking backup in window platform.
“OracleVssWriter” service which is used by third party tool for configuring backup (Its having issue with memory leakage).
It’s automatically configured and ran during creation of database with DBCA utility.
Error faced on windows platform checked on event viewer:
Windows successfully diagnosed a low virtual memory condition.
The following program consumed the most virtual memory : oravssw.exe
oravssw.exe process is listed as top processes consuming virtual memory on my Windows server 2008.
Know the status of job from command window:
oravssw {/q [/start | /stop | /status]
Please refer to the oracle Doc ID:
“Instance Crash Or ORA-04030 Errors When Pagefile Is Full (Doc ID 1358570.1)”
Cause
Bug 9063341 – MEMORY LEAK OCCURS FROM ORAVSSW.EXE EVERY TIME BACKUP JOB HAS DONE.
The problem is caused by a memory leak in the Oracle Volume Shadow Copy Service.
Solution
There is no exact fix for this issue.
If not using the Windows Volume Shadow Copy Service (VSS) feature, then simply stop and disable the ORAVSSW.EXE service in services.msc.
If VSS is being used, then simply stop and restart the ORAVSSW.EXE service after performing your disk shadow backup.