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