Re: how do you know when to add space to tablesapce?

Robert Yeh wrote:

> So you guys do not consider how much space within an allocated segment has
> been used either.
> Like what I said earlier, you might have a large extent with no records in
> it. How do you count for that?

By running analyze and then

SELECT avg_row_len * num_rows / 1000000
FROM dba_tables

and comparing that to the allocated blocks. It isn't exact but it close enough for its purposes.

Daniel A. Morgan Received on Fri Jun 22 2001 - 11:22:57 CDT