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

Hi

I have a table with below structure.

LOCN_CODE NOT NULL VARCHAR2(3)
ITEM_CODE NOT NULL VARCHAR2(13)
ITEM_TYPE NOT NULL VARCHAR2(1)
SUPL_CODE NOT NULL VARCHAR2(4)
ITEM_LRCVD_DATE DATE
ITEM_FRCVD_DATE DATE
ITEM_SOLD_DATE DATE
FC_RATE NUMBER(12,3)
WAC NUMBER(10,3)
ORGN_PRICE NUMBER(10,3)
RETL_PRICE NUMBER(10,3)
ST_CODE NOT NULL NUMBER(4)
OPN NUMBER(6)
GRN NUMBER(6)
SAL NUMBER(6)
TRAN NUMBER(6)
PRN NUMBER(6)
SAD NUMBER(6)
DMG NUMBER(6)
WH_QTY NUMBER(6)
SR_QTY NUMBER(6)

The NOT NULL columns will be inserted first and all other columns
will be null. We update the other columns on everyday basis whenver transaction occur.

What will be the best suiting values of Pctfree and Pctused
parameters for the above table.

Can I keep pctfree as 0 since the columns to be updated are
number and date types?

IF the above is sure, I can use pctused 95 for the same.

Thanks
Giri

ANy Advices..?

No, PCTFREE=0 is certanly not a good choice for this situation.

Can u please explain with reasons..

Thx

if you have updates why on earth you want to set pctfree to zero?!

Please go through my question.. which
goes like ..
if the data type is number whether or not it is null or having some
values
should oracle preoccupy the space in the block..?

Thanks

nopes..i think not..except for char columns

if you know your table is going to be updated later, I think you should keep your pctfree something greater than 0%

No, Oracle will not preoccupy space for any datatype column if the column is initialy null (not even for CHAR columns).

Quote:

---

Originally posted by jmodic
No, Oracle will not preoccupy space for any datatype column if the column is initialy null (not even for CHAR columns).

---

Then what is the difference between varchar2 and char datatype
?
THx

VARCHAR2 is variable length character datatype while CHAR is fixed length datatype.

If you have column defined as VARCHAR2(10) and you want to store value 'Hi' in there, Oracle will store only those two characters in that column. If on the other hand the column is of type CHAR10), then everything you store in there is right blank-padded to the length of 10. So the value 'Hi' will actualy be stored as those two characters plus 8 blank characters.

http://download-west.oracle.com/docs...datyp.htm#7223

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")