RE: storage parameters
- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Mar 2004 15:10:41 +0000
Actually with LMTs the whole calculation is probably a waste of time and
effort. I didn't get beyond 300 small rows = stick it in a small extent size
tablespace. Specifying INITIAL and NEXT is pretty well pointless under LMTs as
it merely determines how many extents you get not how large they are - the
tablespace storage parameters do that. I *might* change my decision if it were
300 small rows expected to grow to 10million larger rows in the first 6 months,
but from the column names this doesn't seem likely.
I didn't see any discussion about the frequency of update/delete or the pattern
of inserts so I can't really comment on the values chosen for PCTFREE/PCTUSED
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805
> -----Original Message-----
> From: jhostetter@xxxxxxxxxxxxxxxxxxxx
> Sent: 16 March 2004 13:17
> To: jhostetter@xxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Subject: Re: storage parameters
>
>
> This may or may not be flawed logic, but what I would do is this:
>
> 150 (sum of columns) * 300 (number of records) * 1.10 (allow
> 10% or so for
> overhead) = 49500 or 49.5k.
>
> I always use multiples of the database block size. I usually
> don't go below
> 128k. So I would use initial and next of 128k. Then load up
> the table in a
> test database to see if the table grew. You don't have to
> size the table
> perfectly. I just use this formula to get in the ballpark.
> I used to spend
> the time with those formulas they had in the Oracle 7
> manuals, but with
> uniform tablespaces, lots of disk space, and the debunking of
> the "extent"
> myth, I think it is just a waste of time.
>
> Jay
>
> >>> oracledbam@xxxxxxxxxxx 03/16/04 02:16AM >>>
> 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
> -----------------------------------------------------------------
>
>
>
>
> **DISCLAIMER
> This e-mail message and any files transmitted with it are
> intended for the use
> of the individual or entity to which they are addressed and
> may contain
> information that is privileged, proprietary and confidential.
> If you are not
> the intended recipient, you may not use, copy or disclose to
> anyone the
> message or any information contained in the message. If you
> have received this
> communication in error, please notify the sender and delete
> this e-mail
> message. The contents do not represent the opinion of D&E
> except to the extent
> that it relates to their official business.
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
>
**********************************************************************
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************
----------------------------------------------------------------
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:
