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

Thread: Procedure hangs

  1. 07-19-2005, 12:02 PM #1
    balajiyes
    balajiyes is offline Advisor
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    Procedure hangs

    Hi All,

    My procedure hangs when I use a CONSTANT variable in my WHERE clause.

    When I hard code, it come out in a second.

    Please revert.
    Cheers!
    OraKid.
    Reply With Quote Reply With Quote
  2. 07-19-2005, 07:26 PM #2
    WilliamR
    WilliamR is offline Member
    Join Date
    Jun 2005
    Location
    London, UK
    Posts
    159
    Perhaps the optimizer is choosing a different execution plan.
    Reply With Quote Reply With Quote
  3. 07-20-2005, 04:05 AM #3
    balajiyes
    balajiyes is offline Advisor
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    Thanks williams. The same query plan are same. FOr time being I have hard coded. The same code is working in our production and not in our development (ver 9.2.6).
    Cheers!
    OraKid.
    Reply With Quote Reply With Quote
  4. 07-20-2005, 06:00 PM #4
    WilliamR
    WilliamR is offline Member
    Join Date
    Jun 2005
    Location
    London, UK
    Posts
    159
    What is it waiting on? Query v$session_wait for the session SID to find the event.

    Is the actual execution plan the same as the one you see when you copy & paste the SQL to SQL*Plus, PL/SQL Developer etc? You can check this with tkprof, or something along the lines of Tom Kyte's DYNAMIC_PLAN_TABLE.
    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