Row movement enabled. Performance issues ?
Hi fellows,
I am using Oracle RAC 10.2.0.5 with 3 nodes.
We have a SQL query that is giving us some trouble:
delete from ISSR.CUENTAS_PROCESADAS C
where (ID_PROCESO=:b1 and exists
(select NUMERO_CUENTA from ISSR.SPLIT_CUENTAS_MENSUAL S where
((((S.EMISOR=C.EMISOR and S.SUCURSAL_EMISOR=C.SUCURSAL_EMISOR)
and S.PRODUCTO=C.PRODUCTO) and S.NUMERO_CUENTA=C.NUMERO_CUENTA)
and S.NRO_PROCESO between :b2 and :b3)))
I checked the explain plan for this query and it gives a real low cost.
The query usually works normally at the end of the month,
but this month i dunno what happened it hangs up.
I check the dba_tables and i observed that the row_movement from the table ISSR.CUENTAS_PROCESADAS is enabled.
Do you guys think that with this Row movement enabled may cause a poor performance ?
As far as i know, this row movement is used for shrinking.
Thanks in advance.
Edited by: BSalesRashid on 31/10/2012 05:13