drop tablespace XXX including contents and datafiles删除表空间后,磁盘空间不释放

使用drop tablespace 删除表空间后,在系统中df -h查看不释放空间,

SQL >  DROP TABLESPACE TS_XXX_D INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

[root@hydb ~]#  lsof |grep YSJ
oracle_13   1333                oracle  258u      REG             251,17 34355552256 1073741966 /oradata/ORCL/datafile/TS_XXX_D01.dbf (deleted)
oracle_13   1333                oracle  261u      REG             251,17 10485768192 1073741999 /oradata/ORCL/datafile/TS_XXX_D020230926.dbf (deleted)
oracle_13   1333                oracle  263u      REG             251,17 10679754752 1073742013 /oradata/ORCL/datafile/TS_XXX_D20240412.dbf (deleted)
oracle_13   1333                oracle  264u      REG             251,17 10485768192 1073741994 /oradata/ORCL/datafile/TS_XXX_D020230914.dbf (deleted)
oracle_13   1333                oracle  266u      REG             251,17 21417172992 1073742010 /oradata/ORCL/datafile/TS_XXX_D202403221.dbf (deleted)
oracle_13   1333                oracle  267u      REG             251,17 10485768192 1073742001 /oradata/ORCL/datafile/TS_XXX_D020230929.dbf (deleted)
oracle_13   1333                oracle  268u      REG             251,17 10485768192 1073741993 /oradata/ORCL/datafile/TS_XXX_D02.dbf (deleted)
oracle_13   1333                oracle  270u      REG             251,17 10485768192 1073741998 /oradata/ORCL/datafile/TS_XXX_D020230920.dbf (deleted)
oracle_13   1333                oracle  271u      REG             251,17 27540856832 1107461511 /oradata/ORCL/datafile/TS_XXX_D20250123.dbf (deleted)
oracle_13   1333                oracle  272u      REG             251,17 33563877376 1107461512 /oradata/ORCL/datafile/TS_XXX_D2025012301.dbf (deleted)

看了很多blog说明直接kill相关进程,因生产环境,暂不操作

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值