Today, I found the source of why my hard drive space has been mysteriously disappearing.
bash-3.2$ du -h | tail
1.5G ./oracle/product
1.5G ./oracle
1.9G ./oradata/ora
1.9G ./oradata
268K ./oraInventory/Contents
12K ./oraInventory/ContentsXML
788K ./oraInventory/logs
4.0K ./oraInventory/oui
1.1M ./oraInventory
75G .
That’s my local Oracle 10g installation on my MacBook. Upon further inspection:
bash-3.2$ pwd
/Users/oracle/admin/ora/bdump
bash-3.2$ du -h
71G .
The directory, /Users/oracle/admin/ora/bdump
, contains oracle trace files. The oracle manual describes trace files as:
A trace file is created each time an Oracle instance starts or an unexpected event occurs in a user process or background process.
Apparently, they’re mostly harmless. A quick oracle shutdown immediate
and a rm -rf ./bdump; mkdir bdump; chmod 750 bdump
did the trick.
I got 71G back. Whew.
Resources:
PS. I had oracle trace enabled, which is why my oracle instance was generating so many trace files.
To turn off trace without a oracle restart:
SQLPLUS> ALTER SYSTEM SET trace_enabled = FALSE;