DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Storage Parameters

  1. #1
    Join Date
    Feb 2001
    Posts
    23
    I have a table with following definition

    COL1 NOT NULL NUMBER
    COL2 VARCHAR2(30)
    COL3 NOT NULL NUMBER(5)
    COL4 LONG

    Could anyone please suggest a good value for storage parametrs PCT FREE & PCTUSED as this table only has insertions, and the number of insertions is very high as 75000 records

    Does long column has any special implications ?

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Since its more of insert..i guess the value of
    pctfree 10 and pctused 60 is more than enough..

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Apr 2002
    Posts
    9
    If you are sure that this table never get updated or deleted, you can set zero for pct free.
    pct used is not relevant if there is no delete.

  4. #4
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Just use SEGMENT SPACE MANAGEMENT AUTO if you use Oracle 9i or later.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

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