Best Pctfree/ Pctused value for 90% of the columns are updated with number data types
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

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

  1. #1
    Join Date
    Apr 2003
    Posts
    353

    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

  2. #2
    Join Date
    Apr 2003
    Posts
    353
    ANy Advices..?

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    No, PCTFREE=0 is certanly not a good choice for this situation.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Apr 2003
    Posts
    353
    Can u please explain with reasons..

    Thx

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you have updates why on earth you want to set pctfree to zero?!

  6. #6
    Join Date
    Apr 2003
    Posts
    353
    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

  7. #7
    Join Date
    Aug 2002
    Posts
    115
    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%

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    No, Oracle will not preoccupy space for any datatype column if the column is initialy null (not even for CHAR columns).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Apr 2003
    Posts
    353
    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

  10. #10
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width