-
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|