Printable View
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?
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.
Check dba_ddl_locks
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?Quote:
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.
Forms session does not hang. Forms can be working on something entirely unrelated to the SQL*Plus session is trying to do.
Did u detect any contention in V$LOCKED_OBJECT during this issue?
"PL/SQL Developer hangs"
They should all hang!!
:D
MH
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;-)
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.
Try to find out the cause of such abnormal locking behaviour. Killing the session or shuting down DB will erase all evidence :)