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

Thread: PL/SQL Developer hangs

  1. #1
    Join Date
    Jan 2003
    Location
    Florida
    Posts
    5

    Unhappy PL/SQL Developer hangs

    I am trying to create a view in PL/SQL Developer. I have two identical Oracle databases. The only difference in the databases is that one of them has 10 views created for it and the other doesn't. I want to create those 10 views in the lagging database. The syntax of the view is correct. The problem is that when I run the script in PL/SQL Developer the program hangs. Its says "executing..." and does nothing else. What could cause this hang?

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    I see this with Forms Builder. If I am connected to a database doing some Forms work, and someone else is connected via SQL*Plus trying to compile something or run a script, the SQL*Plus session will hang (not all the time). I have to disconnect from the 9i database or use a separate one for Forms work.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Check dba_ddl_locks
    Jeff Hunter

  4. #4
    Join Date
    Feb 2003
    Location
    Kolkata, India
    Posts
    33
    Originally posted by stecal
    I see this with Forms Builder. If I am connected to a database doing some Forms work, and someone else is connected via SQL*Plus trying to compile something or run a script, the SQL*Plus session will hang (not all the time). I have to disconnect from the 9i database or use a separate one for Forms work.
    The issue of Form builder & SQL*Plus session getting hanged sounds intriguing. Does both sessions get hanged simultaneously? This form of locking is unheard of. What may be the probable cause?
    ("`-''-/").___..--''"`-._
    `6_ 6 ) `-. ( ).`-.__.`)
    (_Y_.)' ._ ) `._ `. ``-..-'
    _..`--'_..-_/ /--'_.' ,'
    (((' (((-((('' ((((

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    Forms session does not hang. Forms can be working on something entirely unrelated to the SQL*Plus session is trying to do.

  6. #6
    Join Date
    Feb 2003
    Location
    Kolkata, India
    Posts
    33
    Did u detect any contention in V$LOCKED_OBJECT during this issue?
    ("`-''-/").___..--''"`-._
    `6_ 6 ) `-. ( ).`-.__.`)
    (_Y_.)' ._ ) `._ `. ``-..-'
    _..`--'_..-_/ /--'_.' ,'
    (((' (((-((('' ((((

  7. #7
    Join Date
    Jan 2001
    Posts
    3,134
    "PL/SQL Developer hangs"

    They should all hang!!


    MH
    I remember when this place was cool.

  8. #8
    Join Date
    Jan 2003
    Location
    Florida
    Posts
    5

    locking

    It ended up being a locking issue. I shut the database down and brought it back up and all works well. Thanks for all of your replys;-)

  9. #9
    Join Date
    Aug 2001
    Posts
    267
    If we need to release the locks all we need is to kill the session that is causing the lock . If you are database is 24/7 OLTP . You can't do that for this simple reason.
    Raghu

  10. #10
    Join Date
    Feb 2003
    Location
    Kolkata, India
    Posts
    33
    Try to find out the cause of such abnormal locking behaviour. Killing the session or shuting down DB will erase all evidence
    ("`-''-/").___..--''"`-._
    `6_ 6 ) `-. ( ).`-.__.`)
    (_Y_.)' ._ ) `._ `. ``-..-'
    _..`--'_..-_/ /--'_.' ,'
    (((' (((-((('' ((((

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