How to see Database size ?

[aruri]

How can I see Database size in Oracle, and what are Oracle 8i
Tools.

kindly suggest please.
with kind regards,
Badri.

[deggzy]

select sum(bytes/1024/1024) MB
from dba_data_files;

This will give you the size of all datafiles.

Is this what you meant?

[ocpdude]

Add to this the size (in megabytes) of your redo logs:

select sum(bytes)/1024/1024 from v$log;