Re: LIOs on INSERT?
- From: ryan_gaffuri@xxxxxxxxxxx
- To: Patty.Charlebois@xxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 10 Feb 2005 15:20:15 +0000
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=
--
//www.freelists.org/webpage/oracle-l
Other related posts:
