Re: Use of TEMP tablespace other than sorting

Rick Denoire wrote:

> 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

I'd suggest a couple of things. The first is the you run explain plan to see what is happening. The second is that you post the query and give us some idea of how many rows are in the tables. At first blush it appears that something is wrong. But without more background I wouldn't want to speculate as to what.

BTW: CBO or RBO and are statistics with DBMS_STATS current?

Daniel Morgan Received on Wed Feb 26 2003 - 19:39:30 CST