check your triggers and constraints. see what is being fired when you do the insert. foreign key means a lookup in a parent table. trigger could be selecting from somewhere.
-------------- Original message --------------
> I am trying to tune a custom app running on Oracle 9=2E2=2E0=2E5 for AIX 5L=20=
> (64bit) and found the following SQL in my statspack snapshot=2E=20=
>
>
> 1) Why there are so many LIOs on an INSERT statement?
> 2) What can I do to reduce the LIOs?
>
> TIA=2E=2E=2E=2E Patty
>
> INSERT INTO PROD=2ECLAIM_RELATED_RULE ( CLRR_CLAIM_RULE_ID,=20=
> CF_CLAIM_FORM_ID,=20=
> CLAIM_FORM_REVISION_NO, CL_CLAIM_ID, CLAIM_REVISION_NO, CD_DETAIL_ID,=20=
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 10 2005 - 10:22:59 CST
