Query Builder

[nodrog]

We have recently moved to oracle 10g db and due to the upgrade we seem to have a problem with query builder. When the view is changed from my objects to 'all objects' the query builder hangs for so long that it is necessary to close the application.

Any clues would be welcome.

 

[Marco Kalter]

This is probably due to a performance problem with the sys.all_objects view. Can you run the following query and let me know how it performs?

select * from all_objects where object_type = 'TABLE'

 

[Randy Meisner]

We too are experiencing the same problem but in the normal editing window - not query builder. Running the above query from sql*plus brings similar results from selecting all_objects in the object browser - basically hangs for an extended period of time.

 

[nodrog]

Hi
Ran the query as suggested and returned 1172 rows in 8.2 sec