RE: How to find the table size?

From: Guy Hammond <guy.hammond_at_avt.co.uk>
Date: Wed, 20 Jun 2001 06:58:39 -0700
Message-ID: <F001.0032FE4A.20010620050531@fatcity.com>

I think what he wants to do is find out how big a row could possibly be, for example

CREATE TABLE mytable (

        column1 VARCHAR2(40),
        column2 VARCHAR2(30),
        column3 VARCHAR2 (20));

select table_name, sum(data_length) from user_tab_columns group by table_name;

TABLE_NAME                     SUM(DATA_LENGTH)
------------------------------ ----------------
MYTABLE                                      90

It could be that the avg_row_len is less than this, but he's planning enough storage all variable length data types to be filled.

Cheers,

-----Original Message-----
Sent: Tuesday, June 19, 2001 8:51 PM
To: Multiple recipients of list ORACLE-L

> I need to calculate the size of the table assuming one of the rows is
having
> all the columns maxsize possible.

I don't understand your question. Do you want to plan in advance to make an
estimate of how large a table will be, or are you looking at an existing database and wanting to find out how large the tables are right now?

Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: guy.hammond_at_avt.co.uk

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: ListGuru_at_fatcity.com (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). Received on Wed Jun 20 2001 - 08:58:39 CDT