Solved

script for checking Disk , Tablespace and index Fragmentation

Posted on 2011-03-07
5
1,100 Views
Last Modified: 2012-05-11
Hello,

I search a script for checking :

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

Thanks

Regards

bibi
0
Comment
Question by:bibi92
5 Comments
 
LVL 1

Expert Comment

by:dbradley626
ID: 35057120
in the cmd type chkdsk
0
 

Author Comment

by:bibi92
ID: 35059193
For windows, yes, I know this command.
I search a script for checking Disk , Tablespace and index Fragmentation on Oracle.

Thanks

bibi
0
 
LVL 5

Accepted Solution

by:
jaiminpsoni earned 500 total points
ID: 35060103
Check this....

http://www.orafaq.com/node/1936 (Table Fragmentation)
http://www.orafaq.com/scripts/sql/idxfrag.txt (Index Fregmentation)
0
 
LVL 47

Expert Comment

by:schwertner
ID: 35060115
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
 

Author Closing Comment

by:bibi92
ID: 35086113
Thanks bibi
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now