Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: fragmentation analysis
Fragmentation of tablespaces is *not* a performance problem, it's a waste of
space problem. Look elsewhere if poor performance is the symptom.
But, just out of interest, issue the following query:
select tablespace_name, count(*), max(blocks), sum(blocks) from dba_free_space;
If count(*) goes through the roof, and max(blocks) sinks to the floor, you've got lots of pieces of free space, none of which is very big -and that's fragmentation. You could also be moderately concerned if max(blocks) is a tiny proportion of sum(blocks) -it indicates much the same issue.
Regards
HJR
-- ------------------------------------------ Oracle Resources: http://www.hjrdba.com ============================ "A Wong" <ajkwong5_at_hotmail.com> wrote in message news:OXM58.27240$jb.1418105_at_news2.calgary.shaw.ca...Received on Wed Jan 30 2002 - 03:30:27 CST
> what can I run to determine if the database is fragmented?
> I've used TOAD, and analysed the tablespaces, and it seems okay...but not
> sure how indepth this goes into everything... performance is slow, and I
> can't figure out why.
>
>