compilation hangs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. 02-02-2011, 03:16 AM #1
    iris
    iris is offline Member
    Join Date
    Mar 2008
    Posts
    140

    compilation hangs

    The below query hangs, what could be the reason

    SQL> Alter procedure "procedure_name" compile;


    thanks,
    Reply With Quote Reply With Quote
  2. 02-02-2011, 04:05 AM #2
    vnktummala's Avatar
    vnktummala
    vnktummala is offline Senior Advisor
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    864
    from where you are running this query? directly in the DB server or from any third party?

    trace the session and see what it is doing.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.
    Reply With Quote Reply With Quote
  3. 02-02-2011, 05:03 AM #3
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,330
    the procedure is probably locked - but a simple query against the database would have told you this
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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