| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: storage clause
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).
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 - 15:45:31 CST
 |
 |