Re: Multiple databases - best performance scenario
Date: Sat, 12 Apr 2008 06:14:37 -0700 (PDT)
On 12 Apr., 13:04, "news.verizon.net" <kenned..._at_verizon.net> wrote:
> "Paul" <paul.f..._at_globaladdress.net> wrote in message
> > 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
applying the patch solved the problem.
-ap Received on Sat Apr 12 2008 - 08:14:37 CDT