Re: Deep meaning of error 3232

"SL" <no.spam_at_thank.u> wrote in message news:<cc3u2a$cf2_at_news.rd.francetelecom.fr>...
> "SL" <no.spam_at_thank.u> a écrit dans le message news:
> cc3q2q$ae2_at_news.rd.francetelecom.fr...
> [snip]
> Before I get flamed, here is the exec plan of a query I managed to
> identify
> as part of the process described in my previous post
>
> select /*+ INDEX(t1 DETENTEUR_PK) */
> t1.*, t2.StatutTechnique
> from DETENTEUR t1, GLB_DETENTEUR t2
> where t1.REFTYPEELTAROUTER=t2.REFTYPEELTAROUTER
> and t1.IDELTAROUTER=t2.IDELTAROUTER
> and t1.CODEBASICATDETENTEUR=t2.CODEBASICAT
> and t1.REFINSTANCEDETENTEUR=t2.REFINSTANCE
>
> SELECT STATEMENT, GOAL = CHOOSE 864 1 189
> HASH JOIN 864 1 189
> TABLE ACCESS BY INDEX ROWID 849 3466 308474
> OF EFBADMIN.DETENTEUR
> INDEX FULL SCAN 23 3466
> OF EFBADMIN.DETENTEUR_PK
> TABLE ACCESS FULL 10 8168 816800
> OF EFBTRAVAIL.GLB_DETENTEUR
>
> DETENTEUR is a heavy work table, GLB_DETENTEUR is a
> temporary table (10-12 rows/tx max)
>
> That query is the only one that features join of any type ;)
>
> Sorry for my mistake.

Increase the next extent size of your temp tablespace such that it is larger than the hash area size being requested. if you are using a dictionary managed temp or create tablespace temp temporary the set pctincrease = 0, and initial = next = 1M. (This might be Windows NT bug 2898249)

HTH -- Mark D Powell -- Received on Fri Jul 02 2004 - 18:48:12 CDT