Best Pctfree/ Pctused value for 90% of the columns are updated with number data types

Quote:

---

Originally posted by pando
if you have updates why on earth you want to set pctfree to zero?!

---

The below linke differs a bit..?

http://www.arikaplan.com/oracle/ari013100.html

its his view, not necessary to be true

Forget what the article said. Based on your table definition/structure you need PCTFREE to be high. The reason PCTFREE needs to be high is because you have several variable length data types, on top of that, they differ in size. Your table definition/structure indicates that you took the time to think those data types out, meaning you know what you want, so, you want PCTFREE to be high.

If you want you table so that it does not matter, then you will have to restructure it accordinly, and I'm afraid that is something that you will have to ask the seasoned folk about.

Hope that helps.

Rick

The article is correct in that you can structure your records to such a data type that it will not matter what PCTUSED and PCTFREE are.

That article does not give credibility to your unique situation.

Again, PCTFREE should be high.

Rick

Quote:

---

Originally posted by engiri
The below linke differs a bit..?

http://www.arikaplan.com/oracle/ari013100.html

---

What it differs from is the truth -- storage requirement for numbers varies depending upon the number itself.

Where do these idiots come from that post such wrong advice? (meaning this "Ari Kaplan")