Oracle Space Issue | AIX
Posted on 2013-12-20
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 .
Real Used at DB level
SQL> select sum(bytes)/1024/1024/1024 GB from dba_data_Files where FILE_NAME like '/dwdata%';