hi folks,
when i resize a datafile (when reducing the size), the size of the file is not decresed at the OS level, right ?
why ?
regards
sonia
Printable View
hi folks,
when i resize a datafile (when reducing the size), the size of the file is not decresed at the OS level, right ?
why ?
regards
sonia
Hi,
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.
Orca
Someties resize has no result bcause some blocks 'live' at the end of the Datafiles even it is almost empty.
Orca
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?
Hi Sonia
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
regards
Hrishy
Oracle Block = N * OS Block
Datafile Extension is Based on Oracle Block size
SO it means Datafile Extension is Based on N * OS Block