Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: here's a good one from dizwell on the recent product launch

Re: here's a good one from dizwell on the recent product launch

From: NetComrade <>
Date: Thu, 26 Jul 2007 14:02:05 -0400
Message-ID: <>

On Thu, 26 Jul 2007 03:33:04 -0700, Noons <> wrote:

>On Jul 26, 2:04 pm, NetComrade <>
>> >Then after a while, inject a few of those updates,
>> >but this time on the table that is commonly named.
>> >Increase load on these and watch which table
>> >gets updated.
>> >Happens since 9i, various Metalink SRs.
>> >Workaround? Turn off the pga_aggregate and the
>> >SGA auto memory management and go back to setting
>> >all the umpteen memory caches manually.
>> >No fix "until 11g".
>> We hit this, we have many db's with almost identical schemas.. Is this
>> still not fixed? After we applied, I heard maybe one
>> complain. Lucky it was not a payroll database :)
>You're not the only one. Anyone running the same
>table name in two schemas in same instance is exposed
>to this problem, since 9ir1. There are umpteen calls on
>this in Metalink since then, all answered and closed the
>same way: upgrade to or 11 or turn off all the
>sga auto management switches. Oracle has done bleeding
>nothing to fix this until and even then it's not

Actually, turning off sga management switches was not one of the suggestions for us, but we don't use pga_aggregate_target b/c of another extremely suckly oracle product called MTS (aka Shared Server) (I think you mentioned this one earlier as well)

We'll keep this in mind, thanks. I had only one unconfirmed report of this problem since upgrade, but in it was pretty obvious, data 'owned' by certain app users inserted in the wrong schema, which could be verified with timestamps only, didn't even have to dig with 'log miner' (which I wasn't really looking forward to do anyway)
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu Jul 26 2007 - 13:02:05 CDT

Original text of this message