Add an Update Reserve Percentage for each Column to set PCTFREE

[GoogleCodeExporter]

What will the enhancement do?

 -) Add an Update Reserve Percentage for each Column to set PCTFREE

How is this currently done or handled?

 -) Generated DDL must be manually modified based on manual calculations

What version of the product are you using? On what operating system?

 -) Pre-Release 0.11

Please provide any additional information below.

 -) LOG and EFF Tables need a much lower PCTFREE

Original issue reported on code.google.com by Duane.Di...@gmail.com on 23 Jul 2012 at 4:05

[GoogleCodeExporter]

Each column gets a percentage to reserve.  0% means the column will always be 
populated with a value that never changes size.  100% means the column will be 
inserted with a null, then updated with a full-size value.

Default values:
 -) Surrogate keys get 0% reserve
 -) LOG and EFF tables should reserve 0%??? because no updates are allowed on these rows

Original comment by Duane.Di...@gmail.com on 23 Jul 2012 at 4:16

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

The default value for required columns is 5.  The default value for 
non-required columns is 10.  Note: space must also be reserved for values that 
are updated with a larger size value after the initial insert.

Original comment by Duane.Di...@gmail.com on 26 Jul 2012 at 1:38

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

For improved calculations, "init_avg_len" is needed in tab_cols to capture the 
average length of column data in an inserted record.

Original comment by Duane.Di...@gmail.com on 1 Aug 2012 at 1:45

[GoogleCodeExporter]

Original comment by Duane.Di...@gmail.com on 1 Aug 2012 at 8:09

• Changed state: Fixed