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