Re: How find DB size

Don't forget the infamous redo long space does not show up and isn't EXPed; there is some view somewhere that has that info; basically just do

select (sum(bytes/(1024*1024)) from dba_data_files, and add that to the megs allocated to redo, to get the database size, if by that you mean "how much space is allocated to Oracle data type object storage or processing"; of course don't forget the space the software and logs and config files take up, as well.

That's "usually" what people mean who ask the question, because "usually" someone else is being a pain and wants to know "how much of 'their' machines are being taken up by Oracle (as in, can't be used by anything else).

That isn't the same as answering the question "how much space are data and other objects actually taking up, inside the space allocated".

RSH.
"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:3cca6d36$0$231$cc9e4d1f_at_news.dial.pipex.com...
> <sevenmr_at_hotmail.com> wrote in message
news:3CC9FD4C.7080904_at_hotmail.com...
> > Depends on what size you want. If you want the size of all of the
> > datafiles:
> <snip>
> > If you want the amount of space actually consumed by data:
> >
> > hire me to consult . . .
> >
> or for a first order estimate dump the database using exp. <g>.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
>
Received on Sat Apr 27 2002 - 14:34:11 CDT