Hi Ravindra,
Use the following, supposing your db_block_size is 2048 (change as appropiate).
SELECT segment_type, segment_name,BLOCKS*2048/1024 Kb
FROM DBA_SEGMENTS
WHERE OWNER=UPPER('owner') AND SEGMENT_NAME = UPPER('table_name');
You should
not consider
myself an expert, maybe someone else can join and comment something.
-Mensaje original-
De: Basavaraja, Ravindra [mailto:[EMAIL PROTECTED]
Enviado el: martes, 01 de abril de 2003 20:41
CC: '[EMAIL PROTECTED]'
Asunto: RE: how to calculate table size
Hi Fermin,
Thanks
CHAN Chor Ling Catherine (CSC) wrote:
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
Silvey" [EMAIL PROTECTED]
To: "Multiple recipients of list ORACLE-L"
[EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 11:03 PM
Subject: Re: How to calculate table size in
8i
New, No guru here, but that is the way that I do it
- average row size vs estimated number of rows *
New,
No guru here, but that is the way that I do it -
average row size vs estimated number of rows * fudge
factor of 30% plus a little room for underestimation.
Also, don't forget room for indexes.
I have found this method to be quite successful, since
the major hurdle is figuring out how many