Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Does Index get updated ??
You may have to do a 10200 or look at a block dump to figure out whether =
a
cached block has been "touched" or not. If the operation doesn't =
motivate a
PIO, a buffer busy wait, or the like, then you're not going to see it in =
the
10046 data.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 10/5 Charlotte, 10/26 Toronto, 1/4 Calgary - SQL Optimization 101: 10/18 New Orleans, 11/8 Dallas, 12/13 Atlanta - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Bach, Peter
Sent: Monday, October 11, 2004 1:57 PM
To: zhu chao; sat0789_at_fastmail.fm
Cc: oracle-l_at_freelists.org
Subject: RE: Does Index get updated ??
Sorry, didn't clarify previous e-mail in enough details - with sql trace I was referring to event 10046 (extended sql trace).
Regards,
pba
-----Original Message-----
From: zhu chao [mailto:zhuchao_at_gmail.com]=3D20
Sent: Friday, 8 October 2004 5:52 PM
To: Bach, Peter
Cc: sat0789_at_fastmail.fm; oracle-l_at_freelists.org
Subject: Re: Does Index get updated ??
no, the index file is not updated when the loan key is the same. you can alter index tablespace read only and verify it. I don't think sql_trace will show you the whether the index is updated or not.
On Sat, 9 Oct 2004 09:27:50 +1000, Bach, Peter <pbach_at_ea.com> wrote:
> Tom Kyte has always advocated not updating or setting a value to the
> same value. So I guess the short answer is yes. But the easiest way
> to find out is to run a sql trace on you below statement and verify
your
> trace file.
>=3D20
>=3D20 >=3D20
>=3D20
>=3D20
>=3D20
>=3D20
>=3D20
>=3D20 >=3D20 >=3D20 >=3D20
--=3D20
Regards
Zhu Chao
www.cnoug.org
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 11 2004 - 20:08:49 CDT
![]() |
![]() |