Re: any problem rebuilding indexes used for replication
I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL 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 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 it? TIA. Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
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. 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 will post it here if someonesays soor send it to anyone if they want. I am sure the expertshere know about it and can clarify if it is any good to look at the index_stats table. One other simple useful script is : SELECTowner, index_name, blevelFROMall_indexesWHEREblevel 2 This can be bacause the size of table is big so it is not definitive. I will check the level after rebuild. Benefits expected : Space savings (definitely). performance (hopefully). I will let you and Yong know about the benefits if any. If I get some help. [EMAIL PROTECTED] wrote: I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL 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 replicationHello, 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 it? TIA. Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuard Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
Re: any problem rebuilding indexes used for replication
Re the space savings: that may or not be important. Guess it depends on how tight storage space is in your environment, and how much of an impact it may make on your backups. Re the performance: Some queries could perform better due to the index data being packed into fewer blocks, as you are expecting. It could also result in decreased performance for inserts, for the same reason. An index with all data tightly packed into nearly full blocks makes it a good candidate for excessive block splits when data is inserted into the table. You could allow a generous PCTFREE when you rebuild to alleviate this, but then there would not be much point in rebuilding the index. You might consider targeting your most expensive operations ( eg. the SQL that causes the users and/or the system the most pain ) and then look at the indexes involved to see if rebuilding them would increase or decrease performance. Lots of discussion lately on this list on how to go about doing that. ( Optimizing Oracle Performance - http://www.oreilly.com/catalog/optoraclep/ ) HTH Jared renu r [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/06/2003 02:29 PM Please respond to ORACLE-L 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 at field del_lf_rows which should be less at least in comparison to field lf_rows. I mean less is good. more bad. I am not sure about the script but I will post it here if someone says so or send it to anyone if they want. I am sure the experts here know about it and can clarify if it is any good to look at the index_stats table. One other simple useful script is : SELECT owner, index_name, blevel FROM all_indexes WHERE blevel 2 This can be bacause the size of table is big so it is not definitive. I will check the level after rebuild. Benefits expected : Space savings (definitely). performance (hopefully). I will let you and Yong know about the benefits if any. If I get some help. [EMAIL PROTECTED] wrote: I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL 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 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 it? TIA. Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
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://groups.google.com/groups?threadm=pan.2003.11.03.08.09.24.330520%40RE-MO-VE.BountifulSolutions.co.uk Jonathan Lewis says there's almost no need to rebuild indexes, although his Practical Oracle8i lists at least one case you may benefit by rebuilding. (I don't have the book with me). Asktom.oracle.com has numerous messages advising against rebuilding indexes. Let's set theory aside for a moment and do the experiment. Please post your report of performance change. Thanks. Yong Huang --- renu r [EMAIL PROTECTED] wrote: 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 at field del_lf_rows which should be less at least in comparison to field lf_rows. I mean less is good. more bad. I am not sure about the script but I will post it here if someone says so or send it to anyone if they want. I am sure the experts here know about it and can clarify if it is any good to look at the index_stats table. One other simple useful script is : SELECT owner, index_name, blevel FROM all_indexes WHERE blevel 2 This can be bacause the size of table is big so it is not definitive. I will check the level after rebuild. Benefits expected : Space savings (definitely). performance (hopefully). I will let you and Yong know about the benefits if any. If I get some help. [EMAIL PROTECTED] wrote: I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL 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 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 it? TIA. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: any problem rebuilding indexes used for replication
I think Jonathan is correct when he says that index rebuilds are not often needed. Tom Kyte states that they are never needed, which I don't believe to be correct. I'll try to back this up with data in the future. So if Tom asks any of you why you don't use automatic space management in your LMT's, you can ask him why he doesn't use 'alter index rebuild'. ;) Jared Yong Huang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/06/2003 02:59 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL 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://groups.google.com/groups?threadm=pan.2003.11.03.08.09.24.330520%40RE-MO-VE.BountifulSolutions.co.uk Jonathan Lewis says there's almost no need to rebuild indexes, although his Practical Oracle8i lists at least one case you may benefit by rebuilding. (I don't have the book with me). Asktom.oracle.com has numerous messages advising against rebuilding indexes. Let's set theory aside for a moment and do the experiment. Please post your report of performance change. Thanks. Yong Huang --- renu r [EMAIL PROTECTED] wrote: 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 at field del_lf_rows which should be less at least in comparison to field lf_rows. I mean less is good. more bad. I am not sure about the script but I will post it here if someone says so or send it to anyone if they want. I am sure the experts here know about it and can clarify if it is any good to look at the index_stats table. One other simple useful script is : SELECT owner, index_name, blevel FROM all_indexes WHERE blevel 2 This can be bacause the size of table is big so it is not definitive. I will check the level after rebuild. Benefits expected : Space savings (definitely). performance (hopefully). I will let you and Yong know about the benefits if any. If I get some help. [EMAIL PROTECTED] wrote: I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL 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 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 it? TIA. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: any problem rebuilding indexes used for replication
Hi,
In some case, rebuild index can help, this is from my work log on my Datawarehouse
project.
The effect of rebuiding index:
SQL exec show_space('INX_BID_BIDTYPE',USER,'INDEX')
Free Blocks.22
Total Blocks4090
Total Bytes.33505280
Unused Blocks...823
Unused Bytes6742016
Last Used Ext FileId11
Last Used Ext BlockId...52851
Last Used Block.547
PL/SQL procedure successfully completed.
SQL select index_name,owner,blevel,index_type from dba_indexes where blevel4;
INDEX_NAME OWNER BLEVEL INDEX_TYPE
-- -- --
---
INX_BID_BIDTYPEDAILYLOAD 10 BITMAP
INX_TX_CC_STATUS_IDDAILYLOAD 6 BITMAP
INX_TX_BD_STATUS_IDDAILYLOAD 5 BITMAP
SQL ALTER INDEX INX_BID_BIDTYPE REBUILD;
Index altered.
SQL exec show_space('INX_BID_BIDTYPE',USER,'INDEX')
Free Blocks.0
Total Blocks5
Total Bytes.40960
Unused Blocks...3
Unused Bytes24576
Last Used Ext FileId15
Last Used Ext BlockId...39837
Last Used Block.2
PL/SQL procedure successfully completed.
DAILYSOURCEINX_STD_ST_STATEMENTID
122910
149 rows selected.
SQL CONN SYSTEM/[EMAIL PROTECTED]
Connected.
SQL ALTER INDEX DAILYSOURCE.INX_STD_ST_STATEMENTID REBUILD;
Index altered.
SQL select 122910*16/1024 from dual;
122910*16/1024
--
1920.46875
SQL select blocks from dba_segments where segment_name='INX_STD_ST_STATEMENTID';
BLOCKS
--
54642
SQL SELECT 54642*16/1024 FROM DUAL;
54642*16/1024
-
853.78125
SQL SET PAUSE OFF
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 07, 2003 6:59 AM
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://groups.google.com/groups?threadm=pan.2003.11.03.08.09.24.330520%40RE-MO-VE.BountifulSolutions.co.uk
Jonathan Lewis says there's almost no need to rebuild indexes, although his
Practical Oracle8i lists at least one case you may benefit by rebuilding. (I
don't have the book with me). Asktom.oracle.com has numerous messages advising
against rebuilding indexes. Let's set theory aside for a moment and do the
experiment. Please post your report of performance change. Thanks.
Yong Huang
--- renu r [EMAIL PROTECTED] wrote:
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 at field del_lf_rows which
should be less at least in comparison to field lf_rows. I mean less is good.
more bad. I am not sure about the script but I will post it here if someone
says so or send it to anyone if they want.
I am sure the experts here know about it and can clarify if it is any good
to look at the index_stats table.
One other simple useful script is :
SELECT owner, index_name, blevel
FROM all_indexes
WHERE blevel 2
This can be bacause the size of table is big so it is not definitive. I will
check the level after rebuild.
Benefits expected : Space savings (definitely). performance (hopefully). I
will let you and Yong know about the benefits if any. If I get some help.
[EMAIL PROTECTED] wrote:
I'm curious, how have you identified the fragmentation?
What benefits do you expect from the rebuild of the indexes?
Are you targeting certain indexes that have been identified as
benefiting from a rebuild, or just planning to rebuild all indexes?
Jared
renu r [EMAIL 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
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 it? TIA.
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ
Re: any problem rebuilding indexes used for replication
--- [EMAIL PROTECTED] wrote: Tom Kyte states that they are never needed, which I don't believe to be correct. As I said two weeks ago, somewhere on the Internet people over-trusted authorities. It's different here. I love this place! I'll try to back this up with data in the future. As a Ph.D in chemistry (sorry to say this), I know how more important repeated experiments done by different people in different labs are than theory. Furthermore, a lab experiment is nothing if a product coming out of a chemical plant says no good. So if Tom asks any of you why you don't use automatic space management in your LMT's, you can ask him why he doesn't use 'alter index rebuild'. ;) Jared Yong Huang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/06/2003 02:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL 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://groups.google.com/groups?threadm=pan.2003.11.03.08.09.24.330520%40RE-MO-VE.BountifulSolutions.co.uk Jonathan Lewis says there's almost no need to rebuild indexes, although his Practical Oracle8i lists at least one case you may benefit by rebuilding. (I don't have the book with me). Asktom.oracle.com has numerous messages advising against rebuilding indexes. Let's set theory aside for a moment and do the experiment. Please post your report of performance change. Thanks. Yong Huang --- renu r [EMAIL PROTECTED] wrote: 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 at field del_lf_rows which should be less at least in comparison to field lf_rows. I mean less is good. more bad. I am not sure about the script but I will post it here if someone says so or send it to anyone if they want. I am sure the experts here know about it and can clarify if it is any good to look at the index_stats table. One other simple useful script is : SELECT owner, index_name, blevel FROM all_indexes WHERE blevel 2 This can be bacause the size of table is big so it is not definitive. I will check the level after rebuild. Benefits expected : Space savings (definitely). performance (hopefully). I will let you and Yong know about the benefits if any. If I get some help. [EMAIL PROTECTED] wrote: I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL 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 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 it? TIA. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: any problem rebuilding indexes used for replication
] 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 do that. Has anyone tried it? TIA. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services === message truncated === __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: any problem rebuilding indexes used for replication
OK, that's a bitmap index. Bitmap indexes do need to be rebuilt after
accumulated maintenance (insert-update-delete) to reclaim space and
performance. Not even Tom denies that. What he advises against is the
rebuild of b-tree indexes.
At 07:49 PM 11/6/2003, you wrote:
Hi,
In some case, rebuild index can help, this is from my work log on my
Datawarehouse project.
The effect of rebuiding index:
SQL exec show_space('INX_BID_BIDTYPE',USER,'INDEX')
Free Blocks.22
Total Blocks4090
Total Bytes.33505280
Unused Blocks...823
Unused Bytes6742016
Last Used Ext FileId11
Last Used Ext BlockId...52851
Last Used Block.547
PL/SQL procedure successfully completed.
SQL select index_name,owner,blevel,index_type from dba_indexes where
blevel4;
INDEX_NAME OWNER BLEVEL
INDEX_TYPE
-- -- --
---
INX_BID_BIDTYPEDAILYLOAD 10
BITMAP
INX_TX_CC_STATUS_IDDAILYLOAD 6
BITMAP
INX_TX_BD_STATUS_IDDAILYLOAD 5
BITMAP
SQL ALTER INDEX INX_BID_BIDTYPE REBUILD;
Index altered.
SQL exec show_space('INX_BID_BIDTYPE',USER,'INDEX')
Free Blocks.0
Total Blocks5
Total Bytes.40960
Unused Blocks...3
Unused Bytes24576
Last Used Ext FileId15
Last Used Ext BlockId...39837
Last Used Block.2
PL/SQL procedure successfully completed.
DAILYSOURCEINX_STD_ST_STATEMENTID
122910
149 rows selected.
SQL CONN SYSTEM/[EMAIL PROTECTED]
Connected.
SQL ALTER INDEX DAILYSOURCE.INX_STD_ST_STATEMENTID REBUILD;
Index altered.
SQL select 122910*16/1024 from dual;
122910*16/1024
--
1920.46875
SQL select blocks from dba_segments where
segment_name='INX_STD_ST_STATEMENTID';
BLOCKS
--
54642
SQL SELECT 54642*16/1024 FROM DUAL;
54642*16/1024
-
853.78125
SQL SET PAUSE OFF
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 07, 2003 6:59 AM
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://groups.google.com/groups?threadm=pan.2003.11.03.08.09.24.330520%40RE-MO-VE.BountifulSolutions.co.uk
Jonathan Lewis says there's almost no need to rebuild indexes, although his
Practical Oracle8i lists at least one case you may benefit by
rebuilding. (I
don't have the book with me). Asktom.oracle.com has numerous messages
advising
against rebuilding indexes. Let's set theory aside for a moment and do the
experiment. Please post your report of performance change. Thanks.
Yong Huang
--- renu r [EMAIL PROTECTED] wrote:
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 at field del_lf_rows
which
should be less at least in comparison to field lf_rows. I mean less
is good.
more bad. I am not sure about the script but I will post it here if
someone
says so or send it to anyone if they want.
I am sure the experts here know about it and can clarify if it is
any good
to look at the index_stats table.
One other simple useful script is :
SELECT owner, index_name, blevel
FROM all_indexes
WHERE blevel 2
This can be bacause the size of table is big so it is not definitive.
I will
check the level after rebuild.
Benefits expected : Space savings (definitely). performance
(hopefully). I
will let you and Yong know about the benefits if any. If I get some help.
[EMAIL PROTECTED] wrote:
I'm curious, how have you identified the fragmentation?
What benefits do you expect from the rebuild of the indexes?
Are you targeting certain indexes that have been identified as
benefiting from a rebuild, or just planning to rebuild all indexes?
Jared
renu r [EMAIL 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
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
any problem rebuilding indexes used for replication
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
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 actually makes much difference. (I don't know the answer but am very interested to know). Thanks. Yong Huang --- renu r [EMAIL PROTECTED] wrote: 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 it? TIA. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
