Re: Database Size
- From: Justin Mungal <justin@xxxxxxx>
- To: howard.latham@xxxxxxxxx, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 14 Nov 2013 06:32:36 -0600
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
>
>
>
Other related posts:
