F4 on object type is slow

Böschenstein Patrik <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <578BEA6FF39BAC4CA5A4FADDCC2521F30169B2FCBF2C@ASTERIX.intra.infosystem.ch>
When I want to see a describe of an oracle object type, it takes 30 seconds.

I found that the following select is slow:

  SELECT M.Type_name,
         M.Method_Name,
         M.Method_No,
         M.Method_Type,
         r.Type_Name,
         r.Method_Name,
         r.Result_Type_Mod,
         r.Result_Type_Owner,
         r.Result_Type_Name
    FROM DBA_TYPE_METHODS M, DBA_METHOD_RESULTS r
   WHERE     (M.type_name = :ObjName)
         AND (M.Owner = :Owner)
         AND (r.Type_name(+) = M.type_name)
         AND (r.method_name(+) = M.method_name)
         AND (r.method_no(+) = M.method_no)
         AND (r.Owner(+) = :Owner)
ORDER BY M.method_name

What can I do to improve this?

Fyi: I tried Hint Rule: it would really improve this statment.
So I added both tables in the oracle hint table (in the Toad options->Oracle->Optimizer Hints), but the hint was not used by the query.

I use Toad 11.5 (it was already slow in older versions of toad) and Oracle 11.1.0.7

Thanks,
Patrik
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.