https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Oracle-ZFS-quot-Raw-to-Usable-Ratio-quot-where-is-it-hiding-in-the-reports/m-p/153210#M27449 <P>I am trying to do a report about Oracle ZFS array storage pools. Looking at the data source support matrix dated Dec 11, 2019, on page 183 under the Oracle ZFS data source under Insight -&gt; Storage Pool -&gt; Raw to Usable Ratio.&nbsp;<BR /><BR />I want to use this ratio to make the raw space match the usable space in an OCI report compared to what I have on an array. Example, I have a ZFS pool that is using raidz1 log stripe and cache stripe on ~180 TB of raw disk. The usable amount per the ZFS array is 117 TB. With the ratio I believe I could take the raw capacity and display it to close to what the ZFS array reports.</P> <P>&nbsp;</P> <P>My problem is I look at the Schema diagram and I don't find it. I also go into DWH report and can't find it via the insertable objects under Storage and Storage Pools.&nbsp;<BR /><BR />Am I overlooking it? How to I use it?</P> Wed, 04 Jun 2025 12:06:00 GMT jim515new 2025-06-04T12:06:00Z https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Oracle-ZFS-quot-Raw-to-Usable-Ratio-quot-where-is-it-hiding-in-the-reports/m-p/153210#M27449 <P>I am trying to do a report about Oracle ZFS array storage pools. Looking at the data source support matrix dated Dec 11, 2019, on page 183 under the Oracle ZFS data source under Insight -&gt; Storage Pool -&gt; Raw to Usable Ratio.&nbsp;<BR /><BR />I want to use this ratio to make the raw space match the usable space in an OCI report compared to what I have on an array. Example, I have a ZFS pool that is using raidz1 log stripe and cache stripe on ~180 TB of raw disk. The usable amount per the ZFS array is 117 TB. With the ratio I believe I could take the raw capacity and display it to close to what the ZFS array reports.</P> <P>&nbsp;</P> <P>My problem is I look at the Schema diagram and I don't find it. I also go into DWH report and can't find it via the insertable objects under Storage and Storage Pools.&nbsp;<BR /><BR />Am I overlooking it? How to I use it?</P> Wed, 04 Jun 2025 12:06:00 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Oracle-ZFS-quot-Raw-to-Usable-Ratio-quot-where-is-it-hiding-in-the-reports/m-p/153210#M27449 jim515new 2025-06-04T12:06:00Z