Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Block Sizing
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.
![]() |
![]() |