Space questions again
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Sun, 3 Apr 94 16:29:00 -0500
Message-ID: <12a.427.905.0N3E0AD3_at_compudata.com>
Date: Sun, 3 Apr 94 16:29:00 -0500
Message-ID: <12a.427.905.0N3E0AD3_at_compudata.com>
-> - How can I verify the used space in TBSP1 using a query? I've used
-> "select sum(bytes)" but the number I get is way off (8388608).
Huh. Bytes? I think you want sum(vsize(field_name)) to give Oracle's actual space usage.
Note in Oracle6, all char fields were variable. V7 has changed that.
Also, vsize won't work on longs. For that you actually have to pull them and count them your self. Received on Sun Apr 03 1994 - 23:29:00 CEST