Shulou(Shulou.com)06/03 Report--

Remember once, delete database physical files, disk space is not released.

Background Description:

Database business offline, delete business account, delete corresponding table space, free disk space

Operation Description:

1. drop user xxx cascade;

2. drop tablespace xxx including datafiles and contents

After deletion, the physical file is indeed deleted, but the df -h command does not free up space

lsof |grep deleted

View many processes occupying deleted oracle data files;

Get the corresponding spid, query in the database v$process and v$session,

The corresponding status is found to be "inactive". After killing the corresponding os process, disk space is released.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.