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

Home -> Community -> Usenet -> c.d.o.server -> Re: Calculate table, index (storage parameters)

Re: Calculate table, index (storage parameters)

From: Alexey M. Reshetov <real_at_kpbank.ru>
Date: 26 Aug 1998 03:48:56 GMT
Message-ID: <6s00j8$jh3$2@home.kpbank.ru>


LEVINIR (levinir_at_aol.com) wrote:
: I need a help in setting storage parameters (iniital extent, next extent,
: pctincrease, etc) when I create tables and specially indexes for the
: application. May be someone already have a formula that you use for this
: purpose. I tried to use Oracle Server Administrator Guide (Appendix), somehow
: complicated.

: Thanks in advance.
: Irina.

There is doesn't exists any universal formula. It depends from application DML statements and growth of tables and rows. The Appendix contents only estimate calculations. Would you please to describe your task with a speeds of changes in your table/index.



Alexey Reshetov
real_at_kpbank.ru Received on Tue Aug 25 1998 - 22:48:56 CDT

Original text of this message

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