Re: How can I get the number of free blocks?
From: Mark Johnson <mwc.mjohnson_at_capital.ge.com>
Date: 1996/08/30
Message-ID: <3227499F.145B_at_capital.ge.com>#1/1
Date: 1996/08/30
Message-ID: <3227499F.145B_at_capital.ge.com>#1/1
> The view ALL_TABLES is usable only after analyzing the tables,
> which takes for the big ones 7 to 8 hours a table.
> Is there another way to get this information?Just use analyze table <tablename> estimate statistics sample # rows.
Just fill in the number of rows you want to sample but the more you sample the better the estimate.
Look at the avg_space, and avg_row_len fields in ALL_TABLES to see if you PCTUSED is right. Received on Fri Aug 30 1996 - 00:00:00 CEST