Re: Size of a database

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 24 May 2002 16:31:48 +1000
Message-ID: <UflH8.16894$b5.58258@newsfeeds.bigpond.com>

Sum of bytes in v$datafile will get you the total size of your data files.
Sum of bytes in v$tempfile will get you the total size of your temp files.
Sum of bytes in v$log will get you the size of your redo log files

Sum of record_size in v$controlfile_record_section will get you the size of your control files.

I know it sounds silly but I normally use a ruler :)

Richard

"Mot Rao" <moturi_rao_at_hotmail.com> wrote in message news:8c4762d2.0205232036.5dfd3856_at_posting.google.com...
> Silly as it sounds.. How do we find the size of a database,, is they any
command ...
>
>
> Let me know
> Mot.
Received on Fri May 24 2002 - 01:31:48 CDT