# | RESOURCE_NAME | TOTAL | PERCENT |
---|---|---|---|
1 | PIC_STANDARD_STORAGE - 27844606564 | 27844606564 | 9.92 |
2 | PIC_OBJECT_STORAGE_TIERED - 2943152803.08594 | 2943152803.08594 | 1.05 |
3 | PIC_BLOCK_STORAGE_STANDARD_FREE - 249977767056 | 249977767056 | 89.03 |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
lineItem/referenceNo VARCHAR2(4000)
lineItem/tenantId VARCHAR2(4000)
lineItem/intervalUsageStart VARCHAR2(4000)
lineItem/intervalUsageEnd VARCHAR2(4000)
product/service VARCHAR2(4000)
product/resource VARCHAR2(4000)
product/compartmentId VARCHAR2(4000)
product/compartmentName VARCHAR2(4000)
product/region VARCHAR2(4000)
product/availabilityDomain VARCHAR2(4000)
product/resourceId VARCHAR2(4000)
usage/consumedQuantity VARCHAR2(4000)
usage/billedQuantity VARCHAR2(4000)
usage/consumedQuantityUnits VARCHAR2(4000)
usage/consumedQuantityMeasure VARCHAR2(4000)
lineItem/isCorrection VARCHAR2(4000)
lineItem/backreferenceNo VARCHAR2(4000)
tags/Oracle-Tags.CreatedBy VARCHAR2(4000)
tags/Oracle-Tags.CreatedOn VARCHAR2(4000)
tags/orcl-cloud.free-tier-retained VARCHAR2(4000)
tags/backup VARCHAR2(4000)
WITH tot as
(SELECT SUM("usage/consumedQuantity") total_global
FROM OCI360_REPORTS_USAGE
where "product/service" = 'BLOCK_STORAGE' AND TRIM("usage/consumedQuantityUnits" || ' ' || "usage/consumedQuantityMeasure") = 'GB_MS STORAGE_SIZE'
)
SELECT "product/resource" || ' - ' || SUM("usage/consumedQuantity") resource_name,
SUM("usage/consumedQuantity") total,
trim(to_char(round(SUM("usage/consumedQuantity")/decode(total_global,0,1,total_global),4)*100,'990D99')) percent
FROM OCI360_REPORTS_USAGE, tot
where "product/service" = 'BLOCK_STORAGE' AND TRIM("usage/consumedQuantityUnits" || ' ' || "usage/consumedQuantityMeasure") = 'GB_MS STORAGE_SIZE'
GROUP BY "product/resource",total_global;
3 rows selected.