Home » SQL & PL/SQL » SQL & PL/SQL » methods to improve the performance of pl/sql stored procedures
methods to improve the performance of pl/sql stored procedures [message #38697] Mon, 06 May 2002 23:06 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
What are the methods to improve the performance of pl/sql stored procedures?

Report message to a moderator

Re: methods to improve the performance of pl/sql stored procedures [message #38737 is a reply to message #38697] Thu, 09 May 2002 11:22 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Apart from tuning the pl/sql logic and the sql code you can pin the code in the SGA to prevent it from being aged out. Pinning code is almost certainly not YOUR solution.

Start sql_trace at the start of your code execution, and then run the trace file through tkprof. Make sure that timed_statistics are enabled to get meaningful output.

Report message to a moderator

Previous Topic: Using PL/SQL to generate an xls file at specified time intervals
Next Topic: Database Independency
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 07 01:27:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.