Search results

But Tom, I am still confused..Can you please tell me in which areas they work? I mean BIW -> Between memory and BI. AIW --> Between memory and AI. APW --> Memory to disk but it looks into BI file first. That is not clear to me. Please put your thoghts and share some docs. What is the...

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.