RE: storage parameters

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 16 Mar 2004 15:10:41 +0000
Message-Id: <s0571902.036@bristol21.bristol.ac>

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_at_decommunications.com
> Sent: 16 March 2004 13:17
> To: jhostetter_at_decommunications.com; oracle-l_at_freelists.org
> 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_at_hotmail.com 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_at_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
> -----------------------------------------------------------------
>
>
>
>
> **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_at_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
> -----------------------------------------------------------------
>
>

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_at_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
-----------------------------------------------------------------

Received on Tue Mar 16 2004 - 09:12:11 CST