Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle Chaining

Oracle Chaining

From: <aprinsloo_at_sagetelecom.net>
Date: 12 Dec 2006 13:35:25 -0800
Message-ID: <1165959325.251501.186110@80g2000cwy.googlegroups.com> 





Oracle 9i standard.



Ive noticed by looking at DBA_TABLES that some tables have excessive
CHAIN_CNT, the highest been 3266085 on a 45 million row table.
I've set the pct_free to 35 up from 10 but the CHAIN_CNT continues to
climb, is there anything else I can try ?



Thx in advance
Received on Tue Dec 12 2006 - 15:35:25 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US