PROSAGA码农传奇-openedge-从Progress-4gl数据库获取恢复大小

从Progress-4gl数据库获取恢复大小

作者: v-star*위위
发布时间: 2025-03-10 05:21:39 (2天前)
转自：

<div class =“post-text”itemprop =“text”>
  
    文档中有一个很好的例子。我会把它拉到这里：
  
  
    的
      表108.示例PROREST -list输出
    </强>
  
   <pre>
 <code>
 OpenEdge Release 10.2B1P as of Wed Oct 21 19:01:48 EDT 2009
Area Name: Schema Area
 Size: 11264, Records/Block: 32, Area Number: 6, Cluster Size: 1
Area Name: Info Area
 Size: 1024, Records/Block: 32, Area Number: 7, Cluster Size: 1
Area Name: Customer/Order Area
 Size: 6656, Records/Block: 32, Area Number: 8, Cluster Size: 8
Area Name: Primary Index Area
 Size: 112, Records/Block: 1, Area Number: 9, Cluster Size: 8
Area Name: Customer Index Area
 Size: 256, Records/Block: 1, Area Number: 10, Cluster Size: 64
Area Name: Order Index Area
 Size: 8192, Records/Block: 32, Area Number: 11, Cluster Size: 64
Area Name: Encryption Policy Area
 Size: 20448, Records/Block: 32, Area Number: 12, Cluster Size: 64
Area Name: Audit Area
 Size: 4608, Records/Block: 32, Area Number: 20, Cluster Size: 8
Area Name: Audit Index
 Size: 8704, Records/Block: 32, Area Number: 22, Cluster Size: 8

</code>
 </pre>
  
    使用PROREST -list的输出来计算每个恢复区域的大小，如下所示：
  
   <pre>
 <code>
 area-size = (Size / records-per-block) * database-block-size

</code>
 </pre>
  
    例如，还原的架构区域的大小为：
  
   <pre>
 <code>
 area-size = (Size / records-per-block) * database-block-size
1,441,792 = (11264 / 32) * 4096

</code>
 </pre>
  
    1441792将以字节为单位，因此除以1024（或1024 * 1024）以获得千字节（或兆字节）等。
  
  
    <a href="https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dmadm%2Fprorest-utility.html%23" rel="nofollow noreferrer">
      https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dmadm%2Fprorest-utility.html%23
    </A>
  
</DIV>