Plsql Dev stopped responding (urgent)

Ashraf

Member
Dear support,
I have a problem, sometimes when i try to compile a package the plsql dev stop responding.while when i restart the database (oracle database) it complies successfully.
is there any way to fix that without restarting the db?
best regards,
ashraf
 
What version of PL/SQL developer?
What version of Oracle database?
What version of Oracle client?

What are your settings under Preferences->Program Window for the following (assuming PL/SQL Developer 7.0):
- Safe compilation
- Background compilation

Is it possible that when it "stops responding", it is really just busy recompiling a large number of dependencies? What is the longest time you have waited for PL/SQL Developer to respond?
 
It can also be that someone else is executing the package (or you are executing it in a different session). In this case, the Oracle Server will wait until the executed program finishes before compiling the package. The time-out for this is 10 minutes.
 
The version of PL/SQL developer is 7.0.2.1
The version of Oracle database is 10g release 10.2.1
& The version of Oracle client is Oracle Application Server 10g

& Safe compilation Not Checked
& Background compilation Not Checked
and please note that i am the only one whos running/compiling this package
& some times i wait more than 20 minutes so i can be able to re-compile it again
Thanks for ur help in advance
Best Regards
Ashraf
 
Do you have any DBMS_JOBs or cron jobs running that could be acting like another user compiling/executing packages?
 
Back
Top