I will extract informations via trace and analyze its. I will let you know the result. thanks friends. Eriovaldo On Fri, Jan 2, 2009 at 1:29 PM, Cary Millsap <cary.millsap@xxxxxxxxxxxx>wrote: > The perception that your choices are limited, though, shouldn't change how > you diagnose your problem. If the only way to fix your problem ends up being > an appeal to a vendor to fix something, then you still need to find the > quickest way to *know* that this is what you need to do. > > Cary Millsap > http://method-r.com > http://carymillsap.blogspot.com > > > On Fri, Jan 2, 2009 at 8:55 AM, rjamya <rjamya@xxxxxxxxx> wrote: > >> however if the issue is with oracle supplied packages for spatial data, >> you will have limited choices. >> >> >> On Thu, Jan 1, 2009 at 3:03 AM, Stephane Faroult >> <sfaroult@xxxxxxxxxxxx>wrote: >> >>> Eriovaldo, >>> >>> If your process is written in PL/SQL, don't forget the DBMS_PROFILER >>> package. I suspect that your problem, like so often, comes from the >>> algorithm. >>> >>> SF >>> >>> >> >