Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Block Sizing

Block Sizing

From: sonia pajerowski <spajerowski_at_yahoo.com>
Date: Wed, 28 Jun 2000 06:39:39 -0700 (PDT)
Message-Id: <10542.110651@fatcity.com>


I am designing a database for a telecom. One of the tables will have 20 million records and they expect 300-350 transactions/second.
How will this affect my sizing of the block for table (PCTFREE/INITTRANS..MAXTRANS etc..)?
Every transaction has one insert and two updates. Update will update a number field from 0 to 1 and a varchar2 field from null to <= 255 characters long.

Thanks
Sonia P.



Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ Received on Wed Jun 28 2000 - 08:39:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US