-
I can take that Q for Amar:
That means no matter how big/small table you create, Oracle creates in multiple of distinct extent sizes mentioned(64K,1M,8M,64M).
In practical terms:
If you create 512K table in LMT with AUTOALLOCATE it uses 64K
If you use 10M , it uses IM extent size and if you use 50M, it uses 8M size and so on.
In first case 8 extents, second case 10 extents, third case 7 extents as opposed to
6+partial extent for 2MB.
Reddy,Sam
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
|