pct free

[helpme]

Hi,
in my server stats it gives that pctfree for a table is low
Now how do i find out which table is that which haslow pctfree?
Thanx
Sam

[aarroyob]

Hi,

Check for the tables with more updates in your database.

Angel

[Sureshy]

How are you getting your server stats ?

Analyze your tables.
select chain_cnt, table_name, owner
from dba_tables
where chain_cnt > 0

If any of your tables have row chaining in them, increase pct_free for table.

search forums on how to resolve row chaining.

If I remember correctly, you will have to copy chained rows to another table.
delete chained rows from table
copy chained rows back to table with higher pct_free setting.

[helpme]

Hi,
I have this table that has 8 varchar2(4000) cols and 1 nmber col

this table has 6000 rows
And after the inserts i found that i has a lottt of chained rows
this table has just inserts and seldom updated so i kept the pctfree as 5 and pctused as 60
but still the when i analyze i find that it has chained rows.
How do i go about with this?

Thanx a lot
Sam

[vinit]

are most of your tables chained ? Increasing your db blocksize may help.

[helpme]

5 were...
increase in the pctfree of 4 worked..but for 1 it dint...
4454 cols out of 6000 rows are chained in this table

[reydp]

Originally posted by vinit
are most of your tables chained ? Increasing your db blocksize may help.

Just to remind:
Increasing your db blocksize means you have to recreate your db. :-))

[helpme]

so would me increasing the MINEXTENTS and MAXEXTENTS help?
BTW can I alter this?
thanx
Sam

[reydp]

It can't help since chaining/migration issues is in a block level.

[julian]

Just to remind:
Increasing your db blocksize means you have to recreate your db. :-))

Yes, below 9i.

For a 9i running instance, you can create a new tablespace with, say, 16K block size:

create tablespace tbs16K
datafile '/ora900/oradata/tbs16K.dbf' size 256M
blocksize 16k;