From oracle-l-bounce@freelists.org Tue Mar 16 10:59:55 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2GGxtV31493 for ; Tue, 16 Mar 2004 10:59:55 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2GGxso31486 for ; Tue, 16 Mar 2004 10:59:54 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 781A339115D; Tue, 16 Mar 2004 11:58:36 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 16 Mar 2004 11:57:30 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mx10.radisys.com (mx10.radisys.com [206.102.10.36]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A6DE0390ECD for ; Tue, 16 Mar 2004 11:57:17 -0500 (EST) Received: by mx10.radisys.com (Postfix, from userid 5) id 907BA142DFB; Tue, 16 Mar 2004 09:03:10 -0800 (PST) Received: from UNKNOWN(206.103.52.194), claiming to be "dcblackberry.radisys.com" via SMTP by mx10, id smtpdAAA0Q34u4; Tue Mar 16 09:03:02 2004 To: oracle-l@freelists.org Subject: Re: storage parameters MIME-Version: 1.0 X-Mailer: Lotus Notes Release 5.0.10 March 22, 2002 From: Jared.Still@radisys.com Message-ID: Date: Tue, 16 Mar 2004 09:03:01 -0800 X-MIMETrack: Serialize by Router on DCBlackBerry/Radisys_Corporation/US(Release 5.0.12 |February 13, 2003) at 03/16/2004 08:59:37 AM, Serialize complete at 03/16/2004 08:59:37 AM Content-Type: multipart/alternative; boundary="=_alternative 005D4FA488256E59_=" X-archive-position: 918 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Jared.Still@radisys.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l --=_alternative 005D4FA488256E59_= Content-Type: text/plain; charset="us-ascii" This partly depends on the nature of the application that will be using the data. Will it be heavily updated? Or is it read-only or read-mostly? Jared "Seema Singh" Sent by: oracle-l-bounce@freelists.org 03/15/2004 11:16 PM Please respond to oracle-l To: oracle-l@freelists.org cc: Subject: storage parameters what would be value of storage parameters of following tables? create table search_types ( modifier_type_key varchar2(50) not null PK , modifier_pretty_type varchar2(100) not null ); assumption: total#of rows=300 , pctfree=5 ,inittrans=1 ,pctincrease=0,pctused=40 what would be good value of INITIAL and next ? thx-seema _________________________________________________________________ Fast. Reliable. Get MSN 9 Dial-up - 3 months for the price of 1! (Limited-time Offer) http://click.atdmt.com/AVE/go/onm00200361ave/direct/01/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --=_alternative 005D4FA488256E59_= Content-Type: text/html; charset="us-ascii"
This partly depends on the nature of the application that will be using the data.

Will it be heavily updated?  Or is it read-only or read-mostly?


Jared



"Seema Singh" <oracledbam@hotmail.com>
Sent by: oracle-l-bounce@freelists.org

 03/15/2004 11:16 PM
 Please respond to oracle-l

       
        To:        oracle-l@freelists.org
        cc:        
        Subject:        storage parameters



what would be value of storage parameters of following tables?
create  table search_types (
       modifier_type_key   varchar2(50)  not null    PK ,
       modifier_pretty_type varchar2(100)  not null
);

assumption: total#of rows=300 , pctfree=5 ,inittrans=1
,pctincrease=0,pctused=40
what would be good value of INITIAL and next ?
thx-seema

_________________________________________________________________
Fast. Reliable. Get MSN 9 Dial-up - 3 months for the price of 1!
(Limited-time Offer) http://click.atdmt.com/AVE/go/onm00200361ave/direct/01/

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


--=_alternative 005D4FA488256E59_=-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------