Re: high gets per execution for an update based on rowid

     No triggers? No index on combo?

> Hi, listers,
>
> The update based on rowid as shown below, which is a statement issued by SharePlex process at the target database, has about 2.5 K per execution, any thoughts about what could the cause?
> we truncate the table per support, we rebuild the table,we move it to another tablespace, we change inittrans, pctfree, pctused, not help.
>
>
> Denis

-- 
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>


--
http://www.freelists.org/webpage/oracle-l