DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: PL/SQL performance tuning

  1. #1
    Join Date
    Dec 2002
    Posts
    40

    PL/SQL performance tuning

    Hi

    Can anyone let me know how to do PL/SQL perfromance tuning.I am new to this concept.Pls let me know.

    Thanks in advance

  2. #2
    Join Date
    Jul 2003
    Posts
    59
    The best way is to go through the *design* process with performance being a major consideration. Yea, that's the easy answer, but it's true. A good book on how to write PL/SQL the right way will always take performance into consideration. Here's a suggestion... there are others... browse em at the bookstore.

    http://www.amazon.com/exec/obidos/AS...071487-0060838

    The deal is, the SQL that appears in PL/SQL should be tuned on a statement per statement basis, as any SQL statement should be. But, PL/SQL being *procedural* introduces another aspect, and that is what the books will go into. When to use a cursor, when [not] to commit, how to combine embedded loops into a single statement, bind variables (a BIG performance issue), dynamic SQL (different ways of doing it), among others things.
    Tom Best

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width