Re: Database Size
From: Chris Dunscombe <cdunscombe_at_yahoo.com>
Date: Fri, 15 Nov 2013 08:34:23 +0000 (GMT)
Message-ID: <1384504463.77956.YahooMailNeo_at_web28704.mail.ir2.yahoo.com>
Hi, And if you're talking about the space required on the new server then you need to include temp files from the temp tablespace plus FRA space as well. Cheers, Chris On Thursday, 14 November 2013, 22:00, "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
Date: Fri, 15 Nov 2013 08:34:23 +0000 (GMT)
Message-ID: <1384504463.77956.YahooMailNeo_at_web28704.mail.ir2.yahoo.com>
Hi, And if you're talking about the space required on the new server then you need to include temp files from the temp tablespace plus FRA space as well. Cheers, Chris On Thursday, 14 November 2013, 22:00, "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-lReceived on Fri Nov 15 2013 - 09:34:23 CET