Recent content by Alan Jacobson

These type of issues are very hard to resolve. Does pl/sql developer return any error messages such as ORA-03113? What is the version of the Oracle database that you are trying to connect to? We just had one issue where they needed to "enable the path mtu discovery through all firewalls"...

Our issue was similar to the original posters issue. It turned out to be an issue with a firewall setting. Networking changed the ALG (Application Layer Gateway) on the firewall to uncheck the SQL packet inspection. This fixed the problem. to recap our issue: We never had a problem until we...

We are having a similar problem. We have a couple of simple queries that just hang in PL/SQL developer but run in SQLPlus. (They also fail using Oracle SQL Developer). We are starting to think that there is an issue with the Oracle 11.2.0.3 listener. They work when we use the Oracle 11.2.0.2...

We also had this problem. It went away when we dropped a trigger for: after servererror on database I don't know if this would help you but it did remove a tremendous amount of frustration for me...

We have both Oracle 10.2.0.3 and 10.2.0.4 installed. The query against 10.2.0.3 is fast but against 10.2.0.4 is extremely slow. Oracle did make extensive changes in the view between these two releases of the database. If pl/sql developer used a synonym instead of reverencing the view directly...

The Find Database Objects function does not always use bind variables. If you are not using dba view, there are four SQL statements where is does not use bind variables. They are: (these are some examples) SELECT table_name FROM sys.all_constraints WHERE constraint_name =...

We are having problems with the debugger hanging when it encounters an error. The lightning bolt does not bring back control. Pressing Shift + Escape several times does not bring back control. Holding down the Shift + Escape keys for several seconds sometimes brings back control. I have a...