RE: Database Size

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 15 Nov 2013 11:59:43 +0000
Message-ID: <CABe10sb9m5vebopx9+Y7iX7G8HHKrkR=tB_guVQ9yhpiR67KJA_at_mail.gmail.com>

And add in volume of archive logs created per day/week. On Nov 14, 2013 10:01 PM, "Powell, Mark" <mark.powell2_at_hp.com> wrote:

> I also include the online redo logs and control file in the estimate.
>
>
>
> set echo off
>
> --
>
> -- Get Size of Database Data Files
>
> --
>
> -- 2013-10-08 Mark D Powell Save q
>
> -- 2013-10-16 Mark D Powell + control file sz
>
> --
>
>
>
> select
>
> round(sum(SIZEG),1) SIZE_GB
>
> from (
>
> select
>
> sum(bytes) / 1048576 / 1024 "SIZEG"
>
> from
>
> dba_data_files
>
> union all
>
> select
>
> sum(bytes) / 1048576 / 1024
>
> from
>
> dba_temp_files
>
> union all
>
> select
>
> sum(bytes) / 1048576 / 1024
>
> from
>
> v$log
>
> union all
>
> select
>
> sum(block_size * file_size_blks) / 1048576 / 1024
>
> from
>
> v$controlfile
>
> )
>
> /
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Justin Mungal
> *Sent:* Thursday, November 14, 2013 7:33 AM
> *To:* howard.latham_at_gmail.com; oracle-l-freelists
> *Subject:* Re: Database Size
>
>
>
> 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 Fri Nov 15 2013 - 12:59:43 CET