script for checking Disk , Tablespace and index Fragmentation

Hello,

I search a script for checking :

1.Disk and Tablespace Fragmentation
2.Table Fragmentation – this bit
2.Index Fragmentation

Thanks

Regards

bibi
bibi92Asked:
Who is Participating?
 
jaiminpsoniConnect With a Mentor Commented:
Check this....

http://www.orafaq.com/node/1936 (Table Fragmentation)
http://www.orafaq.com/scripts/sql/idxfrag.txt (Index Fregmentation)
0
 
dbradley626Commented:
in the cmd type chkdsk
0
 
bibi92Author Commented:
For windows, yes, I know this command.
I search a script for checking Disk , Tablespace and index Fragmentation on Oracle.

Thanks

bibi
0
 
schwertnerCommented:
Oracle tries to avoid fragmentation using segments, parameters like PCTUSED, PCTFREE
but nevertheless fragmentation occurs especially by indexes due logical ("lazy") delete algorithm used in the DBs.

Defragmentation is a time and resource consuming process and the DBs in many cases are not doing defragmentation in order to speed up the processing. Often also caches like SHARED_POOL are badly fragmented.

Some useful links:


http://www.orafaq.com/node/1936

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1092233274210
0
 
bibi92Author Commented:
Thanks bibi
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.