Re: Table Fragmentation?

SG wrote:
> We have a 10.1.0.2 Standard RAC running on RHEL 3.0 ES. Our custom app runs
> great for 3 months or so and then it gets slow. The same queries get really
> slow. The indexes appear to be ok, we rebuild then as necessary. Once it
> gets slow, we export, drop user/schema with cascade, import data and all is
> back to normal speed. So, what is the first thing I should look for with
> these symptoms? We are using LMT so tablespace fragmentation shouldn't be a
> thought, correct? How about the table? I am new to this so please bare with
> me. What queries can I run against the database to get a baseline for the
> "health" of tables while running well, versus when the system "slows" down?
> Any suggest, insights, advice much appreciated. TIA.
>
> SG

Rebuilding indexes on a regular basis is an indication of something being wrong for which the fix is almost never rebuilding indexes.

You need to run StatsPack or AWR and determine what is actually wrong.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)