What You Can Do When Your Database Runs out of Temp Space

(Roger Schrag) When a sort operation is too large to fit in memory, Oracle allocates space in a temporary tablespace in order to write data off to disk. Temporary space is a resource shared by multiple sessions on the database, and quotas cannot be set to limit how much temporary space can be used b

Read More - Register for Free Membership