RE: storage clause

From: <netmadcap_at_netzero.com>
Date: Thu, 20 Feb 2003 15:43:51 -0800
Message-ID: <F001.00553B1B.20030220154351@fatcity.com>

Dennis,

sorry for being not clear. in fact, i dont even know the proper approach to take if i have to resize the table. ok, so 1st input required is how many rows will the table have ? 2nd is the growth pattern ?

now is there a certain approach to it ? say like, if the table is having 100,000 rows and then depending on the growth pattern, the table can be sized using a certain set of rules ?

to be brief, what r the rules/steps that u all follow during defining a table ? what points r considered & how do those play in sizing the table ?

sorry if i m asking very basic :(

Thanks !

ps : in the meanwhile, i m reading abt LMT !!!

-----Original Message-----

WILLIAMS
Sent: Thursday, February 20, 2003 3:46 PM To: Multiple recipients of list ORACLE-L

Mad Cap

   First of all, you didn't say how many rows you were storing in it. Second, what is the growth pattern - static, steady growth, fill and empty?

   Study up on Locally Managed Tablespaces with Uniform Extents (LMT). Then pretty much the only decision is whether to use 128k, 4m, or 128m extent size.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

Sent: Thursday, February 20, 2003 3:19 PM To: Multiple recipients of list ORACLE-L

Hi Gurus ...

can somebody help in sizing the table/index using the storage clause ? what r the key values to check and how to calculate the table size & the related storage parameters ? how does it change from an OLTP appln to a Datawarehouse ?

lets say for the table "emp" :
Name Null? Type
------------ -------- ------------

EMPNO        NOT NULL NUMBER(4)
ENAME                 VARCHAR2(10)
JOB                   VARCHAR2(9)
MGR                   NUMBER(4)
HIREDATE              DATE
SAL                   NUMBER(7,2)
COMM                  NUMBER(7,2)
DEPTNO                NUMBER(2)

TIA !
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <netmadcap_at_netzero.com
  INET: netmadcap_at_netzero.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <netmadcap_at_netzero.com
  INET: netmadcap_at_netzero.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Feb 20 2003 - 17:43:51 CST