Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.com!prodigy.net!newsmst01a.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr31.news.prodigy.com.POSTED!bf1b164b!not-for-mail
From: "Randy Harris" <randy@SpamFree.com>
Newsgroups: comp.databases.oracle.misc
Subject: Storage parameters
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Message-ID: <0ztee.1068$t31.778@newssvr31.news.prodigy.com>
NNTP-Posting-Host: 69.209.152.201
X-Complaints-To: abuse@prodigy.net
X-Trace: newssvr31.news.prodigy.com 1115317564 ST000 69.209.152.201 (Thu, 05 May 2005 14:26:04 EDT)
NNTP-Posting-Date: Thu, 05 May 2005 14:26:04 EDT
Organization: SBC http://yahoo.sbc.com
X-UserInfo1: TSU[@IONGJVOBTLZFJK@N_PAFJTD@C\MPXVN^GEMLXMTWA]EP]RAQFW[ML\THRCKV^GGZKJMGV^^_JSCFFUA_QXFGVSCYRPILH]TRVKC^LSN@DX_HCAFX__@J\DAJBVMY\ZWZCZLPA^MVH_P@\\EOMW\YSXHG__IJQY_@M[A[[AXQ_XDSTAR]\PG]NVAQUVM
Date: Thu, 05 May 2005 18:26:04 GMT
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:118883

I have responsibility for a database which I've inherited.  I've discovered
some peculiar settings for some storage parameters.  (An application
recently crashed because a very small table had the next_extent set to
1024MB, in a 500MB tablespace)

The database is 8.1.7.4, not very large and has dictionary managed
tablespaces.  In a few months I will be upgrading it to 9.2.0.x and setting
locally managed tablespaces.  In the meantime, I plan to recreate a number
of tables with new storage clause parameters.  "Expert One-On-One Oracle"
recommends making all of the objects the same within a tablespace,
initial_extent and next_extent the same and 0 pctincrease.

I'm looking for guidance for setting the sizes, considering that these will
be migrated to the new database in a few months.  Is that even a factor?
Should I simply pick an initial_extent that will cause 80% of the tables to
fit in 1 extent?  Does it matter if some of the tables will require 20 t0 30
extents?  Is there some sort of rule of thumb?