RE: Lost appendix: Space Estimations for Schema Objects
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 15 Jun 2004 23:52:52 +0200
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD
Other related posts:
