RE: Lost appendix: Space Estimations for Schema Objects
- From: Pete Sharman <peter.sharman@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 16 Jun 2004 03:42:17 +1000
Leslie
It was taken out because there are so many variations and permutations possible
that a generic formula is never going to be realistic. The only realistic way
to get space estimations is to load a "typical" set of data (whatever that is)
and then extrapolate to Production sizes, based on history and so on.
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Leslie Tierstein
Sent: Wednesday, 16 June 2004 3:02 AM
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
