Re: index rebuild
Hi! For index, yes, if you use: alter index name rebuild compute statistics; But don't rebuild your indexes daily, it's an expensive operation... and you won't gain much from it anyway. Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 23, 2003 9:14 PM Subject: index rebuild Does index rebuild generates new statistics as well ? How does that can hit performance intermediately if I want to rebuild few indexes daily just to finish everything in 5 days . -ak
RE: index rebuild
Oh yes, index rebuild will solve all your problems. sqlplus "/ as sysdba" rtfm immediate Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 2:15 PMTo: Multiple recipients of list ORACLE-LSubject: index rebuild Does index rebuild generates new statistics as well ? How does that can hit performance intermediately if I want to rebuild few indexes daily just to finish everything in 5 days . -ak
Re: index rebuild
The only reason I wanted to build the indexes was to relocate them to another tablespace ( LMT ) so that I can get rid of high fragmentation and start living . -ak - Original Message - From: Tanel Poder To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 23, 2003 11:49 AM Subject: Re: index rebuild Hi! For index, yes, if you use: alter index name rebuild compute statistics; But don't rebuild your indexes daily, it's an expensive operation... and you won't gain much from it anyway. Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 23, 2003 9:14 PM Subject: index rebuild Does index rebuild generates new statistics as well ? How does that can hit performance intermediately if I want to rebuild few indexes daily just to finish everything in 5 days . -ak
Re: index rebuild
yeh, just found the rebuid_clause syntax have compute statistics option. My-bad. joan Joan Hsieh wrote: Ak, I just know you can collect statistics while creating index not rebuild index. Joan AK wrote: Does index rebuild generates new statistics as well ? How does that can hit performance intermediately if I want to rebuild few indexes daily just to finish everything in 5 days . -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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: index rebuild
ak, You have to give a little to get a little. LMT for the indexes with partitioning will help performance in the long run. It also make maintenance of the database easier. Ron [EMAIL PROTECTED] 07/23/03 05:14PM The only reason I wanted to build the indexes was to relocate them to another tablespace ( LMT ) so that I can get rid of high fragmentation and start living . -ak - Original Message - From: Tanel Poder To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 23, 2003 11:49 AM Subject: Re: index rebuild Hi! For index, yes, if you use: alter index name rebuild compute statistics; But don't rebuild your indexes daily, it's an expensive operation... and you won't gain much from it anyway. Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 23, 2003 9:14 PM Subject: index rebuild Does index rebuild generates new statistics as well ? How does that can hit performance intermediately if I want to rebuild few indexes daily just to finish everything in 5 days . -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: index rebuild
RE: index rebuild
AK Even though you can rebuild indexes online, it is a good idea to perform this task when the table is being hit with only a light DML load. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Hi! For index, yes, if you use: alter index name rebuild compute statistics; But don't rebuild your indexes daily, it's an expensive operation... and you won't gain much from it anyway. Tanel. - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Wednesday, July 23, 2003 9:14 PM Does index rebuild generates new statistics as well ? How does that can hit performance intermediately if I want to rebuild few indexes daily just to finish everything in 5 days . -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: index rebuild
Yeap , Thanks Dennis . I am keeping that in mind . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:54 PM AK Even though you can rebuild indexes online, it is a good idea to perform this task when the table is being hit with only a light DML load. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Hi! For index, yes, if you use: alter index name rebuild compute statistics; But don't rebuild your indexes daily, it's an expensive operation... and you won't gain much from it anyway. Tanel. - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Wednesday, July 23, 2003 9:14 PM Does index rebuild generates new statistics as well ? How does that can hit performance intermediately if I want to rebuild few indexes daily just to finish everything in 5 days . -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: AK 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: INDEX REBUILD
encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. winmail.dat
RE: INDEX REBUILD
Seema - If you analyze in conjunction with rebuilds, you could track with the LAST_ANALYZED column in USER_INDEXES table. That is all I can think of. Why do you ask? Jared has spoken eloquently about how frequent index rebuilds can reduce your performance. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 19, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Hi, Is any view available which can tell us indexe rebuild status in 8i? Means how can we know these are indexes rebuilded recently? thx -Seema _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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: DENNIS WILLIAMS 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: INDEX REBUILD
hi, From user_objects.last_ddl_time. Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 20, 2003 12:00 AM Seema - If you analyze in conjunction with rebuilds, you could track with the LAST_ANALYZED column in USER_INDEXES table. That is all I can think of. Why do you ask? Jared has spoken eloquently about how frequent index rebuilds can reduce your performance. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 19, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Hi, Is any view available which can tell us indexe rebuild status in 8i? Means how can we know these are indexes rebuilded recently? thx -Seema _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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: DENNIS WILLIAMS 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 - 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: INDEX REBUILD
Where can I find more detail info about frequent index rebuilds can reduce your performance ? Thanks. Guang -Original Message- Sent: Thursday, June 19, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Seema - If you analyze in conjunction with rebuilds, you could track with the LAST_ANALYZED column in USER_INDEXES table. That is all I can think of. Why do you ask? Jared has spoken eloquently about how frequent index rebuilds can reduce your performance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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: INDEX REBUILD
Anup this view will not help in 8i. thanks anyway! From: Arup Nanda [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: INDEX REBUILD Date: Thu, 19 Jun 2003 08:20:06 -0800 Seema, Select last_ddl_time and timestamp from user_objects where the object_name = 'index' HTH Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:29 AM Hi, Is any view available which can tell us indexe rebuild status in 8i? Means how can we know these are indexes rebuilded recently? thx -Seema _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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: Arup Nanda 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). _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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: INDEX REBUILD
8i which release? It was broken in 8.1.6 and before, but fixed in 8.1.7. -Original Message- Sent: Thursday, June 19, 2003 2:01 PM To: Multiple recipients of list ORACLE-L Anup this view will not help in 8i. thanks anyway! From: Arup Nanda [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: INDEX REBUILD Date: Thu, 19 Jun 2003 08:20:06 -0800 Seema, Select last_ddl_time and timestamp from user_objects where the object_name = 'index' HTH Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:29 AM Hi, Is any view available which can tell us indexe rebuild status in 8i? Means how can we know these are indexes rebuilded recently? thx -Seema _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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: Arup Nanda 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). _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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: Seefelt, Beth 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: INDEX REBUILD
Guang - Below is what Jared said on this topic: Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 26, 2002 9:14 PM To: Multiple recipients of list ORACLE-L Though I have published a script for determining indexes that need to be rebuilt, and then rebuilding them, I have to say that this is almost never necessary. Why are you rebuilding indexes? About the only reason for ever doing so is that the BLEVEL = 5. go to asktom.oracle.com, and do a search on 'index rebuild'. Currently, the third article may be of interest. Jared -Original Message- Sent: Thursday, June 19, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Where can I find more detail info about frequent index rebuilds can reduce your performance ? Thanks. Guang -Original Message- Sent: Thursday, June 19, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Seema - If you analyze in conjunction with rebuilds, you could track with the LAST_ANALYZED column in USER_INDEXES table. That is all I can think of. Why do you ask? Jared has spoken eloquently about how frequent index rebuilds can reduce your performance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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: DENNIS WILLIAMS 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).