Database Tuning (MOSC)

MOSC Banner

fragmentation of data in oracle 10g

edited Sep 26, 2012 1:05AM in Database Tuning (MOSC) 12 commentsAnswered
Good afternoon folks,

I have a client who is concerned that the recent poor performance on some databases is due to data fragmentation.

I am trying to convince the client that reorging the data or indexes will have little effect. Am I right?

We have segment space management on our tablespaces and locally managed tablespaces.

So in my view we are handling space far more efficiently than previously.

Are there some fragmentation issues that I should check out or should we be looking somewhere else for performance issues.

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