Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ExcTabChain & Performance
Hi
I'm trying to improve performance on one of my databases.
I have discovered that one of my tables have a 86,7 ExcTabChain.
Does anybody know why it's chained, and what this will do to
performance on my base ??
What can I do to remove these chains ??
The parameters on the DB/table is as follows :
DB_BLOCK_SIZE = 8192 Num_rows 1007 Row size 27 Bytes Table Storage Parms: STORAGE ( INITIAL 524288 NEXT 1048576 PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 505 ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255;
// Martin Received on Tue Jun 22 1999 - 03:12:47 CDT