Re: Examining the space allocation within individual Extents

Okay, good point.

Thanks for your response.

The Answers to your questions are as follows:

1. Oracle 8i (Version 8.1.7)
2. Dictionary Managed.
3. Which parameters would you like? I've configured it to autoextend by
112MB up to a maximum file size of 3.072GB. PCTUSED = 50% PCTFREE=5%
INITIAL EXTENT=112MB NEXT EXTENT=112MB
4. Table attributes: Range Partitioned on month (12 partitions).
INITIAL EXTENT=112MB (per partition) NEXT EXTENT 28MB.

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

.

Relevant Pages

  • Re: factory restore
    ... I was talking about the average users and their PCs: Dell, Gateway machines with preinstalled OEMs plus custom built machines in the low high-end class; most laptops come with an OEM OS also. ... Partitioning consumes space that could be otherwise used for user storage (carefully think about the HD structure required to track files and free space as well as the amount of free space that must be reservd to allow for growth and that can not be aggregated). ... Personally I have 10 monted partitions across two stand alone drives and one RAID array and I get confused where I stuff things. ...
    (microsoft.public.windowsxp.newusers)
  • Re: SBS 2003 R2 need to increase C & D drives
    ... With 120 Gb free space, you have the option of creating a partition and relocating some data. ... The WHS has lasting value, ... you can cold image the existing box and restore to larger partitions. ...
    (microsoft.public.windows.server.sbs)
  • Re: Newbie question on partitioning (primary/logical drive ?)
    ... >>and the second and third drives will stand on their own. ... > partitions, because I'm not used to working with multiple drives, and so ... > create swap first, and put it at the end of free space on a blank drive, ... > putting the milk in the front of the dairy case at the convenience ...
    (Debian-User)
  • Re: [opensuse] libata partition limit
    ... GB of free space and two partitions to put 11.0 on. ... It really ticked me off when all of my drives were renumbered. ... functionally equivalent option, while Fedora beginning at v7 has provided no ...
    (SuSE)
  • Re: Trying to Load Ubuntu 11.04 onto HP Laptop. Failed at reboot
    ... Okay, boot up 11.04 livecd and at terminal, do the following... ... create your partitions ...
    (Ubuntu)