Home » RDBMS Server » Performance Tuning » how to make sql&pl/sql mor efficient
how to make sql&pl/sql mor efficient [message #65818] Tue, 04 January 2005 13:02 Go to next message
ynody
Messages: 3
Registered: January 2005
Junior Member
hello
any one know what is the rolls to make sql&pl/sql code more efficient and executeing faster

B.R.
Re: how to make sql&pl/sql mor efficient [message #65825 is a reply to message #65818] Wed, 05 January 2005 00:05 Go to previous messageGo to next message
Frank Naude
Messages: 4565
Registered: April 1998
Senior Member
Hi,

Read the "Tuning PL/SQL Applications" chapter in the PL/SQL User's Guide and Reference Guide.

Also, consider upgrading to 10g. Oracle 10g introduces an optimizing PL/SQL code generator. Apparently PL/SQL programs run about 2x faster in 10g as they did in 9i, and about 3x as fast as they did in 8i.

Best regards.

Frank
Re: how to make sql&pl/sql mor efficient [message #65827 is a reply to message #65825] Wed, 05 January 2005 08:09 Go to previous messageGo to next message
ynody
Messages: 3
Registered: January 2005
Junior Member
thank you Frank
but i serch about any complet book about this

B.R.
Re: how to make sql&pl/sql mor efficient [message #65829 is a reply to message #65827] Wed, 05 January 2005 21:07 Go to previous messageGo to next message
Frank Naude
Messages: 4565
Registered: April 1998
Senior Member
So why didn't you say so in the first place?

The only PL/SQL Tuning book I know about is:

Oracle Pl/SQL Tuning: High Performance With Code Tricks & Bulk Array Processing
Author: Mike Ault
ISBN: 097275136X

Best regards.

Frank
Re: how to make sql&pl/sql mor efficient [message #65830 is a reply to message #65829] Thu, 06 January 2005 02:52 Go to previous message
ynody
Messages: 3
Registered: January 2005
Junior Member
thanks alot frank
B.R.
Previous Topic: Session related Quries
Next Topic: Explain the explain plan
Goto Forum:
  


Current Time: Tue Sep 29 11:35:24 CDT 2020