Home » SQL & PL/SQL » SQL & PL/SQL » Standards for Stored Procedures (9.0.4.0)
Standards for Stored Procedures [message #344769] Mon, 01 September 2008 04:04 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

can any one please Send me the standards for stored procedures to check the following ::::

1.Performance
2.Efficiency
3.Code Maintenance
4.Functionality

Thank you.
Re: Standards for Stored Procedures [message #344773 is a reply to message #344769] Mon, 01 September 2008 04:11 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
OK.

1.Performance > Np procedures should run longer than 1 second.

2.Efficiency > No procedure should consume more than 10% of CPU or Disk I/O.

3.Code Maintenance > No procedure should be longer than 20 lines.

4.Functionality > All procedures should return correct results in at least 90% of cases.

Other than that, I don't know whether to laugh or to weep.

PS: If someone says "But those a re not the correct standards": Those are *MY* standards. *I* wrote them, and *I* will follow them when *I* write a procedure, from now on until some time this afternoon, when I will come up with new set of standards.

[Updated on: Mon, 01 September 2008 04:16]

Report message to a moderator

Re: Standards for Stored Procedures [message #344777 is a reply to message #344773] Mon, 01 September 2008 04:20 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi Thank you very much....
Re: Standards for Stored Procedures [message #344780 is a reply to message #344773] Mon, 01 September 2008 04:24 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
dear thomasG,

Now i understand that i am the poorest code writer in the world since one of my proceedure contains 870 lines compared to 20 lines you have mentioned. Ofcourse funcnality wise it delivered 100% correct result. However I use to write procedures behind apex application button. How can i know the time taken by my procedure and how much % resource it had taken. If you can suggest i will know how poor i am in performance and efficency too in terms of percentage
yours
dr.s.raghunathan
Re: Standards for Stored Procedures [message #344782 is a reply to message #344780] Mon, 01 September 2008 04:28 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Dear dr.s.raghunathan.

I wanted to point out that there CAN'T be any strict standards for procedures.

Just the same as there can't be any "Standard" passenger / miles per gallon / size standards for vehicles that fit everything from a sports car to a super tanker and airplane.
Re: Standards for Stored Procedures [message #344784 is a reply to message #344782] Mon, 01 September 2008 04:33 Go to previous message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
i agree.

i didn't read your P.S. in the earlier message.

yours
dr.s.raghunathan
Previous Topic: Can we pass OUT parameter in a function ?
Next Topic: Data retrieving
Goto Forum:
  


Current Time: Sat Dec 03 03:56:15 CST 2016

Total time taken to generate the page: 0.12164 seconds