Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Examining the space allocation within individual Extents
Okay, good point.
Thanks for your response.
The Answers to your questions are as follows:
This is a new table and is contained within a new tablespace (the parameters are defined in 3. above).
How can wanting to know the used vs free space allocation within an extent be meaningless if any free space in that extent is not going to be used? I'm trying to figure out whether or not I should go for a smaller NEXT EXTENT size than 28MB, and I would like to do this via an informed decision making process?
Once a partition in this range-partitioned table has been populated for a given month, then that is it storage wise. It isn't going to grow, and it certainly isn't going to be updated (Hence the PCTFREE = 5% in the table definition; I don't need to reserve free space for updates to reduce the risk of row chaining).
Please can you define what you mean by "Properly Configured", as that phrase covers an awful lot of subject matter, and in itself could be subjective?
Thanks.
James Received on Mon Dec 12 2005 - 18:02:18 CST