table frag
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: table frag

  1. #1
    Join Date
    Jan 2001
    Posts
    72

    Unhappy

    In a nutshell, how would you describe a table fragmentation to your manager who has no oracle background

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    For me, a table is fragmentated is when the segment containts chained rows and migrated rows

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    Have him run some reports on the fragemented tables and let him see the results .you dont have to explain him anything hehe

    regards
    Hrishy

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    probably the manager will end up being a DBA too..!!
    Vinit

  5. #5
    Join Date
    Sep 2001
    Posts
    112
    tell him to imagine a ruler, this is a datafile.

    tell him between 1 and 5 cm's is a table, between 6 and 10 is another table.

    Add some rows to table 1. The table is now 1 to 5 cm's and 11 to 13 cm's.

    Add some rows to table 2.

    Table 1 has a chunk at the start of the ruler and near the end.

    Table 2 is also in 2 chunks.

    Over time a table can be twenty little chunks of info or in pieces(fragments). This is called fragmentation.

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    The manager would not ask that question at all.

  7. #7
    Join Date
    Sep 2000
    Posts
    384
    Tamil Your answer is Cool
    Radhakrishnan.M

Posting Permissions

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



Click Here to Expand Forum to Full Width