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

Thread: fragmenting question

  1. #1
    Join Date
    Feb 2001
    Location
    Master Control
    Posts
    86

    fragmenting question

    i have a table with about 5K rows and one of the attribute is BLOB. i want to add another BLOB attribute...if i just alter the table and add a new one will this cause any fragmentation? if not now, will it over time?

    thanks!!

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Framgmentation now with the latest version of oracle is like Myth which came from Oracle 7.0. Even if there is fragmentation it will not cause any problems for your application/database performance. Do not worry much about it.
    Reddy,Sam

  3. #3
    Join Date
    Feb 2001
    Location
    Master Control
    Posts
    86
    cool...so would 8i be okay as well?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    define the fragmentation you are worrying about?

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Fragmentation??? What the heck is fragmentation?? In Oracle database?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Feb 2001
    Location
    Master Control
    Posts
    86
    the fragmentation i am refering to is with regards to object and or tablespace fragmentation. i don't know if these are effected by what i am asking...hence my post. but for a definition...this is what i am refering to. yes oracle db.

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by jmodic
    Fragmentation??? What the heck is fragmentation?? In Oracle database?
    Ya i agree with u in respect to TS, Segment level ( i.e what the heck is fragmentation )...

    it can occur at block level, then i will have to say ya i now understand wass fragmentation...but i am not sure how oracle will handle such kinda frag..? (i mean how it will coalece such spaces in the block) -- can any one brief up how its handled?

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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