error in the output

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BS - 28 Apr 2006 16:29 GMT

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.

Reply to this Message

Vladimir M. Zakharychev - 28 Apr 2006 16:46 GMT

> Hi,
>
[quoted text clipped - 7 lines]
> 4.2001E+10
> 1 row selected.

Perfectly correct answer - in scientific notation. 4.2001E+10 = 42001000000.
What's your Oracle version? svrmgrl was deprecated and obsoleted long ago.

Signature

Vladimir M Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

Reply to this Message

BS - 28 Apr 2006 16:55 GMT

8.1.7.2 should be upgrading soon to 10g

Reply to this Message

bdbafh@gmail.com - 28 Apr 2006 17:36 GMT

select 'data',trunc(sum(bytes)/(1024*1024)) mb
from dba_data_files
union all
select 'temp',trunc(sum(bytes)/(1024*1024)) mb
from dba_temp_files
union all
select 'redo',trunc(sum(bytes*members)/(1024*1024)) mb
from v$log
/

that's for 10.1. I don't have access to any 8.1.7 databases.

-bdbafh

Reply to this Message

William Robertson - 28 Apr 2006 17:38 GMT

> Hi,
>
[quoted text clipped - 7 lines]
> 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.

Reply to this Message

Brian Peasland - 28 Apr 2006 19:58 GMT

Try the same query in SQL*Plus. But before issuing the query, type in
the following:

COLUMN bytes FORMAT 999,999,999,999

Then issue the query:

select sum(BYTES) AS bytes from DBA_DATA_FILES;

If that does not give you the correct result, then please explain what
you expect to see...

Cheers,
Brian

Signature

===================================================================

Brian Peasland
oracle_dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.

"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Reply to this Message