Re: Multiple databases - best performance scenario

On 12 Apr., 13:04, "news.verizon.net" <kenned..._at_verizon.net> wrote:
> "Paul" <paul.f..._at_globaladdress.net> wrote in message
>
> news:36ea1691-4890-4f2e-9f5b-9a67dede9f13_at_m71g2000hse.googlegroups.com...
>
> > 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.
>
> Never seen this happen in any version of Oracle I worked with (6,7,8,9,10).
> We currently use multiple schemas and I have done so in the past and never
> had this problem. (Oracle updating the wrong table or using hte wrong
> package) I suspect this is an application problem. (and I don't put the
> schema name on my sql either.) Never see the other problem either. I
> think you have some application problem.
>

we had this problem too. it's an oracle bug, #5458753 if i remember right.
applying the patch solved the problem.

regards,
-ap Received on Sat Apr 12 2008 - 08:14:37 CDT