Oracle中 df -h,关于drop tablespace including contents datafiles后df -h空间不变

本文探讨了在Oracle数据库中删除表空间及数据文件后,磁盘空间未被正确释放的现象。详细介绍了问题的原因,即SMON进程仍持有已删除的数据文件,导致文件无法立即释放给操作系统。并给出了两种解决方案:等待SMON进程关闭文件或关闭数据库。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

请教一下drop tablespace including contents datafiles后df -h空间不变的问题。

rhel3u2

oracle 10g 10.1

现象 drop tablespace including contents datafiles 后 dba_tbs的确消失了,v$datafile消失了。ls -l 看 physical file也消失了。

唯独df -h的空间不变。

metalink上有一篇关于这个问题的文章。

但是没有更仔细确切的说明。

觉得不太像。

http://metalink.oracle.com/metal ... amp;p_id=637526.999

在一个oracle的partner的support上,有这样的信息;

内容:

文号        19681          最終更新        00-11

( Version )         Oracle Server - Enterprise Edition( )

Component        RDBMS

Platform( Version )        Generic issue()

Reference

概要        after deleting datafile, the area occupied by the file is not released

[Problem]

after DROP TABLESPACE and delete datafile with OS command,

the area that occupied by the datafile seems not released to OS.

ls command doesn't list the file.

but after shutting down the database, the area seems released.

[Cause]

after DROP TABLESPACE droping tablespace, SMON still open the datafile.

because that SMON relase temporary segment and user's operation are are asyncronized, the files droped are still opened.

[Action]

wait several minutes for SMON closing the files. the period depend on the size of datafiles, the size and number of objects.

while shutdown could also release the files.

谁碰到过这样的问题?

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值