Re: Use of TEMP tablespace other than sorting

Rick Denoire <100.17706_at_germanynet.de> wrote in news:bdgq5vgo1m50r16l2a40ilp7u49hokcbam_at_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
>

The temp tablespaces is also used for temporary LOBS, temporary tables and hash joins that use more memory than hash_area_size. Is your query using any of these? Received on Thu Feb 27 2003 - 14:05:50 CST