Re: any problem rebuilding indexes used for replication

2003-11-06 Thread Jared . Still
by: [EMAIL PROTECTED] 11/05/2003 06:14 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:any problem rebuilding indexes used for replication Hello, I have to rebuild some primary key indexes due to excessive

Re: any problem rebuilding indexes used for replication

2003-11-06 Thread renu r
Jared : I think it is fragmented based on scripts and knowing that there have been lot of deletes. Onescript uses the table index_stats and looks at field del_lf_rows which should be less at least in comparison to field lf_rows. Imean less is good. more bad. I am not sure about the script but I

Re: any problem rebuilding indexes used for replication

2003-11-06 Thread Jared . Still
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: any problem rebuilding indexes used for replication Jared : I think it is fragmented based on scripts and knowing that there have been lot of deletes. One script uses the table index_stats and looks

Re: any problem rebuilding indexes used for replication

2003-11-06 Thread Yong Huang
: Subject:any problem rebuilding indexes used for replication Hello, I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I

Re: any problem rebuilding indexes used for replication

2003-11-06 Thread Jared . Still
PROTECTED] cc: Subject:any problem rebuilding indexes used for replication Hello, I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I

Re: any problem rebuilding indexes used for replication

2003-11-06 Thread zhu chao
:any problem rebuilding indexes used for replication Hello, I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I do that. Has anyone tried

Re: any problem rebuilding indexes used for replication

2003-11-06 Thread Yong Huang
PROTECTED] cc: Subject:Re: any problem rebuilding indexes used for replication renu (and Jared), The reason I'm very interested in whether there's performance improvement is that there's a thread on the newsgroup about index rebuild recently. See http

Re: any problem rebuilding indexes used for replication

2003-11-06 Thread Yong Huang
PROTECTED] Sent by: [EMAIL PROTECTED] 11/05/2003 06:14 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:any problem rebuilding indexes used for replication

Re: any problem rebuilding indexes used for replication

2003-11-06 Thread Wolfgang Breitling
] Sent by: [EMAIL PROTECTED] 11/05/2003 06:14 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:any problem rebuilding indexes used for replication Hello, I have to rebuild some

any problem rebuilding indexes used for replication

2003-11-05 Thread renu r
Hello, Ihave torebuild some primary key indexesdue to excessive fragmentation. It is rebuild not drop and create.We have multi master replication running. Is there any problem to replicationif I do that. Has anyone tried it? TIA. Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard

Re: any problem rebuilding indexes used for replication

2003-11-05 Thread Yong Huang
Hi, renu, I'll let experts anwser your question. But I have a request for you. Before and after you rebuild (or coalesce) your indexes, please make close observation on your application performance, as well as the statistics and sizes of the indexes. I'd like to know whether rebuilding them