Recent content by Marc T

Any news on this? thanks

From the test we have done, here are some results: Filter: All objects Folder selected: Tables Objects returned: 1336 Response time (mm:ss): 10:15 Filter: All objects Folder selected: Views Objects returned: 2827 Response time (mm:ss): 11:45 Filter: All objects Folder selected: Packages...

Marco, this is the kind of response time we used to get against a 9i database. I have tried the same query against other tools (SQLPlus, SQl Developer) and I get the same response time. It is not the tool that is a problem, it is the fact that the query is built against the sys.all_objects...

The all_objects view is much more complex in 10g (120 more lines). You can execute the query and see for yourself. Even though the view is much slower in 10G (all_synonyms has the same problem), it is not the end user that is affected (they don't query database objects), it's the dba's...

As requested I removed the order by clause and it did not improve response time. It still takes aroud 10 minutes to get an answer.

We are currently running version 7.1.5.1396 on a 10.2.0.4 oracle database and we are experiencing the same problem. We did quite a bit of research on this. If you use filter "All object" it takes several minutes (between 8 and 15 minutes) to get an answer. If you use filter "My objects" is...