CREATE TABLE/INDEX parameters

From: Stephane Hamel <shamel_at_mais.hydro.qc.ca>
Date: 28 May 92 20:38:05 GMT
Message-ID: <shamel.707085485_at_tdsb-s>


  We have created many tables (about 200). Each table and index have been created with default parameters (INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, PCTINCREASE).   I know there is a formula that can be applied, according to the record size, the number of record etc... and evaluate the values of those parameters.

  I looked into the DBA guide and the performance tuning guide and I didn't found such formula. I remembre seeing it in a previous version of Oracle for VAX/VMS.   Does any one have a clue on that?

--
 --------------
 Stephane Hamel              | AutoControle Inc.
 SHamel_at_Mais.Hydro.Qc.Ca     | Montreal, Quebec, Canada
                             | Phone: 1 514 858 7882
Received on Thu May 28 1992 - 22:38:05 CEST

Original text of this message