Re: index rebuild

2003-07-23 Thread AK
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 tab

RE: index rebuild

2003-07-23 Thread DENNIS WILLIAMS
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: Mul

Re: index rebuild

2003-07-23 Thread zhu chao

Re: index rebuild

2003-07-23 Thread Ron Rogers
te 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 inde

Re: index rebuild

2003-07-23 Thread Joan Hsieh
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

Re: index rebuild

2003-07-23 Thread AK
, July 23, 2003 11:49 AM Subject: Re: index rebuild Hi!   For index, yes, if you use: alter index 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.

RE: index rebuild

2003-07-23 Thread Gogala, Mladen
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

Re: index rebuild

2003-07-23 Thread Tanel Poder
Hi!   For index, yes, if you use: alter index 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 Se

Re: index rebuild

2003-07-23 Thread Joan Hsieh
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 . > > -a

RE: INDEX REBUILD

2003-06-19 Thread DENNIS WILLIAMS
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 nee

RE: INDEX REBUILD

2003-06-19 Thread Seefelt, Beth
; >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 >= >''

Re: INDEX REBUILD

2003-06-19 Thread Seema Singh
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_t

RE: INDEX REBUILD

2003-06-19 Thread Guang Mei
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

Re: INDEX REBUILD

2003-06-19 Thread zhu chao
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 wi

Re: INDEX REBUILD

2003-06-19 Thread Arup Nanda
Seema, Select last_ddl_time and timestamp from user_objects where the object_name = '' 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 rebu

RE: INDEX REBUILD

2003-06-19 Thread DENNIS WILLIAMS
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 Lif

RE: INDEX REBUILD

2003-06-19 Thread John Clarke
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