Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: all_synonyms: performance issues
I doubt that this sql is from a recursive sql. Recursive sql would go straight
after the syn$ table, not the all_synonyms view. I am sure (as much as I can be
from the distance) that the sql is issued from some application.
Are you using a lot of public synonyms? Couldn't you use current_schema instead?
Quoting Charles Schultz <sacrophyte_at_gmail.com>:
> Good day, list,
>
> SELECT table_name, table_owner FROM all_synonyms WHERE owner = :"SYS_B_0"
> AND synonym_name = :"SYS_B_1"
>
> We are also unable to find explicit calls from the
> application, so we are operating under the assumption that Oracle does this
> as part of a recursive call. A 10046 trace will show this query and a
> preceding query (ie, select * from some_table), but I do not quite
> understand how they are related.
>
-- regards Wolfgang Breitling Oracle 7,8,8i,9i OCP DBA Centrex Consulting Corporation www.centrexcc.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 23 2006 - 11:43:42 CDT
![]() |
![]() |