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

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 22 Dec 1999 15:22:20 GMT
Message-ID: <83qqbc$q3s$2@news.seed.net.tw>

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.

This is just one bug of the utlbstat/utlestat scripts. The utlbstat/utlestat scripts contains some other bugs and need some modifications before you decide to use them. Received on Wed Dec 22 1999 - 09:22:20 CST