Re: The Need for speed

General Fear wrote:
> I recently was put on a project that required me to improve the speed
> of a pl/sql code.
>
> To give you an idea what I am working with, forget the 3rd normalized
> form. This is more like 4th or 5th normalized form. Retrieving data
> requires joining many tables with a lot of records.
>
> Do you all have tricks of the trade that has worked for you?
> Suggestions that I should try?
>
> Pointing me in the right direction will be greatly appreciated.
> Anything can help at this point.
>
> Regards

Along with reading above mentioned books which will give your code better performance in a bit further future than today and tomorrow, you should do the most obvious thing - identify main bottlenecks starting from upper user level i.e. this form works slowly, this report runs forever, then drill down to procedures, functions implementing these forms/procedures, then drill down to particular inefficient queries, slow dmls, possibly unnecessary pl/sql constructions etc. And here I've found the book Optimizing Oracle performance the BEST and 10046 level trace not replaceable.

Gints Plivna
http://www.gplivna.eu Received on Fri Oct 20 2006 - 12:24:39 CDT