Hi folks,
As per my understanding these 3 writers do the below tasks -->
1. BIW > Writes the data from BI Buffers (Memory) to BI file.
2. AIW > Writes the data from AI buffers to AI files.
3. APW > Scans through BI file and writes the modified blocks into disk.
As I am new to...
If our DB size is 200 GB and we are dump-loading a table of 1 GB then what should be the -B parameter during Ascii dump-load? Means what is the optimal value of -B in this scenario which will result a faster dump-load with less paging.
We are using 4 APWs, 1 BIW and 1 AIW.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.