Re: performance issues with public synonyms?
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 14 Sep 2004 17:53:39 -0600
How many objects with synonyms does your test environment have? And how
many concurrent users did you test? You need to get up to hundreds of
concurrent users to begin noticing an effect - as Mark already pointed out.
At 05:19 PM 9/14/2004, ryan gaffuri wrote:
>9.2.0.3, we will be 9.2.0.5 in the next month. Using CBO. I ran some tests
>and didn't notice any response time degradation...
>----- Original Message -----
>From: "Reardon, Bruce (CALBBAY)" <Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx>
>To: <oracle-l@xxxxxxxxxxxxx>
>Sent: Tuesday, September 14, 2004 7:16 PM
>Subject: RE: performance issues with public synonyms?
>
>
> > Ryan,
> >
> > In 8.1.7.4.1, with optimizer_mode =3D FIRST_ROWS, no stats on sys =
> > objects, Forms 4.5 and JVM installed
> > (ie lots of objects & lots of synonyms) we had significant performance =
> > problems due to synonyms because of the time taken querying the DD to =
> > resolve them.
>
>--
>//www.freelists.org/webpage/oracle-l
Regards
Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
