And add in volume of archive logs created per day/week. On Nov 14, 2013 10:01 PM, "Powell, Mark" <mark.powell2@xxxxxx> 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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Justin Mungal > *Sent:* Thursday, November 14, 2013 7:33 AM > *To:* howard.latham@xxxxxxxxx; 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@xxxxxxxxx> > 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 > > >