Hearing the Oracle

Home » 2015 » September

Monthly Archives: September 2015

Oracle XE on Windows : Runaway Trace Files

nearly full disk

nearly full disk

Here’s a real life situation: You’ve got a sandbox database on a laptop which is used for various other purposes unrelated to Oracle. For several months at a time, in between uses, you shut it down to keep your Windows environment uncluttered. One day, while looking into frequent blue death screens, forced Windows reboots, and involuntary chkdsks, you notice that only 9% remains free on your disk which seems off to you by nearly an order of magnitude. After scanning for huge files, you discover the Oracle trace directory to be the chief culprit, occupying about 100GB! From the date stamps you see that huge amounts of trace are being written all the time, even when you’re not using Oracle and think it’s down. What gives?     Continue…

Advertisements