drop-down menu with list of columns hang in PL/SQL Developer 9.0.6

[tdevlikamov]

Hello!

I have the problem with PL/SQL Developer 9.0.6 in Oracle 11.2.0.4. When using table alias in predicate filter (WHERE) drop-down menu generate list of column of alised table.
When table is big with a lot of partitions, the menu hang for 10 or more minute. Problem with the query generated by PL/SQL Developer to get list of column:

SELECT t.*, o.*, m.comments
FROM sys.all_tables t, sys.all_tab_comments m, sys.all_objects o
WHERE t.owner = bject_owner
AND t.table_name = bject_name
AND m.owner(+) = bject_owner
AND m.table_name(+) = bject_name
AND o.owner(+) = bject_owner
AND o.object_name(+) = bject_name
ANDbject_type IS NOT NULL
AND:sub_object IS NULL;

How can we adjust or rewrite the problem query?
Is there any fix to resolve the issue?

Thanks.

 

[IvanZ]

This query was optimized in version 11.

 

[tdevlikamov]

Hello!

Thanks for replay. I had tested trial v.11, yes the problem in that version is solved. But unfortunately, i don't have a license for v.11. And as i understand license for v.9.0.6 is not suitable for v.11.