RE: Lost appendix: Space Estimations for Schema Objects

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Tue, 15 Jun 2004 23:52:52 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNKEHHCEAA.lex.de.haan@naturaljoin.nl>

this functionality is back in 10g, in EM Database control. when you create a table, define the columns, and enter an estimated cardinality,
there is a button you can push to get an estimated segment size.

Kind regards,
Lex.

visit my website at http://www.naturaljoin.nl

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Leslie Tierstein Sent: Tuesday, June 15, 2004 18:02
To: oracle-l
Subject: Lost appendix: Space Estimations for Schema Objects

The Oracle 8.0 documentation had an Appendix A to the "Oracle Server Administrator's Guide" on "Space Estimations for Schema Objects". It gave formulas for approximating the amount of disk space that would be taken up by tables and indexes, taking into account block size, init trans, pct free, etc. The appendix seems to have vanished in the 9i documentation -- at least I can't find it.

Does anyone know if/where this information still exists, either in the Oracle documentation set or some other documentation?

Thanks,
Leslie

Leslie Tierstein
Senior Consultant
Vision Chain, Inc.
The first software to power the demand data network phone: 202-261-3549

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Tue Jun 15 2004 - 16:50:00 CDT