Forcing a check point
Getachew Geressu, October 09, 2005 - 12:27 pm UTC
Thanks again Tom,
During a checkpoint, doesn't DBWR flush the dirty blocks to the data file? If the file is "erased", where
does it write the blocks to?
In this case, what is the use of "alter system checkpoint"?
I will check the tool "lsof".
Thanks.
October 09, 2005 - 3:51 pm UTC
in unix, if you have a file open, and someone else erases it (really - they just "unlink it", they do not "erase it"), you STILL have the file open.
The side effect - when the LAST PERSON having the file open closes it - it "really" goes away - until everyone closes it - the file still exists in its entirety - only no new processes can open it (because the direct entry is gone). Unless and until the last process closes it - it is still there, still consumes disk.