Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to tune SQL to avoid ORA-03232 ?
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.