| Oracle 11g high memory usage dbw0 and dbw1 [message #562317] |
Tue, 31 July 2012 05:21  |
preet_kumar
Messages: 204
Registered: March 2007
|
Senior Member |
|
|
We are using the 11g AMM feature and Memory_Target set to 96GB and total RAM on the Server is 128GB
Now the top and free shows up only 200MB memory free on the system.
There are 2 process dbw0 and dbw1 which consumes the top memory and this is 30GB per dbw.
Why is the dbw process taking up so much memory when there is not much load on the database.
Thanks
Preet
|
|
|
|
|
|
| Re: Oracle 11g high memory usage dbw0 and dbw1 [message #562323 is a reply to message #562321] |
Tue, 31 July 2012 05:45  |
preet_kumar
Messages: 204
Registered: March 2007
|
Senior Member |
|
|
Below given the copy paste from a test system which is having total 32GB RAM with same problem
TOP
Mem: 32868276k total, 32512932k used, 355344k free, 612780k buffers
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
4123 oracle 20 0 9871m 5.2g 5.2g S 0.0 16.7 3:48.30 oracle
4121 oracle 20 0 9871m 5.0g 5.0g S 0.0 16.0 3:42.17 oracle
Free
total used free shared buffers cached
Mem: 32868276 32526976 341300 0 612796 29244004
-/+ buffers/cache: 2670176 30198100
Swap: 33638392 19596 33618796
$ps -ef|grep 4123
00:03:48 ora_dbw1_11g
$ps -ef|grep 4121
00:03:42 ora_dbw0_11g
[Edit MC: add code tags and align columns]
[Updated on: Tue, 31 July 2012 06:03] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
