Oracle Space Issue | AIX

Posted on 2013-12-20
Last Modified: 2014-01-25
Experts -

I do see space mismatch as below. What happens when the mount /dwdata reaches 100%. But I still have enough space at the DB level.  This is a PROD I just cannot bounce the DB.

We dropped a tablepace worth of 1TB, which is not reflecting at the OS level commands.

$ df -g /dwdmdata
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/fslv03     6000.00    236.65   97%      609     1% /dwdata

$ cd /dwdata
$ du -gs .
5762.17 .

Real Used at DB level

SQL> select sum(bytes)/1024/1024/1024 GB from dba_data_Files where FILE_NAME like '/dwdata%';


Question by:sventhan
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 15

Expert Comment

by:Devinder Singh Virdi
ID: 39732620
Are Temp files in same location?
LVL 18

Author Comment

ID: 39732692
No. They're in a different location.
LVL 29

Assisted Solution

MikeOM_DBA earned 334 total points
ID: 39732713
We dropped a tablepace worth of 1TB, which is . . .
Did you do it "INCLUDING CONTENTS AND DATAFILES"? if not, remember to also remove the files.
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

LVL 18

Author Comment

ID: 39732732
When I dropped the tablespace was empty no objects were associated with it. But I did not use the "including" clause.

Will that be an issue?

If we bounce the DB, will df/du reflect the correct numbers?
LVL 29

Assisted Solution

MikeOM_DBA earned 334 total points
ID: 39732739
You may need to use OS command to remove the files related to the dropped tablespace.
And if "df" command does not reflect the change, then just close and open the database.
LVL 18

Author Comment

ID: 39732754
when drop the tablespace with "drop tablespace tablespacename" command, the associated datafiles will not be dropped automatically. Is this true?

Thanks for the help.
LVL 29

Expert Comment

ID: 39732762
True, datafiles only removed with the "DROP TABLESPACE ... INCLUDE...DATAFILES" otherwise you need to remove the files using the "rm {file name}" OS command.
LVL 35

Assisted Solution

johnsone earned 166 total points
ID: 39732779
Once you remove the files at the OS level, then if the space is still not showing up in df, then run this:

sync ; sync ; sync

That may need to be run as root, but you can try as oracle.  That syncs the file system headers and the space should show up at that point.  You should not need to bounce the database.
LVL 18

Accepted Solution

sventhan earned 0 total points
ID: 39732814
Thanks Virdi, Mike and John. I'll try this tonight
LVL 18

Author Closing Comment

ID: 39808400

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Krita v3 Linux Mint/Ubuntu 16.04 9 74
Edit smb.conf-file in Samba om a ReadyNAS 3 72
unix shell script 4 39
Issue when using 'yum update' 4 23
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension ( This reminded me of questions tha…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Suggested Courses

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question