high "direct path read" in insert
Hi,
We have the following insert:
output tkprof :
--------------------
INSERT INTO FACDIA
( FACDIA_CODIENTI, FACDIA_FECENVNOV, FACDIA_TIPOIDEN,
FACDIA_NUMEIDEN, FACDIA_NOVEENTR, FACDIA_NOVRESUNO, FACDIA_NOVRESDOS,
FACDIA_PRIMNOMB, FACDIA_SEGUNOMB, FACDIA_PRIMAPEL, FACDIA_SEGUAPEL,
FACDIA_TIPIDEDOS, FACDIA_NUMIDEDOS, FACDIA_PRINOMDOS, FACDIA_SEGNOMDOS,
FACDIA_PRIAPEDOS, FACDIA_SEGAPEDOS, FACDIA_CODENTUNO, FACDIA_CODENTDOS,
FACDIA_CODENTTRE, FACDIA_FECINVUNO, FACDIA_FECINVDOS, FACDIA_FECINVTRE,
FACDIA_FECINVCUA, FACDIA_CAMGENUNO, FACDIA_CAMGENDOS, FACDIA_CAMGENTRE,
FACDIA_CAMGENCUA, FACDIA_CAMGENCIN, FACDIA_CAMGENSEI, FACDIA_CAUSOPUNO,
FACDIA_CAUSOPDOS, FACDIA_INDIUNO, FACDIA_INDIDOS, FACDIA_INDITRES,
FACDIA_VALOR, FACDIA_TIPIDEEMP, FACDIA_NUMIDEEMP, FACDIA_RAZOSOCI,
FACDIA_CODIMAUNO, FACDIA_CODIMADOS, FACDIA_CODTARPEN, FACDIA_FECHLLEG,
FACDIA_ARCHORIG, FACDIA_INDIPROC, FACDIA_USUACREA, FACDIA_FECHCREA,
We have the following insert:
output tkprof :
--------------------
INSERT INTO FACDIA
( FACDIA_CODIENTI, FACDIA_FECENVNOV, FACDIA_TIPOIDEN,
FACDIA_NUMEIDEN, FACDIA_NOVEENTR, FACDIA_NOVRESUNO, FACDIA_NOVRESDOS,
FACDIA_PRIMNOMB, FACDIA_SEGUNOMB, FACDIA_PRIMAPEL, FACDIA_SEGUAPEL,
FACDIA_TIPIDEDOS, FACDIA_NUMIDEDOS, FACDIA_PRINOMDOS, FACDIA_SEGNOMDOS,
FACDIA_PRIAPEDOS, FACDIA_SEGAPEDOS, FACDIA_CODENTUNO, FACDIA_CODENTDOS,
FACDIA_CODENTTRE, FACDIA_FECINVUNO, FACDIA_FECINVDOS, FACDIA_FECINVTRE,
FACDIA_FECINVCUA, FACDIA_CAMGENUNO, FACDIA_CAMGENDOS, FACDIA_CAMGENTRE,
FACDIA_CAMGENCUA, FACDIA_CAMGENCIN, FACDIA_CAMGENSEI, FACDIA_CAUSOPUNO,
FACDIA_CAUSOPDOS, FACDIA_INDIUNO, FACDIA_INDIDOS, FACDIA_INDITRES,
FACDIA_VALOR, FACDIA_TIPIDEEMP, FACDIA_NUMIDEEMP, FACDIA_RAZOSOCI,
FACDIA_CODIMAUNO, FACDIA_CODIMADOS, FACDIA_CODTARPEN, FACDIA_FECHLLEG,
FACDIA_ARCHORIG, FACDIA_INDIPROC, FACDIA_USUACREA, FACDIA_FECHCREA,
0