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

Thread: PL/SQL configuration

  1. 03-12-2003, 12:54 PM #1
    Blu
    Blu is offline Junior Member
    Join Date
    Apr 2002
    Posts
    73

    PL/SQL configuration

    Can we configure the Oracle environment or parameters to make PL/SQL to run more efficient?

    One of our PL/SQL hang, we copied the sql out from pl/sql and running it in sqlplus, the response time was fine.
    Reply With Quote Reply With Quote
  2. 03-12-2003, 01:08 PM #2
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    This shouldn't happen. Please give us: OS, Oracle Version and the code that "hung".
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
  3. 03-12-2003, 01:18 PM #3
    Orca777's Avatar
    Orca777
    Orca777 is offline Senior Member
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    first : in SQL*PLUS you used fixed values but in PL/SQL not, you used bindparameter (PL/SQL-Variables) and so the Execution-plan diffs.
    Trace your session and you will see why the pl/sql (THE SQL!!) runs so slow.

    second : if you have Oracle 9iR2 then you can improve PL/SQL-Performance BUT NOT your SQL-Performance.

    Orca
    Reply With Quote Reply With Quote
  4. 03-12-2003, 01:58 PM #4
    Sameer's Avatar
    Sameer
    Sameer is offline Advisor
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

    Re: PL/SQL configuration

    Originally posted by Blu
    One of our PL/SQL hang, we copied the sql out from pl/sql and running it in sqlplus, the response time was fine.
    Other than that SQL what do you have in your code.. Check if you have never ending loops..
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width