Oracle XE on Windows : Runaway Trace Files

Hearing the Oracle

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?

Windows Services and Oracle Processes

I use an XE version of Oracle 11.2 on a Windows laptop as a sandbox…

View original post 1,351 more words

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s