Home » SQL & PL/SQL » SQL & PL/SQL » improve the performance of procedure (oracle 9i)
improve the performance of procedure [message #318860] Thu, 08 May 2008 04:55 Go to next message
saurav.raj
Messages: 8
Registered: May 2008
Location: BANGALORE
Junior Member

hi all

i want to improve the performance of the following procedure ...Can any one help me or advice me which operator i can use......
  • Attachment: proc.txt
    (Size: 7.78KB, Downloaded 256 times)
Re: improve the performance of procedure [message #318867 is a reply to message #318860] Thu, 08 May 2008 05:19 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Well to start with read the following link.
http://www.orafaq.com/forum/t/84315/94420/

Regards

Raj
Re: improve the performance of procedure [message #319494 is a reply to message #318867] Sun, 11 May 2008 22:10 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Cursors within cursors = performance death

Read this

Ross Leishman
Previous Topic: Trigger on Materialized View
Next Topic: error from compiling
Goto Forum:
  


Current Time: Wed Dec 07 10:24:15 CST 2016

Total time taken to generate the page: 0.16311 seconds