How DBWn Works
ZerandibJan 18 2011 — edited Jan 18 2011Hi,
I want to know how DBWn works
SAy; There is a tablespace DATASR3.
This tablespace consists of 10 Datafiles.
6 Datafiles are already filled. (Reached to its MAXLIMIT.)
and Other 4 datafiles is in the preocess of getting the data.
Im interesting in why its happens like this?... How DBWn will going to add/write data to datafiles.
Is it in a circular fashion OR randomly it (DBwn) decides to which datafiles it goes to write.
If its circular fashion then all datafiles must filled...according to order. (then it is not possible to full-fill only 6 Datafiles?)
DBWn and LGWR works in the same way? .... Writing to files one after the other!
Regards,