Re: Disk space did not release
- From: David Roberts <big.dave.roberts@xxxxxxxxxxxxxx>
- To: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
- Date: Sun, 18 May 2014 20:41:23 +0100
Oracle temporary files are sparse when created.
A file that is listed as 20gb in size may take up less than 1gb on disk
initially and will use more as the temporary tablespace is written to.
Thus a file that is listed as 20gb could only actually occupy 13gb.
Dave
On Sun, May 18, 2014 at 2:53 PM, Eriovaldo Andrietta
<ecandrietta@xxxxxxxxx>wrote:
> Thanks for answers,
>
> Some time after removing manualy the data file, I see more free space in
> disk
>
> Filesystem Size Used Avail Use% Mounted on
> /dev/f1/fold1 493G 141G 352G 29% /l/disk67
>
> Only 13gb more instead of 20gb that was the file size removed.
>
> Regards
> Eriovaldo
>
>
>
> 2014-05-18 9:21 GMT-03:00 David Roberts <big.dave.roberts@xxxxxxxxxxxxxx>:
>
> This is a little speculative, but I'm sure I will be corrected if this
>> doesn't work!
>>
>> If the file is unreleased as it appears, then if you have permissions go
>> under /proc and look in each fd(?) directory for a file with the
>> appropriate size.
>>
>> the /proc/<process id>/fd directory that this file resides in will reveal
>> the process id of the process that is holding the file open.
>>
>> ps -ef | grep <process id> should reveal the process that is holding the
>> file open.
>>
>> Logically this should be an oracle process, where you can follow the
>> advice previously given, however if it isn't an oracle process than you
>> have something else to investigate!
>>
>> It can be useful before deleting a file to do an
>>
>> fuser <filename>
>>
>> to see what processes have a file open before you attempt to delete it.
>>
>> Dave
>>
>>
>> On Sun, May 18, 2014 at 11:59 AM, howard.latham@xxxxxxxxx <
>> howard.latham@xxxxxxxxx> wrote:
>>
>>> And you may need to restart database , a x nix quirk
>>>
>>>
>>>
>>> ----- Reply message -----
>>> From: "Marko Sutic" <marko.sutic@xxxxxxxxx>
>>> To: <ecandrietta@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <
>>> oracle-l@xxxxxxxxxxxxx>
>>> Subject: Disk space did not release
>>> Date: Sun, May 18, 2014 11:34 AM
>>>
>>> Hello Eriovaldo,
>>>
>>> you should run "DROP TABLESPACE TEMP2 INCLUDING CONTENTS AND DATAFILES;"
>>> to drop file and release space on disk.
>>>
>>> Now you have to delete file manually to release space on disk.
>>>
>>> Regards,
>>> Marko
>>>
>>>
>>> On Sun, May 18, 2014 at 12:18 PM, Eriovaldo Andrietta <
>>> ecandrietta@xxxxxxxxx> wrote:
>>>
>>>> Hi friends,
>>>>
>>>> I had a temporary tablespace TEMP02 in the instance.
>>>>
>>>> I ran:
>>>> $ df -h .
>>>> Filesystem Size Used Avail Use% Mounted on
>>>> /dev/f1/fold1 493G 154G 339G 32% /l/disk67
>>>>
>>>> After it I ran :
>>>> select * from dba_temp_files;
>>>> I got the file : /l/disk67/app/oracle/oradata/instance_name/temp02.dbf
>>>>
>>>> I ran:
>>>> drop tablespace TEMP2;
>>>>
>>>> So I immediately ran
>>>> $ df -h .
>>>> Filesystem Size Used Avail Use% Mounted on
>>>> /dev/f1/fold1 493G 154G 339G 32% /l/disk67
>>>>
>>>> and the spaces was not released. It keeps with 339G Avail
>>>>
>>>> The SO is Linux
>>>> The database is 11g
>>>>
>>>> What is wrong ?
>>>> Disk space should be released immediately?
>>>>
>>>> Regards
>>>> Eriovaldo
>>>>
>>>>
>>>>
>>>
>>
>
Other related posts:
