Re: LIOs on INSERT?
- From: Patty.Charlebois@xxxxxxxxxxxxxx
- To: ryan_gaffuri@xxxxxxxxxxx
- Date: Thu, 10 Feb 2005 10:55:45 -0500
There are no triggers and no foreign keys on this table=2E
ryan_gaffuri@comcast=2Enet=20=
Sent by: oracle-l-bounce@freelists=2Eorg
2005/02/10 10:20 AM
Please respond to
ryan_gaffuri@comcast=2Enet
To
Patty=2ECharlebois@greenshield=2Eca, oracle-l@freelists=2Eorg
cc
Subject
Re: LIOs on INSERT?
check your triggers and constraints=2E see what is being fired when you do=20=
the insert=2E foreign key means a lookup in a parent table=2E trigger could
be=20=
selecting from somewhere=2E=20=
-------------- Original message --------------=20=
> I am trying to tune a custom app running on Oracle 9=3D2E2=3D2E0=3D2E5 for
> AIX=20=
5L=3D20=3D=20=
> (64bit) and found the following SQL in my statspack snapshot=3D2E=3D20=3D=20=
>=20=
>=20=
> 1) Why there are so many LIOs on an INSERT statement?=20=
> 2) What can I do to reduce the LIOs?=20=
>=20=
> TIA=3D2E=3D2E=3D2E=3D2E Patty=20=
>=20=
> INSERT INTO PROD=3D2ECLAIM_RELATED_RULE ( CLRR_CLAIM_RULE_ID,=3D20=3D=20=
> CF_CLAIM_FORM_ID,=3D20=3D=20=
> CLAIM_FORM_REVISION_NO, CL_CLAIM_ID, CLAIM_REVISION_NO,=20=
CD_DETAIL_ID,=3D20=3D=20=
--
http://www=2Efreelists=2Eorg/webpage/oracle-l
----------------------------------------------------------
This e-mail is confidential, intended solely for the use of the
recipient(s) to whom it was addressed=2E If you have received it
in error, please do not copy or distribute this e-mail=2E We ask
that you notify us immediately by replying to the sender and
then delete this e-mail=2E E-mail sent or received over the
internet may not be secure=2E You should use caution when sending
e-mail messages containing private and confidential information
or consider other secure means to send the information=2E If you
have any questions regarding the authenticity or security of
e-mail you have received from Green Shield Canada please do not
hesitate to contact us at 1-800-265-5615=2E
Please visit us at our website: http://www=2Egreenshield=2Eca
----------------------------------------------------------
Ce message de courriel est confidentiel et s=92adresse uniquement
=E0 la personne ou =E0 l=92organisme indiqu=E9(e)=2E Si vous l=92avez re=E7u
par erreur, veuillez ne pas copier ni distribuer ce message de
courriel=2E Nous vous demandons de nous aviser imm=E9diatement en
r=E9pondant =E0 l=92exp=E9diteur, puis en supprimant ce message=2E Les
messages envoy=E9s ou re=E7us par courriel pourraient ne pas =EAtre
s=E9curis=E9s=2E Vous devriez =EAtre prudent lorsque vous envoyez des
messages de courriel contenant des renseignements confidentiels
et priv=E9s ou songer =E0 prendre d=92autres moyens s=E9curis=E9s pour
envoyer les renseignements=2E Si vous avez des questions concernant
l=92authenticit=E9 ou la s=E9curit=E9 d=92un courriel que vous avez re=E7u de
Green Shield Canada, n=92h=E9sitez pas =E0 communiquer avec nous au
1-800-265-5615=2E
Visitez notre site Web: http://www=2Egreenshield=2Eca
--
//www.freelists.org/webpage/oracle-l
Other related posts:
