conntiguous, logical or physical
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: conntiguous, logical or physical

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    conntiguous, logical or physical

    from "http://www.dbasupport.com/forums/showthread.php?s=&threadid=35360&perpage=10&highlight=coalesce&pagenumber=1"

    They might be logically contiguous within Oracle, but physicaly (on disk) they are almost certain not to be. That's one of the reasons why the benefits of small number of extents in nonsense

    hi, just want to clarify the above. When oracle wants a new extent, all it needs is a free contiguous logical extent and doesnt matter whether this is contiguous on the physical side of things ?

    thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    as long as the space is logically contiguos it's fine for Oracle

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