Hi Gurus, I found an article in metalink 105765.1 "How to Determine Approximate Hard Drive Space Needed for a Specific Table". The formula for disk space is simply multiplying the average row length (by analyzing the table) * the number of rows in the table. It's very different from Metalink 10640.1 "Extent and Block Space Calculation and Usage in V7 Database" where it takes the block header etc in considerations but of course, article 10640.1 is for Version 7.
How do you gurus calculate table space in Version 8 ? Please advise. Thanks. Regds, New Bee Doc ID </help/usaeng/Search/search.html> : Note:105765.1 Content Type: TEXT/PLAIN Specific Table Creation Date: 18-APR-2000 Type: PROBLEM Last Revision Date: 26-DEC-2000 Status: PUBLISHED Problem Description ------------------- How can you determine how much disk space is needed for a table? Solution Description -------------------- You can use SQL to determine how much space is needed for the table based upon the average row length. 1. compute statistics about this table: analyze CEUSER.CE_STATEMENT_LINES compute statistics; Now determine the average row length in bytes: select avg_row_len from dba_tables where table_name=' CE_STATEMENT_LINES'; AVG_ROW_LEN =============== 98 2. Multiple the average row length in bytes by the number of rows you believe you will need: 98 (bytes) x 10000 records = 980000 bytes needed References ---------- For more information on the ANALYSE command, you may wish to refer to: Oracle8 SQL Reference Release 8.0, Part No.A58225-01 Also: Oracle8i SQL Reference Release 8.1.5, Part Number: A67779-01 . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
