Re: all_synonyms: performance issues

Other clues that this is most likely not recursive sql are: - recursive sql is usually all in lower case and especially
- recursive sql uses bind variables, not literals

Quoting Wolfgang Breitling <breitliw_at_centrexcc.com>:

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

-- 
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l