Object browser. Too long loading objects with "My objects" filter

[mike_]

I have installed 8.0.1 version of PL/SQL Developer.
In case filter "My objects" selected in object browser, next sql executes:

select object_name, owner object_owner, status, object_type, created, last_ddl_time
from sys.all_objects o
where object_type = 'PACKAGE'
and object_name not like 'BIN$%'
and subobject_name is null
and (owner = user)
order by decode(owner, user, 0, 1),
owner,
object_name

(see the bold text)
This sql leads to problem in case database has many users (execution time aprox. 15 sec).
For example the same info from "user_objects" view take a ~2 sec

 

[Marco Kalter]

Strange. Does it help if you remove the order by clause?

 

[mike_]

I tried to do this. Execution time a bit less (~10-12 sec), but this is not enough.. Does PL/SQL Developer has some customization tool for such functionality? (for example - change this sql to more quickly with using user_objects view)

 

[Hilarion]

If you have access rights to DBA_* views, then try turning on the option "Use DBA Views if available", which should make PL/SQL Developer use SYS.DBA_OBJECTS instead of SYS.ALL_OBJECTS. Those views are usually much faster than ALL_* views.

 

[mike_]

Hilarion, thanks a lot! That is exactly what is needed, the problem is solved