Re: tablespace usage query, ts$, v$filespace_usage

ntalbs wrote:

> I found several SQL scripts which show tablespace usage.
> The scripts usually query dba_free_space to get free space of
> tablespaces,
> which is very slow.
>
> I was trying to improve the query or find better way to get tablespace
> usage, and found
> v$filespace_usage view. So I wrote this query which uses
> v$filespace_usage and ts$.

Would you consider using the Oracle Enterprise Manager to view Storage -> Tablespaces cheating?

//Walt Received on Mon Feb 13 2006 - 08:33:35 CST