Re: Multiple databases - best performance scenario

On Apr 14, 3:50 pm, NetComrade <netcomradeNS..._at_bookexchange.net> wrote:
> On Sat, 12 Apr 2008 17:33:01 +0200, sybra..._at_hccnet.nl wrote:
>
> >> Multiple schemas have other issues as well as general performance.
> >>There appears to be some sort of 'bug' in Oracle that causes it to
> >>become confused. We have, on occasions, seen it using the wrong
> >>compiled code to access a table that has the same name across two
> >>schemas. We can resolve this by prefixing all table names with the
> >>user name. The second problem is more pervasive and we don't have a
> >>fix. When two schemas are active and updating tables Oracle may throw
> >>a wobbly stating that it can no longer maintain database state for one
> >>instance and the SQL terminates. It's clearly a bug as either schema
> >>will work correctly when running solo.
>
> >That's the most ridiculous nonsense there has been posted here in a
> >while.
> >I have never had any problems.
> >Especially the second problem you describe is utter crap.
> >Are you sure you are running Oracle or some toy product like MySQL?
> >It looks like the time for a developer beating is nigh.
>
> As another poster noted, this was indeed a disgusting bug, which was
> fixed. As far as the 2nd part of the complaint, I never heard of such
> issues either. OP should post more details.
>
> -a
> .......
> We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc)
> We use RMAN and remote catalog for backups

Wow what a vicious bug. This bug does not appear when using fully qualified objects, which should be the goal anyway :-).

How is the weather up there Sybrand? Received on Tue Apr 15 2008 - 08:48:03 CDT