1c.9. Compute Instances (OCI360_INSTANCES) 1c.9. Compute Instances (OCI360_INSTANCES)
| # | ID | DISPLAY_NAME | SHAPE | REGI | AVAILABILITY_DOMAIN | LIFECYCL | IMAGE_NAME | OPERATING_SYSTEM | OPERATING_SYSTEM_VERSION | FAULT_DOMAIN | TIME_CREATED | COMPARTMENT_NAME | IP_ADDRESS_PRI_P | IP_ADDRESS_PUB_P |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ocid1.instance.oc1.iad.000000000000000000000000000000000000000000000000000000000575 | oci360comp | VM.Standard.E2.1.Micro | iad | CYtq:US-ASHBURN-AD-3 | RUNNING | Oracle-Linux-7.8-2020.04.17-0 | Oracle Linux | 7.8 | FAULT-DOMAIN-1 | 2020-05-20T14:54:01.477000+00:00 | compt_dev_app | 10.100.4.2 | 150.136.X.X |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
SHAPE VARCHAR2(32)
REGION VARCHAR2(4)
IMAGE_ID VARCHAR2(128)
METADATA$SSH_AUTHORIZED_KEYS VARCHAR2(512)
IPXE_SCRIPT VARCHAR2(4)
LAUNCH_MODE VARCHAR2(16)
SYSTEM_TAGS$ORCL_CLOUD$FREE_TIER_RETAINED VARCHAR2(4)
AGENT_CONFIG$IS_MANAGEMENT_DISABLED VARCHAR2(8)
AGENT_CONFIG$IS_MONITORING_DISABLED VARCHAR2(8)
DEFINED_TAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DEFINED_TAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DISPLAY_NAME VARCHAR2(16)
FAULT_DOMAIN VARCHAR2(16)
SHAPE_CONFIG$GPUS NUMBER
SHAPE_CONFIG$OCPUS NUMBER
SHAPE_CONFIG$LOCAL_DISKS NUMBER
SHAPE_CONFIG$MEMORY_IN_GBS NUMBER
SHAPE_CONFIG$GPU_DESCRIPTION VARCHAR2(4)
SHAPE_CONFIG$MAX_VNIC_ATTACHMENTS NUMBER
SHAPE_CONFIG$PROCESSOR_DESCRIPTION VARCHAR2(64)
SHAPE_CONFIG$LOCAL_DISK_DESCRIPTION VARCHAR2(4)
SHAPE_CONFIG$NETWORKING_BANDWIDTH_IN_GBPS NUMBER
SHAPE_CONFIG$LOCAL_DISKS_TOTAL_SIZE_IN_GBS VARCHAR2(4)
TIME_CREATED VARCHAR2(32)
COMPARTMENT_ID VARCHAR2(128)
LAUNCH_OPTIONS$FIRMWARE VARCHAR2(8)
LAUNCH_OPTIONS$NETWORK_TYPE VARCHAR2(16)
LAUNCH_OPTIONS$BOOT_VOLUME_TYPE VARCHAR2(16)
LAUNCH_OPTIONS$REMOTE_DATA_VOLUME_TYPE VARCHAR2(16)
LAUNCH_OPTIONS$IS_CONSISTENT_VOLUME_NAMING_ENABLED VARCHAR2(4)
LAUNCH_OPTIONS$IS_PV_ENCRYPTION_IN_TRANSIT_ENABLED VARCHAR2(8)
SOURCE_DETAILS$IMAGE_ID VARCHAR2(128)
SOURCE_DETAILS$KMS_KEY_ID VARCHAR2(4)
SOURCE_DETAILS$SOURCE_TYPE VARCHAR2(8)
SOURCE_DETAILS$BOOT_VOLUME_SIZE_IN_GBS VARCHAR2(4)
LIFECYCLE_STATE VARCHAR2(8)
AVAILABILITY_DOMAIN VARCHAR2(32)
DEDICATED_VM_HOST_ID VARCHAR2(4)
TIME_MAINTENANCE_REBOOT_DUE VARCHAR2(4)
WITH t1 as (select /*+ materialize */ * from OCI360_INSTANCES),
t2 as (select /*+ materialize */ * from OCI360_COMPARTMENTS),
t3 as (select /*+ materialize */ * from OCI360_IMAGES),
t4 as (select /*+ materialize */ * from OCI360_VNIC_ATTACHS),
t5 as (select /*+ materialize */ * from OCI360_VNICS)
SELECT distinct t1.id,
t1.display_name,
t1.shape,
t1.region,
t1.availability_domain,
t1.lifecycle_state,
t3.display_name image_name,
t3.operating_system,
t3.operating_system_version,
t1.fault_domain,
t1.time_created,
t2.name compartment_name,
t5.private_ip ip_address_pri_primary,
t5.public_ip ip_address_pub_primary
FROM t1,t2,t3,t4,t5
WHERE t1.image_id = t3.id (+)
AND t1.compartment_id = t2.id (+)
AND t1.id = t4.instance_id
AND t4.lifecycle_state = 'ATTACHED'
AND t4.vnic_id = t5.id
AND t5.is_primary = 'true'
AND t5.lifecycle_state = 'AVAILABLE';
1 rows selected.