Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to tune SQL to avoid ORA-03232 ?

Re: How to tune SQL to avoid ORA-03232 ?

From: <kenneth.koenraadt_at_no-spam.hotmail.com>
Date: Wed, 16 Oct 2002 07:24:22 GMT
Message-ID: <3dad12b3.601765@news.mobilixnet.dk>


Hi Jan,

Please post your execution plan. Hard to find your way through the jungle if you don't know where the jungle is....

2 things, though, are obvious, even without the execution plan :

a)

The predicate :

To_Number(Substr(To_Char(P.Special_Nr),2,4)).

Effectively hinders usage of indexes on the column, unless you have a FBI (Function-based index).

b) The extent size of 32k is very small, certainly too small for such a huge sort.

Received on Wed Oct 16 2002 - 02:24:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US