Re: error in the output

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 28 Apr 2006 09:38:42 -0700
Message-ID: <1146242322.499821.22530@e56g2000cwe.googlegroups.com>

BS wrote:
> Hi,
>
> I'm new to the oracle world and trying to find out the size of my
> oracle database. I ran the query as below and not getting the correct
> result back. Any pointer please??
>
> SVRMGR> select sum(BYTES) from DBA_DATA_FILES;
> SUM(BYTES)
> ----------
> 4.2001E+10
> 1 row selected.

It rather depends on what you mean by the size of your database. For example you might also want to look at DBA_TEMP_FILES, or perhaps that doesn't count. Received on Fri Apr 28 2006 - 11:38:42 CDT