"find database objects" - stops responding

[Dave Sharpe]

pl\sql Developer version 5.1.4
Oracle 9i
On both a WinXP PC and a Win2k one

I've been trying to use pl\sql developer's
"find database objects" and am experiencing
problems.

I'm just selecting tables and views to be searched.

It will search, find at least some, the progress
bar "fills up" and the application stops
responding ( locks up ).

 

[Marco Kalter]

Does this always occur, or was this an incident?

 

[Dave Sharpe]

Thanks for getting back to Me.

I haven't tried it before yesterday. But "always" has been my experience.

I just upgrade to 5.1.6 and that had no impact on My problem.

Dave

 

[Marco Kalter]

As a test, can you go to Tools > Preferences > Options tab page, select "Single Session" for the session mode, restart PL/SQL Developer, and try again?

 

[Dave Sharpe]

Marco

One observation. I have a high comfort level that the search "completes" and at completion the lockup occurs.

As single everything seems to run okay (3 tests ).
As dual locked up (1 test)

It does take an appreciable amount of time to analyze the tables and views (15 min+)

I wasn't sure but thought that You knowing something about the qty of objects in the database would be of benefit.

This query -------------------
select uo.object_type,count(1)
from user_objects uo
group by uo.object_type

returns these results---------
OBJECT_TYPE COUNT(1)
DATABASE LINK 1
FUNCTION 47
INDEX 347
LOB 11
MATERIALIZED VIEW 3
PACKAGE 42
PACKAGE BODY 43
PROCEDURE 26
SEQUENCE 155
SYNONYM 873
TABLE 197
TRIGGER 7
TYPE 1
TYPE BODY 1
VIEW 148

 

[Marco Kalter]

The number of object should not cause a hang-up. Apparently the problem is related to thread synchronization. In single session mode the search is performed in the main thread (you can't do anything else in PL/SQL Developer), whereas in multi session mode the search is performed in a background thread. We'll check it out and send you a test version is we find something.

 

[Dave Sharpe]

Marco - Thank You very much.

It is almost "the weekend" here, I hope that You have a great one when it gets to You.

Dave