On 9/14/05, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
>
> On 9/14/05, Michael McMullen <ganstadba_at_hotmail.com> wrote:
> >
> > Well, I did ask for platform. And a 40Gb database on windows 2000 SE,
> > how
> > many people have those?
>
> SQL> select sum(bytes)/1024/1024/1204 SizeGB
> 2 from dba_data_files;
>
> SIZEGB
> ----------
> 48.75
>
Michael kindly pointed out that this isn't the best definition of GB in the
universe. 1204 not being a fantasticly good number. This is why I normally
script everything - inability to type.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 14 2005 - 14:57:30 CDT
