compile invalid objects

[childish]

when I compile the object ,I find the sql run slowly.

SELECT text
FROM all_source
WHERE owner = bject_owner
AND TYPE = bject_type
AND NAME = bject_name
AND line = :line
AND origin_con_id = sys_context('userenv', 'con_id')

I hope we can tune it.

 

[childish]

SELECT COUNT(1) FROM all_source;-- 686603

 

[Marco Kalter]

It should be very fast, since it fetches exactly 1 uniquely identified source code line. Maybe you or a Database Administrator at your company can check why this query is slow?

 

[childish]

I will check，but i think the sql is good.
SELECT dbms_metadata.get_ddl(object_type =>'FUNCTION', NAME =>'' ) FROM dual;