| fragmented tables and indexes [message #159605] |
Mon, 20 February 2006 09:49  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
