Re: disk space issue

From: <bdbafh_at_gmail.com>
Date: 25 Jan 2005 21:52:24 -0800
Message-ID: <1106718744.328766.323330@f14g2000cwb.googlegroups.com>

Daniel,

3 words:

MERGE JOIN CARTESIAN no developers that miss join conditions?

you've never seen a tempfile (or datafile back before tempfiles) expand to fill either the available space, hit maxextents or hit the OS filesize limit?

tablespace quotas are very useful, but probably not used enough.

the sort segments are re-used, and de-allocated when you cycle the instance, as you have observed.

logs switch when they fill.
if this is just a development box, run it in noarchivelog mode and forget about it.

-bdbafh Received on Tue Jan 25 2005 - 23:52:24 CST