Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ora_dbw0 memory usage

Status
Not open for further replies.

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!
 
It's a DBWR for MYSID instance.
Pls define "lot of memory" in my system it uses 2 Mb.
 
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top