Tag Archives: reduce process memory in Windows

Reduce memory consumption of Oracle in Windows environment in Oracle

Reduce memory consumption of Oracle in Windows environment

1. Each thread within Oracle process is provided 1 MB reserved stackspace
You can reduce to 500k without consequence. It will result in less memory consumption in Windows Environment.

Reduce process memory to 500K by orastack command:

C:\> orastack tnslsnr.exe 500000

C:\> orastack oracle.exe 500000

c:\> orastack svrmgrl.exe 500000

c:\> orastack sqlplus.exe 500000

Note: Stop processes before running Orastack

2. If you apply patch please re-run orastack

3. Before apply please do a testing on test environment.