Database Administration (MOSC)

MOSC Banner

Script to find fragmented tables in Oracle 10g

edited Apr 22, 2010 8:18AM in Database Administration (MOSC) 15 commentsAnswered
 Hi,

Please let me know how do I findout the tables which are fragmented in oracle 10g...

Note : Considering business needs, we can not gather the table STATS..

Is there any way to findout the fragmented tables in a schema without collecting STATS using Analyze stmt or DBMS_STATS package.

Your help is much appreciated.

Thanks,

Riaz

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center