How much space do my data occupy?
Date: 20 Feb 1995 22:13:00 +0200
Message-ID: <5gD5ou-1xEB_at_becker.ping.de>
Hi,
how can I determine how much space my data occupy?
From COLS I can compute how many bytes at maximum I need to represent one row of a given table T:
select sum(data_length) from cols where table_name = "T"; (LEN)
(Our Oracle says it needs 22 bytes to represent an integer value. I can't imagine this is true.)
I could multiply this by the total amount of rows in my table (AM), giving LEN*AM. Furthermore I can determine how many extents are realy needed for my table and how many bytes they occupy:
select sum(bytes) from dba_extents where segment_name = "T";
By selecting from DBA_FREE_SPACE I can compute how many bytes are free in my tablespaces.
But I haven't found a way to tell how many bytes are free, resp. occupied, in my extents.
Udo Becker
-- __ | | |__) Dipl.-Inf. Udo Becker phone: ++49-2335-62562 (priv.) |__| |__) Haus Hove 17 ++49-2335-92-7974 (off.) D-58300 Wetter fax: ++49-2335-92-7811 (off.) ## CrossPoint v3.0 ##Received on Mon Feb 20 1995 - 21:13:00 CET