1 2 Previous Next 16 Replies Latest reply on Jul 7, 2009 8:34 PM by damorgan

    Tunning ALL_OBJECTS view

    417675
      Hi,

      How can I implement more performance in the ALL_OBJECTS view?

      I need execute a query like this: SELECT DISTINCT OWNER FROM SYS.ALL_OBJECTS;

      Important: I can't alter the query, because it's executed by an independent software.

      Any suggestions?

      Thanks in advance.
        1 2 Previous Next