Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need AVG fragmentation in percent for all indexes

2757008Sep 23 2014 — edited Sep 23 2014

Hi,

I have a SQL SERVER 2012 query that gives me the "avg_fragmentation_in_percent" for all the indexes that i created against each table.

Query:

SELECT *

FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL)

ORDER BY avg_fragmentation_in_percent DESC

Capture.JPG

I want the same in oracle.

Could anyone help me here.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 21 2014
Added on Sep 23 2014
1 comment
257 views