1c.10. Compute Instances - Raw (OCI360_INSTANCES) 1c.10. Compute Instances - Raw (OCI360_INSTANCES)
| # | ID | SHAPE | REGI | IMAGE_ID | METADATA$SSH_AUTHORIZED_KEYS | IPXE | LAUNCH_MODE | SYST | AGENT_CO | AGENT_CO | DEFINED_TAGS$ORACLE_TAGS$CREATEDBY | DEFINED_TAGS$ORACLE_TAGS$CREATED | DISPLAY_NAME | FAULT_DOMAIN | SHAPE_CONFIG$GPUS | SHAPE_CONFIG$OCPUS | SHAPE_CONFIG$LOCAL_DISKS | SHAPE_CONFIG$MEMORY_IN_GBS | SHAP | SHAPE_CONFIG$MAX_VNIC_ATTACHMENTS | SHAPE_CONFIG$PROCESSOR_DESCRIPTION | SHAP | SHAPE_CONFIG$NETWORKING_BANDWIDTH_IN_GBPS | SHAP | TIME_CREATED | COMPARTMENT_ID | LAUNCH_O | LAUNCH_OPTIONS$N | LAUNCH_OPTIONS$B | LAUNCH_OPTIONS$R | LAUN | LAUNCH_O | SOURCE_DETAILS$IMAGE_ID | SOUR | SOURCE_D | SOUR | LIFECYCL | AVAILABILITY_DOMAIN | DEDI | TIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ocid1.instance.oc1.iad.000000000000000000000000000000000000000000000000000000000575 | VM.Standard.E2.1.Micro | iad | ocid1.image.oc1.iad.000000000000000000000000000000000000000000000000000000000508 | ssh-rsa XXX== [email protected] | PARAVIRTUALIZED | true | false | false | oracleidentitycloudservice/[email protected] | 2020-05-20T14:54:00.387Z | oci360comp | FAULT-DOMAIN-1 | 0 | 1 | 0 | 1 | 1 | 2.0 GHz AMD EPYC? 7551 (Naples) | .48 | 2020-05-20T14:54:01.477000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | UEFI_64 | PARAVIRTUALIZED | PARAVIRTUALIZED | PARAVIRTUALIZED | true | false | ocid1.image.oc1.iad.000000000000000000000000000000000000000000000000000000000508 | image | RUNNING | CYtq:US-ASHBURN-AD-3 |
#: 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)
SELECT t1.*
FROM OCI360_INSTANCES t1;
1 rows selected.