Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2006
    Posts
    20

    Unanswered: database fragmentation

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Local Managed Tablespace do not fragment; so no problem exists to be solved.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    ...and you never make ANY non oracle objects in SYSTEM *directory managed), so it doesn't fragment.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Apr 2006
    Posts
    20

    database fragmentation

    Thank you, for your help.
    You're right I have LMT objects in Oracle 9i, but I have others databases in olders version, like....Oracle 7.
    In Oracle 7 I think there is fragmentation.

    Do you know any script or query to check the level of fragmentation???

    Thanks in advance

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •