Use of TEMP tablespace other than sorting

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Wed, 26 Feb 2003 23:53:20 +0100
Message-ID: <bdgq5vgo1m50r16l2a40ilp7u49hokcbam@4ax.com>

Using an SQL query with a join over six tables, the query breaks with the message "ORA-1652: unable to extend temp segment by 512 in tablespace TEMP". This query does not do any sort operation, at least not explicitly.

After having expanded TEMP four times consecutively up to 48 GB, I am still getting the same error. So I wonder what TEMP is used for beside sort operations. The tablespace is locally managed, uses uniform extents of 4 MB each. The sort area size is set to this size as well.

Is there a way to monitor the use of space in TEMP by a particular session?

Oracle 8.1.7 / Solaris 2.7

Any hint would be appreciated.

Rick Denoire Received on Wed Feb 26 2003 - 16:53:20 CST