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-l