when i resize a datafile (when reducing the size), the size of the file is not decresed at the OS level, right ?
if resizing is possible on your OS then the size of the datafile
is decreased on os-level.
Because the size of the datafiles in the dictionary is the PHYSICAL size of the os-implemetation of the datafiles.
Someties resize has no result bcause some blocks 'live' at the end of the Datafiles even it is almost empty.
But of course it is resized! What makes you think the opposite? What would be the purpose of resizing (schrinking) the datafiles if physical datafile size would not decrease?
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Nope it is not true resizing at oracle level means..oracle server would make function call via the c program asking the OS to resize the datafile..every os does it...But before resizing oracle server would check the high water mark of the file..becasue you cannot shrink a datafile beyond its high water mark..
If you oracle version is 7 and above you can shrink the datafile on all platforms..if it is not shrinking that means..you are
a)either trying to shrink it belwo the high water mark
b)You should till the os actually shrinks..there maybe a slight delay till you actually see the results..
c)This also works on raw file systems
It Does , Ofcourse
Oracle Block = N * OS Block
Datafile Extension is Based on Oracle Block size
SO it means Datafile Extension is Based on N * OS Block
Click Here to Expand Forum to Full Width