Oracle Database Discussions

Hi all,

I'm having something strange here! The performance of queries that run against SYS objects like view DBA_OBJECTS , DBA_SEGMENTS, DBA_EXTENTS are VERY SLOWLY!! It's hang everytime and i need to kill the session and the PID process.

One example is the following:

SELECT owner, object_name, object_type FROM sys.all_objects
WHERE object_type IN ('PACKAGE', 'PROCEDURE', 'SEQUENCE', 'TABLE', 'TYPE',
'VIEW', 'FUNCTION') ORDER BY owner, object_name;

The objects of schema SYS was analyzed recently.
I have run the query with trace and nothing was found on that trace. The trace says the the query runs in few seconds but it didn't.

Any help?

Tks,
Paulo Portugal