-
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?
-
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.
-
-
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_.)' ._ ) `._ `. ``-..-'
_..`--'_..-_/ /--'_.' ,'
(((' (((-((('' ((((
-
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?
("`-''-/").___..--''"`-._
`6_ 6 ) `-. ( ).`-.__.`)
(_Y_.)' ._ ) `._ `. ``-..-'
_..`--'_..-_/ /--'_.' ,'
(((' (((-((('' ((((
-
"PL/SQL Developer hangs"
They should all hang!!
MH
I remember when this place was cool.
-
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;-)
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|