Home » RDBMS Server » Performance Tuning » fragmented tables and indexes
fragmented tables and indexes [message #159605] Mon, 20 February 2006 09:49 Go to next message
uv_anil
Messages: 4
Registered: February 2006
Junior Member
Hi,
This is anil. I got a very good response for my posting previously. Thanks a lot.
please help me in this issue also..

How to find most fragmented tables and indexes in a database?

what is the criteria for searching top ten fragmented tables and indexes in a database?

if there is any script for this please share it with me.

Thanks every one in advance,
Anil
Re: fragmented tables and indexes [message #159609 is a reply to message #159605] Mon, 20 February 2006 10:13 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please search the board for 'FRAGMENTATION' or 'LMT'.
Fragmentation is almost a outdated concept now, unless you are using a dictionary managed tablespace ( still, you cannot completely eliminate it).
If you are using DMT with a with non-zero pctincrease or INITIAL is not EQUAL to NEXT, you may have fragmentation.
for the scripts, again search the board. there are many many versions of the same posted again and again
One such is here
http://www.orafaq.com/scripts/sql/tsfrag.txt
Previous Topic: Generate the execution plan for a stored procedure !!
Next Topic: Analyze Table
Goto Forum:
  


Current Time: Thu Mar 28 03:34:59 CDT 2024