forcing data to be writen from buffer to datafile
781089Sep 5 2010 — edited Sep 5 2010HI,
Could someone help me with the following, (using oracle 11g r2)
If I conduct an experiment that updates a row in a table lets say the row has a column called 'test' and I update the value of test from 'a' to 'b'
I then run another update and change 'b' back to 'a'
I then repeat the process 2000 times
Am I right in thinkin that this update will be carried by ammending the data in the buffer cache only? it will have nothing to do with the write speeds of the disk?
how can I force the updata to be writen to disk each time?
any help would be appriciated