Editing view/package/package body very slow

[Morff]

Hi
I'm using PLSQL ver13 in Oracle 12c and editing is very slow (auto completing in sql/command windows too).
I found that program periodically executes the query:

select text from sys.all_source where
owner = wner
and name = :name
and type = :type
and origin_con_id in (1,sys_context('userenv','con_id'))
order by line

is there a way to speed up the operation ?

 

[Marco Kalter]

This query should be fast. Can you contact a Database Administrator to check why this query is slow in your database?

 

[Morff]

I found that there is a bug in Oracle12c with all_source view.
But dba_source view is good.
Is there a place to change that query manually in program ?
I check that "use DBA views if available" not replaces all_source with dba_source.

 

[Marco Kalter]

The "Use DBA views" preference should fix this. It may be that a restart of PL/SQL Developer is required before this takes effect.

 

[Morff]

I thought so , but in 13.0.0.1883 (32 bit) is not. The query is still from all_source.

 

[Morff]

Sorry Marco
Of course it works ..
But I forgot to take a grant on dba_source to user

Thanks a lot