4 Replies Latest reply on Jun 17, 2010 7:27 AM by 416690

    database fragmentation

    416690
      I have a question about database fragmentation.

      I know that fragmentation can reduce performance in query times. The blocks are distributes
      in many extents and scans process takes a long time. Oracle engine have to locate the address
      of the next extent..

      I want to know if there is any system view in which you can check if your table or index
      has high fragmentation. If it's needed I will have to re-create, move or rebulid the table or index, but before I want to know if the degree of fragmentation is high.

      Any useful script or query to do this, any interesting oracle system view??

      Any advice will bre greatly apreciatted.

      Thanks in advance