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

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 Tue Dec 21 1999 - 16:13:55 CST