Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: performance issues with public synonyms?

RE: performance issues with public synonyms?

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 14 Sep 2004 16:51:25 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF09660E4D@bosmail00.bos.il.pqe>


Ryan,

It's been a while since I've read the article, but, if I recall=20 correctly, the major points were:
1.) Increased library cache consumption w/ pub. syns., particularly with a large number of users.
2.) Additional latching and/or serialization due to lots of pub. syns.

Both the above points are not the type of thing you'd notice in a single user test or small-scale test. These are the types of things that come up on large systems, when it comes to scalability limits.

-Mark

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of ryan gaffuri Sent: Tuesday, September 14, 2004 4:45 PM To: Gogala, Mladen; oracle-l_at_freelists.org Subject: Re: performance issues with public synonyms?

i've read it. i've also tested it. i didn't notice any real difference = in
response time...
----- Original Message -----=20
From: "Gogala, Mladen" <Mladen.Gogala_at_aetn.com> To: <ryan_gaffuri_at_comcast.net>; <oracle-l_at_freelists.org> Sent: Tuesday, September 14, 2004 4:34 PM Subject: RE: performance issues with public synonyms?

> There is a website called Ixora (http://www.ixora.com.au) which
> has a search engine. Type "public synonym" and brace for impact.
> It tells you everything you need to know.
>
> --
> Mladen Gogala
> A & E TV Network
> Ext. 1216
>
>
> > -----Original Message-----
> > From: ryan_gaffuri_at_comcast.net [mailto:ryan_gaffuri_at_comcast.net]
> > Sent: Tuesday, September 14, 2004 4:07 PM
> > To: oracle-l_at_freelists.org
> > Subject: performance issues with public synonyms?
> >
> >
> > anyone ever notice any severe problems? I tested this to some
> > degree with parallel connections. I didn't notice much of a
> > difference with and without synonyms.
> > --
> > http://www.freelists.org/webpage/oracle-l
> >

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 14 2004 - 15:47:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US