2a.34. Unallocated Volumes (OCI360_VOLUMES) 2a.34. Unallocated Volumes (OCI360_VOLUMES)
| # | ID | KMS_ | IS_H | SIZE_IN_GBS | SIZE_IN_MBS | VPUS_PER_GB | DISPLAY_NAME | TIME_CREATED | COMPARTMENT_ID | S | S | LIFECYCLE_STATE | VOLU | AVAILABILITY_DOMAIN |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000711 | true | 50 | 51200 | 0 | test_vol | 2020-06-26T18:15:04.901000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 | TERMINATED | CYtq:US-ASHBURN-AD-3 |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
KMS_KEY_ID VARCHAR2(4)
IS_HYDRATED VARCHAR2(4)
SIZE_IN_GBS NUMBER
SIZE_IN_MBS NUMBER
SYSTEM_TAGS$ORCL_CLOUD$FREE_TIER_RETAINED VARCHAR2(4)
VPUS_PER_GB NUMBER
DEFINED_TAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DEFINED_TAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DISPLAY_NAME VARCHAR2(16)
TIME_CREATED VARCHAR2(32)
COMPARTMENT_ID VARCHAR2(128)
LIFECYCLE_STATE VARCHAR2(16)
VOLUME_GROUP_ID VARCHAR2(4)
AVAILABILITY_DOMAIN VARCHAR2(32)
SOURCE_DETAILS$ID VARCHAR2(1)
SOURCE_DETAILS$TYPE VARCHAR2(1)
with t1 as (SELECT /*+ materialize */ * FROM oci360_volumes),
t2 as (SELECT /*+ materialize */ * FROM oci360_vol_attachs)
SELECT ID,
KMS_KEY_ID,
IS_HYDRATED,
SIZE_IN_GBS,
SIZE_IN_MBS,
VPUS_PER_GB,
DISPLAY_NAME,
TIME_CREATED,
COMPARTMENT_ID,
SOURCE_DETAILS$ID,
SOURCE_DETAILS$TYPE,
LIFECYCLE_STATE,
VOLUME_GROUP_ID,
AVAILABILITY_DOMAIN
FROM t1
WHERE not exists (SELECT 1 FROM t2 WHERE t1.id = t2.volume_id AND t2.lifecycle_state = 'ATTACHED');
1 rows selected.