Database Tuning (MOSC)

MOSC Banner

high "direct path read" in insert

edited Aug 4, 2011 9:16AM in Database Tuning (MOSC) 2 commentsAnswered
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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center