Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How DBWn Works

ZerandibJan 18 2011 — edited Jan 18 2011
Hi,

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,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2011
Added on Jan 18 2011
3 comments
2,170 views