asked on

Oracle Space Issue | AIX

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%';

GB
----------
4612.54259

thanks,
sve.

Devinder Singh Virdi

Are Temp files in same location?

sventhan

ASKER

No. They're in a different location.

SOLUTION

MikeOM_DBA

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sventhan

ASKER

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?

SOLUTION

MikeOM_DBA

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sventhan

ASKER

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

Thanks for the help.

MikeOM_DBA

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

SOLUTION

johnsone

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

sventhan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sventhan

ASKER

Thanks