-
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 ?
-
Since its more of insert..i guess the value of
pctfree 10 and pctused 60 is more than enough..
regards
anandkl
-
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.
-
Just use SEGMENT SPACE MANAGEMENT AUTO if you use Oracle 9i or later.
