Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!news.mixmin.net!aioe.org!news.stack.nl!feeds.news.ox.ac.uk!news.ox.ac.uk!feed2.jnfs.ja.net!feed4.jnfs.ja.net!jnfs.ja.net!feeder.news.heanet.ie!news.indigo.ie!not-for-mail
From: "Paul Linehan" <plinehan__A@T__yahoo__D.OT__COM>
Subject: Re: Using Flattened table COSTLIER than using JOINS with the SETUP tables.
Newsgroups: comp.databases.oracle.tools
References: <1186459844.733014.205920@x40g2000prg.googlegroups.com> <f81gb3ttfg56s6vqjvfo04q7a8b9q47duk@4ax.com> <1186492117.550290.257430@q3g2000prf.googlegroups.com> <p7khb3dn7r8icjlmlevniafpvsafcjp229@4ax.com>
User-Agent: XanaNews/1.18.1.6
Lines: 34
Message-ID: <7m5ui.21337$j7.383741@news.indigo.ie>
Date: Tue, 07 Aug 2007 21:20:03 GMT
NNTP-Posting-Host: 86.40.130.153
X-Complaints-To: abuse@eircom.net
X-Trace: news.indigo.ie 1186521603 86.40.130.153 (Tue, 07 Aug 2007 22:20:03 BST)
NNTP-Posting-Date: Tue, 07 Aug 2007 22:20:03 BST
Organization: Eircom.Net http://www.eircom.net
Xref: usenetserver.com comp.databases.oracle.tools:181350
X-Received-Date: Tue, 07 Aug 2007 17:20:05 EDT (text.usenetserver.com)




sybrandb@hccnet.nl wrote:



> The table will not be in a single block. records should be in a
> single block.
> You would need to use 
> analyze table .... compute statistics or better
> exec
> dbms_stats.gather_table_stats(user,'<table_name>',estimate_percent=>NU
> LL)
 

> doing so you will can query 
> select avg_row_len,chain_cnt, num_rows,
>  from user_tables where table_name = '<table_name>'


Why? Can't you simply get the db_block_size parameter 
SQL> SHOW PARAMETER BLOCK and then check against avg_row_len?


My point here is, why gather the stats (which could be useful
for other reasons) to find out if the record size exceeds the
size of a db block?



Paul...