RE: Resize datafile not releasing space at OS level
- From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
- To: "GovindanK" <gkatteri@xxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 9 Mar 2007 17:27:32 -0500
Thanks for the reply.
We are not using the recyle option and parameter recyclebin is off. No
error during file shrink. It was created a Bigfile/LMT
select file_name,bytes from dba_data_files where tablespace_name='HS';
/data233/oradata/hs1.dbf 32212254720
-bash-3.00$ ls -lrt hs1*
-rw-r----- 1 oracle oinstall 109521674240 Mar 9 15:49 hs1.dbf
Thanks
--Harvinder
________________________________
From: GovindanK [mailto:gkatteri@xxxxxxxxxxx]
Sent: Friday, March 09, 2007 5:10 PM
To: Harvinder Singh; oracle-l
Subject: Re: Resize datafile not releasing space at OS level
May be you would need to Purge the Recycle bin. Are you using
Bigfile/DMT/LMT?
Refer to Metalink Notes Note:380473.1, Note:1061937.6
Are you receiving any error while shrinking?
HTH
GovindanK
On Fri, 9 Mar 2007 14:47:08 -0500, oracle-l-bounce@xxxxxxxxxxxxx said:
> Hi,
>
> We have an Oracle 10.2.0.1 database on RHAT4 test server and I resize
> the file from 100G to 30G and operation is successful and I can see in
> the dba_data_file it is showing now as 30G but on hard
drive/filesystem
> it is still showing 100G. So I assumed OS may release space when other
> process needs it but it didn't happened and other process failed for
> space reasons and also I rebooted the server but still no effect.
> What can be the possible reasoning for this behavior and how to reduce
> the size at file system level.
>
> Thanks
> --Harvinder
>
> --
> www.freelists.org/webpage/oracle-l
>
>
Other related posts:
