PL/SQL developer hangs on just clicking the user objects

[algatz]

I imported the schema of DB 1 to DB 2 using oracle import/export facilities. After this if I try to expand any user object in DB 2 say Packages, Trigers, Tables, etc., the PL/SQL developer just hangs. But it works well for DB 1(It was working fine for DB 2 also before the import). What's the change I have to make so that the PL/SQL Developer works for both DB's. My oracle DB version is 10g and the client version is 9i and the PL/SQL developer version is 7.0.2.1076 (MBCS)and all are running in windows m/c. Thanks in advance

 

[Marco Kalter]

I assume this is a problem with the sys.all_objects view on DB 2. Can you compare the performance on DB 1 and DB 2?

 

[algatz]

I tried this query "select count(*) from sys.all_objects" and the query never ends.

 

[Marco Kalter]

You will need to contact your DBA to investigate this further.