| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: LIOs on INSERT?
I am using ASSM for the indexes, not the tables (we are working our way=20=
towards full ASSM)=2E
How did you conclude that Oracle was chasing down the freelist from the=20= sql trace? What do I look for and what did you do about it?
Patty
Wolfgang Breitling <breitliw_at_centrexcc=2Ecom>=20= 2005/02/10 11:06 AM
To
Patty=2ECharlebois_at_greenshield=2Eca
cc
ryan_gaffuri_at_comcast=2Enet, oracle-l_at_freelists=2Eorg,=20=
oracle-l-bounce_at_freelists=2Eorg
Subject
Re: LIOs on INSERT?
Has that table been heavily deleted from prior to the insert so that now=20=
almost=20=
all blocks are on the free list - I just realize that I assume you are not=20=
using ASSM?
I did run into a similar scenario with an insert with lots of LIO and I=20=
had the=20=
same question as you=2E Looking at a detailed sql trace (10046 level 8) I=20=
eventually concluded that is was because Oracle was chasing down the=20=
freelist=20=
for the next block to insert into=2E
The other possibility, If you ARE using ASSM (and are on 9=2E2=2E0=2E5) is that=20=
you=20=
are running into the insert - delete - insert bug of 9=2E2=2E0=2E5=2E
Quoting Patty=2ECharlebois_at_greenshield=2Eca:
> There are no triggers and no foreign keys on this table=3D2E
>=20= >=20= >=20= >=20=
>=20= >=20=
>=20=
>=20= >=20= >=20= >=20= >=20= >=20=
>=20= >=20=
>=20= >=20=
>=20= >=20= >=20= >=20= >=20= >=20= >=20= >=20=
> ----------------------------------------------------------
>=20=
>=20=
>=20= >=20=
> ----------------------------------------------------------
>=20=
>=20=
>=20=
--=20=
regards
Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www=2Ecentrexcc=2Ecom
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 au1-800-265-5615=2E
Visitez notre site Web: http://www=2Egreenshield=2Eca
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 10 2005 - 13:55:02 CST
 |
 |