RE: Database Size

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Thu, 14 Nov 2013 21:58:04 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD11878F7BB_at_G6W2491.americas.hpqcorp.net>

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<mailto: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 - 22:58:04 CET