RE: A VLDB contest

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Wed, 30 Aug 2006 08:42:07 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5AE7C@ex2.ms.polyserve.com>

 >>>

>>>SQL> select sum(TOTAL_MB) from v$asm_diskgroup_stat;
>>>
>>>SUM(TOTAL_MB)
>>>-------------
>>> 24398576
>>>
>>>Does this mean that Oracle is using on average 9 bytes per extent ?

well, the math is right at 7.59, but I can't imagine the structure of the
array is that simple. More likely that the entire disk group extent map is not currently mapped. But I don't know. I'm just exploring.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 30 2006 - 10:42:07 CDT