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 -> CHAIN_CNT > 0. Why?

CHAIN_CNT > 0. Why?

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Fri, 30 May 2003 16:16:51 -0400
Message-ID: <P1PBa.8213$945.24580@tor-nn1.netcom.ca>


I have some tables for which CHAIN_CNT (after ANALYZE) is > 0;

OWNER TABLE_NAME AVG_ROW_LEN NUM_ROWS CHAIN_CNT NUM_COLS

--------------- -------------------- ----------- ---------- ---------- -----
---
FIN          BIN_LOCATIONS                191     101028        689       40
FIN          DESPATCH_HEADERS             514     215763       7800       58
FIN          GEM_FACILITIES               375       8439         34       13
FIN          GL_ACCOUNT_BALANCES          345      24358         21       55
FIN          SALES_CREDIT_NOTES           456      13031        102       84
FIN          SYS_PRODUCT_LANGUAGE          57      48343        141        6
IPS           IFA_CUST_PROFILE             266       1160         19
46

7 rows selected.

Why is it so?
- All character columns are fixed length so that can't change with an update

Are number columns like NUMBER(20,2) stored in such a way that the space occupied will vary with the value therein?

If not, what should I watch for, as a cause for these rows to be migrated/chained ?
Could not find much more in the docs so far.

Thanks

Pls don't flame about Oracle version - I'm migrating to 817 or 9.2 as soon as my software vendor allows.

--

OpenVMS 7.3-1, Oracle 8.1.6.0

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove zulu from my address
Received on Fri May 30 2003 - 15:16:51 CDT

Original text of this message

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