Re: Problem with extend blocks of tablesspace temp after optimizing

From: mcstock <mcstock_at_enquery.com>
Date: Thu, 23 Oct 2003 17:42:16 -0400
Message-ID: <v4ednRqr89jJ1gWiRVn-hA@comcast.com>

likely the extent error is because the optimizer has decided to use a sort/merge join or some other operation that requires temporary space

the problem may be in the optimizer's chosen execution plan, but an immediate problem is that your temp tablespace is too small for the sort, or your SORT_AREA_SIZE is set too small for in-memory sorts

check into increasing the disk space allocated to your temp tablespaces

also use the SET AUTOTRACE ON feature of SQL*Plus to determine what execution plan is being selected by the optimizer

---

Mark C. Stock
www.enquery.com
(888) 512-2048

"Urbach1907" <urbach1907_at_aol.com> wrote in message news:20031023160407.22392.00000006_at_mb-m02.aol.com...
> On an oracle 8i database I have some problemes with an optimizer. A
running a
> little bit larger view give the right results without optimizing with
> dbms_utility.analyze_schema(). After optimizing the sql-erro ORA-03232 is
> coming. The extend can't allocate. I does't know at which point search. So
I
> hope somebody have an idea.
> Thanks for help.
>
> Frank Urbach
>
>
>
Received on Thu Oct 23 2003 - 16:42:16 CDT