Doubts on Oracle space management
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Doubts on Oracle space management

  1. #1
    Join Date
    May 2006
    Posts
    1

    Doubts on Oracle space management

    Hi Gurus,

    I understood that the basic logical setup in oracle goes like this
    1.Tablespace -> Segment ->Extent -> Oracle Blocks -> o/s Blocks
    |
    Datafile (Physical structure)

    I have few doubts
    01.Does Oracle allocates the Oracle blocks in serial to the segments ?
    02.Is there any possiblility for the unused blocks in an extent in between ? i mean blocks not filled in serial ? If so what is the solution to reclaim that unused space?

    03.Whether truncate and delete (committed) both release the space used earlier by the rows?

    Thanks & regards,
    NSR

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Well,

    1. Oracle allocate block serially for an extent and many extents ( may not be serial or may be) a segment
    2. A delete may leave blocks unfilled. To space re-claim rebuild table
    3. Release freeaspace to tablespace => rebuild table

    Sounds you need to read Concepts, especially!

    http://download-west.oracle.com/docs...ical.htm#i8531
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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