Steve Robin wrote:
>
> On Jan 24, 2:07 pm, "sybrandb" <sybra..._at_gmail.com> wrote:
>> On Jan 24, 6:39 am, "Steve Robin" <ocma..._at_gmail.com> wrote:
>>
>>> Hi all,
>>> I want to know, is there any way to find which tables need to be
>>> fragmented, and which index need to be rebuild.
>>> One by one I can find out this by using dbms_space package for tables
>>> (find unused blocks) and
>>> analyze index < index_name > validate structure;
>>> command and then see index_stats and find that.
>>> But I have 5 lacs tables and many indexes, how to know which schema to
>>> refresh.
>>> Right now we do that but based according period of work on any schema
>>> or wait till the performance is get down then we find it and do it.if you use LMTs fragmentation is a thing of the past.
>> I would rather spend my time on reading the Concept manual.
>>
>> --
>> Sybrand Bakker
>> Senior Oracle DBA
>
> Do we not have to refresh our tables and rebuild our indexes in oracle
> 9i.
> What you are talking about Tablespaces, but I am not. I am talking
> about tables and indexes in ORACLE 9i.
Sybrand is correct. I've seen a lot of indexes rebuilt: Rarely have I
seen a rational reason for doing so (9i and 10g).
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Jan 24 2007 - 15:57:05 CST
