Re: high sql performance

Fabio R. Zoltek wrote in message <719sff$8ek_at_portal.gmu.edu>...
>
>I am trying to find resources on the Internet that deal with tuning or
>optimizing pl/sql
>or sql code for oracle. It does not matter if it is a faq, ftp site, web
>adddress, etc.

Tuning for what? Tuning for OLTP? For batch processing? For OLAP? What platform? What table and database size? What Oracle version? What client front-ends are used? What is the network topology? What is the colour of you underwear? Do you also drive around with a lead pipe in the back of your car?

There's no standard set of rules that can be applied to optimise an Oracle database or application IMHO. A bitmap index may do wonders for certain requirement, and kill the performance when tried somewhere else.

Optimisation is a bit of an art form. It requires that you know the operating system, know about the internals of Oracle, and know the application and database design intimately.

Also, optimisation spans the whole of client-server architecture. Only optimising a "piece" somewhere does not guarantee an increase in performance anywhere else.

There's nothing that substitutes for DIY experience. Which means rolling your sleeves up and opening the hood of the car and working on engine, instead of trying to find car magazines that describes bits and pieces of the engine.

My crazed thoughts anyway... :-)

regards,
Billy Received on Fri Oct 30 1998 - 01:26:15 CST