It takes up to 150 seconds to load schema list on some oracle instances (I'm using DBeaver v1.4.7 with Oracle 11G)
I've checked query manager, the following query eats all time:
SELECT U.USERNAME FROM SYS.ALL_USERS U WHERE (U.USERNAME IN (SELECT DISTINCT OWNER FROM SYS.ALL_OBJECTS))
The problem is in "SELECT DISTINCT OWNER FROM SYS.ALL_OBJECTS". On small instance it takes ~1 second, but on big one it takes 80-150 seconds (depending on instance size).
So, is there any possibility to skip SYS.ALL_OBJECTS check? As I can see, sql developer (and some other tools) shows full list of users. It would be great to have such possibility in DBeaver too.
thanks in advance