RE: A VLDB contest

  • From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 30 Aug 2006 08:42:07 -0700

 >>>
>>>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.



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


Other related posts: