Re: storage parameters
- From: "Ron Rogers" <RROGERS@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Mar 2004 13:17:38 -0500
Seema,
have you obtained the Oracle manuals yet? Have you downloaded the
information for the oracle site yet?
a lot of the general questions you have been asking since
"Seema Singh" <oracledbam@xxxxxxxxxxx>@fatcity.com on 03/28/2001
12:25:55
could be learned and remembered from the exercise gained from
practicing what is in the manuals.
Ron
>>> Jared.Still@xxxxxxxxxxx 03/16/2004 12:03:01 PM >>>
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@xxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
03/15/2004 11:16 PM
Please respond to oracle-l
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
