Re: Megabyte is Oracle is not 2**10!

For completeness my definition is 2**20 or others notation 2^20

or

is bytes 1048576

or 1k * 1k which is 1024 * 1024

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United Kingdom)

                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Bill Cohagan <bill_at_XNOSPAMXteraquest.com> wrote in message news:R3T74.68$fj1.1943_at_newsin1.ispchannel.com...
> Since 2**10 = 1024 I doubt anybody's definition of megabyte is 2**10!!
>
> Bill
>
> Bernard Polarski <bpolarsk_at_yahoo.com> wrote in message
> news:83o12e$ock$1_at_nnrp1.deja.com...
> > I can't believe it : from utlbstat.sql in oracle 7.3.4
> >
> > select ts.name ts,
> > i.name name,
> > x.phyrds pyr,
> > x.phywrts pyw,
> > x.readtim prt,
> > x.writetim pwt,
> > x.phyblkrd pbr,
> > x.phyblkwrt pbw,
> > round(i.bytes/1000000) megabytes_size
> > from v$filestat x, ts$ ts, v$datafile i,file$ f
> > where i.file#=f.file#
> > and ts.ts#=f.ts#
> > and x.file#=f.file#;
> >
> > The Megabyte at Oracle is 1,000,000 bytes. I knew that the standard of
> > Disks for the megabytes is Decimal while the rest of universe consider
> > a megabyte as being 2**10. So the megabyte of Oracle is Decimal. good
> > to know.
> >
> >
> > B. Polarski
> > --
> > B.Polarski
> >
> > http://www.geocities.com/bpolarsk
> > Email : bpolarsk_at_yahoo.com
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Wed Dec 22 1999 - 04:05:58 CST