I have a table with structure
A NUMBER Primary Key
B VARCHAR2(30)
C NUMBER
D LONG
The storage parameters are default, with pctfree & pctused as 10 & 40
I have 42% of rows as chained rows.. Also I have a Primary Key and another index based on column C
IF I have to change the storage parameters, how much should I make the values for pctfree and pctused.. ?
And what is the procedure for solving this permannetly, in Oracle 8i
Thanks,
VG