Space questions again
Date: Fri, 1 Apr 1994 14:21:06 GMT
Message-ID: <CnL3v9.D8r_at_cbnewsj.cb.att.com>
I posted this and have not received replies so I'll try again.
I inherited the DBA responsiblity in my group so I'm learning as I go. What
we have are tables of fixed sizes (no variable chars). The tablespaces are
stored on raw partitions. Here are a few questions:
A table named LINE resides in tablespace TBSP1. The table size is 366
bytes. The table LINE has 9598 rows. When I multiply the number of LINE entries
(9598) by the LINE size (366 bytes) I get 3512868 which should indicate how
much space is USED in TBSP1. The questions are:
Thanks in advanced. Please respond here or via email if you can help.
-- Felix Cabral {felixc_at_hogpa.att.com} "Give me nukin winds, AT&T Bell Labs { att!hogpa!felixc } a rad board, rad waves, Holmdel,NJ { (908)949-1188 } and a company sickday!"Received on Fri Apr 01 1994 - 16:21:06 CEST