1c.13. Shapes (OCI360_SHAPES) 1c.13. Shapes (OCI360_SHAPES)
| # | SHAPE | OCPU | MEMORY_GB | LOCAL_DISK_TB | NETWORK_GBPS | GPU | Hour US$ |
|---|---|---|---|---|---|---|---|
| 1 | VM.Standard2.1 | 1 | 15 | 1 | |||
| 2 | VM.Standard.E2.1 | 1 | 8 | .7 | |||
| 3 | VM.Standard.E2.2 | 2 | 16 | 1.4 | |||
| 4 | VM.Standard.E2.1.Micro |
#: click on a column heading to sort on it
* US$ costs are estimations for Month Flex, not considering machine state or any other changes. Values base date: 2018-08-28
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
GPUS NUMBER
OCPUS NUMBER
SHAPE VARCHAR2(32)
LOCAL_DISKS NUMBER
OCPU_OPTIONS VARCHAR2(4)
MEMORY_IN_GBS NUMBER
MEMORY_OPTIONS VARCHAR2(4)
GPU_DESCRIPTION VARCHAR2(4)
MAX_VNIC_ATTACHMENTS NUMBER
PROCESSOR_DESCRIPTION VARCHAR2(64)
LOCAL_DISK_DESCRIPTION VARCHAR2(4)
MAX_VNIC_ATTACHMENT_OPTIONS VARCHAR2(4)
NETWORKING_BANDWIDTH_IN_GBPS NUMBER
NETWORKING_BANDWIDTH_OPTIONS VARCHAR2(4)
LOCAL_DISKS_TOTAL_SIZE_IN_GBS VARCHAR2(4)
WITH
t_price_comp AS (SELECT /*+ materialize */ * FROM "OCI360_PRICING" WHERE subject = 'COMPUTE')
SELECT distinct t1.shape, t2.ocpu, t2.memory_gb, t2.local_disk_tb, t2.network_gbps, t2.gpu, t3.mf "Hour US$"
FROM OCI360_SHAPES t1,
"OCI360_SHAPE_SPECS" t2,
t_price_comp t3
WHERE t1.shape = t2.shape(+)
AND t1.shape = t3.inst_type(+);
4 rows selected.