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

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: denis.sun@xxxxxxxxx
  • Date: Tue, 10 Apr 2012 22:28:44 +0200

Denis,
     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>


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


Other related posts: