Re: The Need for speed

Thanks all.

I was not ask for specific help. Just a general suggestions. Books to read, web pages to look at etc . . .

DA Morgan wrote:
> 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
>
> Read, comprehend, and apply everything in Tom Kyte's and Jonathan
> Lewis's books.
> Set SPEED=REALLYFAST in your init.ora
>
> Generic questions beget generic advice.
> No version.
> No indication of transaction volume, size, type, etc.
> No PL/SQL
> No explain plan generated with DBMS_XPLAN
> No profile generated with DBMS_PROFILER
>
> We don't know whether your PL/SQL is calculating the trajectory of the
> Mars orbiter, loading music DVDs as BLOBS, or part of an ERP application.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Sat Oct 21 2006 - 22:32:35 CDT