Xref: alice comp.databases.oracle.misc:36830 comp.databases.oracle.server:58929 comp.databases.oracle.tools:28980 Path: alice!news-feed.fnsi.net!newsfeed1.earthlink.net!hermes.visi.com!news-out.visi.com!newsfeed.wirehub.nl!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools Subject: Re: Problem: database table/index sizing for Sum Length Columns greater than Available Data Space Date: Mon, 26 Jul 1999 20:17:52 +0200 Message-ID: <933013059.12599.0.pluto.d4ee154e@news.demon.nl> References: <379c4cd5@news1.us.ibm.net> Reply-To: "Sybrand Bakker" X-Trace: news.demon.nl 933013059 pluto:12599 NO-IDENT sybrandb.demon.nl:212.238.21.78 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Lines: 30 Sorry, but this is just the way Oracle works. If your records are by design bigger than the available dataspace, you will get chaining. If this is a structural problem in your database the only way to resolve it is to increase the block size. There might be formulas, but you definitely don't want the chaining, as you will be getting more than one 1 I/O to retrieve a record. Hth, Sybrand Bakker, Oracle DBA Brendan Newman wrote in message news:379c4cd5@news1.us.ibm.net... > Hi there, > > I am trying to size Oracle 8.x tables and am having difficulty due to > the fact that the formulas Oracle gives are only appropriate if your Space > Used Per Row (i.e. Sum Length Columns + Overhead) is less than your > Available Data Space (i.e. Block_Size - Header Space - Pct_Free_Space). > > What if Space Used Per Row >= Available Data Space? That is, what if > you have big columns which are much bigger than your block size and you > don't want to increase the block size? > > If you could point me to where there are formulas for this particular > case please let me know. Thanks. My e-mail is bis@ibm.net. > >