5d.391. Cost division per Resource, between 2020-04-18 and 2020-06-28 (OCI360_USAGECOSTS) 5d.391. Cost division per Resource, between 2020-04-18 and 2020-06-28 (OCI360_USAGECOSTS)
| # | SERVICENAME | TOTAL | PERCENT |
|---|---|---|---|
| 1 | DATABASEBAREMETAL - PIC_DATABASE_CLOUD_ENTERPRISE_EDITION - USD 6 | 6 | 41.23 |
| 2 | COMPUTEBAREMETAL - PIC_BLOCK_STORAGE_STANDARD - USD 5 | 5 | 33.83 |
| 3 | COMPUTEBAREMETAL - PIC_COMPUTE_STANDARD_E2 - USD 3 | 3 | 19.05 |
| 4 | DATABASEBAREMETAL - PIC_DATABASE_CLOUD_ALL_EDITION_BYOL - USD 0 | 0 | 2.04 |
| 5 | COMPUTEBAREMETAL - PIC_STANDARD_STORAGE - USD 0 | 0 | 1.63 |
| 6 | COMPUTEBAREMETAL - PIC_OBJECT_STORAGE_REQUEST_TIERED - USD 0 | 0 | 1.17 |
| 7 | COMPUTEBAREMETAL - PIC_STANDARD_PERFORMANCE - USD 0 | 0 | 1.05 |
#: click on a column heading to sort on it
Total for 70 days period.
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
COSTS$UNITPRICE NUMBER
COSTS$OVERAGESFLAG VARCHAR2(1)
COSTS$COMPUTEDAMOUNT NUMBER
COSTS$COMPUTEDQUANTITY NUMBER
CURRENCY VARCHAR2(4)
QUANTITY NUMBER
ENDTIMEUTC VARCHAR2(32)
SERVICENAME VARCHAR2(32)
DATACENTERID VARCHAR2(16)
GSIPRODUCTID VARCHAR2(8)
RESOURCENAME VARCHAR2(64)
STARTTIMEUTC VARCHAR2(32)
SUBSCRIPTIONID VARCHAR2(8)
SUBSCRIPTIONTYPE VARCHAR2(16)
LASTCOMPUTATIONDATE VARCHAR2(32)
SERVICEENTITLEMENTID VARCHAR2(16)
WITH t1 AS (
SELECT COSTS$COMPUTEDAMOUNT COMPUTEDAMOUNT,
SERVICENAME,
RESOURCENAME,
CURRENCY
FROM OCI360_USAGECOSTS ),
t2 as (select sum(COMPUTEDAMOUNT) total_global from t1)
SELECT t1.SERVICENAME || ' - ' || t1.RESOURCENAME || ' - ' || t1.CURRENCY || ' ' || round(sum(COMPUTEDAMOUNT)) SERVICENAME,
round(sum(COMPUTEDAMOUNT)) total,
trim(to_char(round(sum(COMPUTEDAMOUNT)/decode(total_global,0,1,total_global),4)*100,'990D99')) percent
FROM t1, t2
GROUP BY t1.SERVICENAME,t1.RESOURCENAME,t1.CURRENCY,total_global
having sum(COMPUTEDAMOUNT) <> 0
order by total desc;
7 rows selected.