All entries for Thursday 05 January 2012
January 05, 2012
Solaris df reported disk usage differently to du
I dropped the hitlogging tablespace whose size was 200+ gb.
But:
bash-3.00# df -h
la-ora01-db 588G 31K 44G 1% /oradb
la-ora01-db/data 588G 489G 44G 92% /oradb/data
bash-3.00# du -s -h /oradb/data
217G /oradb/data
-bash-3.00# for pid in `ps -ef | grep ora_ | awk '{print $2}'`; do
pfiles $pid | grep log ; done | sort | uniq
...
/oradb/data/stats2/hitlog2010.dbf
/oradb/data/stats2/hitlog2011.dbf
/oradb/data/stats2/hitlog2012.dbf
/oradb/data/stats2/hitlogempty.dbf
/oradb/data/stats2/hitlogmview01.dbf
...
The files I drooped were hitlogging*.dbf and non of them appear in the list above.After 3-4 hours waiting to remove the possibility of cache effect, I restarted the database
SQL>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
-bash-3.00# df -h
Filesystem size used avail capacity Mounted on
/ 39G 8.8G 30G 23% /
/dev 39G 8.8G 30G 23% /dev
la-ora01-db 588G 31K 316G 1% /oradb
la-ora01-db/data 588G 217G 316G 41% /oradb/data
Maybe some other user process hold the files? I only inspected the oracle background process and usually the most likely suspect is db file writer (dbwn).