Re: Database Size

From: Justin Mungal <justin_at_n0de.ws>
Date: Thu, 14 Nov 2013 06:32:36 -0600
Message-ID: <CAO9=aUzgcrp6EmJxd020B1Q+jAKS-Gqemrr7ugv3sBvJHB7m1Q_at_mail.gmail.com>

The two I use are very simple:
select sum(bytes)/1024/1024/1024 GB from dba_segments; <-- current segment usage, so you can "ball-park" the space required to do something like an import.

select sum(bytes)/1024/1024/1024 GB from dba_data_files; <-- The size of the actual data files, including free space. Handy if you're wanting to create an identical copy of the db.

Temp files and redo are not included but that information is easy enough to obtain.

HTH,
Justin

On Thu, Nov 14, 2013 at 5:55 AM, Howard Latham <howard.latham_at_gmail.com>wrote:

> Any OS
> Any current Version
>
> A quick question that MAY promote some discussion.
> Whats the easiest/ most accurate way to get a database size with a view to
> copying it to another server (resizing is ok) ? Excluding 3rd party tools -
> well Ok spotlight gives a quick summary so forget that condition!
>
>
>
>
> --
> Howard A. Latham
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 14 2013 - 13:32:36 CET