We are executing a billing process and after do the report with tkprof, we have found a very consuming i/o process. We have moved the table and rebuild the indexes but it appears being i/o consuming.
This is the tkprof result with the statement:
UPDATE LOG_FACTU SET SERIAL_FACTURA=:b1,CODIGO=:b2,DATOS=SUBSTR:b3,1,10 0)
ID_PROCESO = :b4 AND PRC_ID_CORRIDA = :b5 AND ID_CLIENTE = :b6 AND
ID_LINEA = :b7