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
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
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
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
, 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.
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
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
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
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
;
>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
>=
>''
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
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
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
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
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
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
17 matches
Mail list logo