Then my guess is that maybe on the index rebuild it updated chained
count while reading the table.

-----Original Message-----
From: Navendu
[mailto:oracledba-ezmlmshield-x12762140.[Email address protected]
Sent: Friday, December 29, 2006 10:26 PM
To: LazyDBA Discussion
Subject: RE: Chained Rows Repair

Jed,

But i didn't move the table, i moved the all the indexes for that
specific
table to an another tablspace by using the below command

ALTER INDEX <index_name> REBUILD TABLESPACE <new tablespace>

Thanks and Regards,
Navendu Badal Mohanty
IBS (Petroleum), Reliance Industries Ltd,
Petroleum House, 'A' wing, 2nd Floor, DAKC,
Navi Mumbai-400709
Ph(O) : 022-67270507
Mob(O): 09867687986




"Walker Jed S "

<oracledba-ezmlms

hield-x37882510.x
To
[Email Address Removed] "LazyDBA Discussion"

a.com> <[Email address protected]


cc
12/29/2006 06:54

AM
Subject
RE: Chained Rows Repair

















Chained count is updated when you do an analyze table ... (read the
docs). When you moved the table and rebuilt the index it recalculated
it, thus the change.

-----Original Message-----
From: Navendu
[mailto:oracledba-ezmlmshield-x71133891.[Email address protected]
Sent: Friday, December 29, 2006 2:05 AM
To: LazyDBA Discussion
Subject: Chained Rows Repair


I have a Oracle database9i running on solaris 5.9.

I had found that one of my schema table was having a total chain_cnt of
4617.

I anlyzed the table and repaired the chained rows for atleast for 3-4
times
but no change was there in chain_cnt

Then i found that the table's data segment and its index segment are on
the
same tablsespace.

So, moved and rebuild all the indexes of that table to an another
tablespace.

After,that i analyze the table and repaired the chained rows and
suddenly
chain_cnt got dropped to 817

Here,i would like to know what was the exact reason that it got dropped
from 4617 to 817 ???

Please help somebody, i am a new commer to the Oracle DBA....


Thanks and Regards,
Navendu Badal Mohanty



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page