Dec 2, 2003 #1 fmorel Programmer Apr 24, 2002 123 CH Hi all! A database process, ora_dbw0_MYSID uses a lot of memory on my system (far too much compared to the database size). Do you know what this process is? What initialization parameters can modify this process memory usage ? Thanks a lot for answers!
Hi all! A database process, ora_dbw0_MYSID uses a lot of memory on my system (far too much compared to the database size). Do you know what this process is? What initialization parameters can modify this process memory usage ? Thanks a lot for answers!
Dec 2, 2003 #2 sbix IS-IT--Management Nov 19, 2003 493 CA It's a DBWR for MYSID instance. Pls define "lot of memory" in my system it uses 2 Mb. Upvote 0 Downvote
Dec 2, 2003 Thread starter #3 fmorel Programmer Apr 24, 2002 123 CH A lot is 205 Mb. Database size is around 5GB and SGA is select * from v$sga NAME VALUE Fixed Size 103396 Variable Size 87531520 Database Buffers 396623872 Redo Buffers 180224 ... but DBWR has nothing to deal with SGA... Is it a bug? Upvote 0 Downvote
A lot is 205 Mb. Database size is around 5GB and SGA is select * from v$sga NAME VALUE Fixed Size 103396 Variable Size 87531520 Database Buffers 396623872 Redo Buffers 180224 ... but DBWR has nothing to deal with SGA... Is it a bug?