# | ID | DB_NAME | NSG_ | SUBN | DB_V | IS_PREVI | DB_W | SYST | DEFINED_TAGS$ORACLE_TAGS$CREATEDBY | DEFINED_TAGS$ORACLE_TAGS$CREATED | DISPLAY_ | IS_DEDIC | IS_F | TIME_CREATED | LICENSE_MODEL | COMPARTMENT_ID | CPU_CORE_COUNT | CONNECTION_URLS$APEX_URL | CONNECTION_URLS$SQL_DEV_WEB_URL | CONNECTION_URLS$MACHINE_LEARNING_USER_MANAGEMENT_URL | LIFECYCLE_STATE | DATA_SAFE_STATUS | PRIV | LIFE | CONNECTION_STRINGS$LOW | CONNECTION_STRINGS$HIGH | CONNECTION_STRINGS$MEDIUM | CONN | CONNECTION_STRINGS$ALL_CONNECTION_STRINGS$TP | CONNECTION_STRINGS$ALL_CONNECTION_STRINGS$LOW | CONNECTION_STRINGS$ALL_CONNECTION_STRINGS$HIGH | CONNECTION_STRINGS$ALL_CONNECTION_STRINGS$MEDIUM | CONNECTION_STRINGS$ALL_CONNECTION_STRINGS$TPURGENT | SERVICE_CONSOLE_URL | TIME_MAINTENANCE_END | PRIV | TIME_MAINTENANCE_BEGIN | IS_AUTO_ | DATA_STORAGE_SIZE_IN_TBS | AVAILABLE_UPGRADE_VERSIONS | USED_DATA_STORAGE_SIZE_IN_TBS | AUTO | TIME | TIME_RECLAMATION_OF_FREE_AUTONOM | WHITELISTED_IPS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ocid1.autonomousdatabase.oc1.iad.000000000000000000000000000000000000000000000000000000000138 | oci360 | 19c | false | OLTP | true | oracleidentitycloudservice/[email protected] | 2020-05-14T13:27:07.560Z | oci360 | false | true | 2020-05-14T13:27:07.563000+00:00 | LICENSE_INCLUDED | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 | 1 | https://KLR8S3FX1B6HNYE-OCI360.adb.us-ashburn-1.oraclecloudapps.com/ords/apex | https://KLR8S3FX1B6HNYE-OCI360.adb.us-ashburn-1.oraclecloudapps.com/ords/admin/_sdw/?nav=worksheet | https://adb.us-ashburn-1.oraclecloud.com/omlusers/tenants/OCID1.TENANCY.OC1..XXX/databases/OCI360/index.html | AVAILABLE | NOT_REGISTERED | adb.us-ashburn-1.oraclecloud.com:1522/klr8s3fx1b6hnye_oci360_low.atp.oraclecloud.com | adb.us-ashburn-1.oraclecloud.com:1522/klr8s3fx1b6hnye_oci360_high.atp.oraclecloud.com | adb.us-ashburn-1.oraclecloud.com:1522/klr8s3fx1b6hnye_oci360_medium.atp.oraclecloud.com | adb.us-ashburn-1.oraclecloud.com:1522/klr8s3fx1b6hnye_oci360_tp.atp.oraclecloud.com | adb.us-ashburn-1.oraclecloud.com:1522/klr8s3fx1b6hnye_oci360_low.atp.oraclecloud.com | adb.us-ashburn-1.oraclecloud.com:1522/klr8s3fx1b6hnye_oci360_high.atp.oraclecloud.com | adb.us-ashburn-1.oraclecloud.com:1522/klr8s3fx1b6hnye_oci360_medium.atp.oraclecloud.com | adb.us-ashburn-1.oraclecloud.com:1522/klr8s3fx1b6hnye_oci360_tpurgent.atp.oraclecloud.com | https://adb.us-ashburn-1.oraclecloud.com/console/index.html?tenant_name=OCID1.TENANCY.OC1..XXX&database_name=OCI360&service_type=ATP | 2020-07-05T00:00:00+00:00 | 2020-07-04T20:00:00+00:00 | false | 1 | [] | 1 | 2020-07-06T15:24:19.968000+00:00 | 0.0.0.0/0 |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
DB_NAME VARCHAR2(8)
NSG_IDS VARCHAR2(4)
SUBNET_ID VARCHAR2(4)
DB_VERSION VARCHAR2(4)
IS_PREVIEW VARCHAR2(8)
DB_WORKLOAD VARCHAR2(4)
SYSTEM_TAGS$ORCL_CLOUD$FREE_TIER_RETAINED VARCHAR2(4)
DEFINED_TAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DEFINED_TAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DISPLAY_NAME VARCHAR2(8)
IS_DEDICATED VARCHAR2(8)
IS_FREE_TIER VARCHAR2(4)
TIME_CREATED VARCHAR2(32)
LICENSE_MODEL VARCHAR2(16)
COMPARTMENT_ID VARCHAR2(128)
CPU_CORE_COUNT NUMBER
CONNECTION_URLS$APEX_URL VARCHAR2(128)
CONNECTION_URLS$SQL_DEV_WEB_URL VARCHAR2(128)
CONNECTION_URLS$MACHINE_LEARNING_USER_MANAGEMENT_URL VARCHAR2(256)
LIFECYCLE_STATE VARCHAR2(16)
DATA_SAFE_STATUS VARCHAR2(16)
PRIVATE_ENDPOINT VARCHAR2(4)
LIFECYCLE_DETAILS VARCHAR2(4)
CONNECTION_STRINGS$LOW VARCHAR2(128)
CONNECTION_STRINGS$HIGH VARCHAR2(128)
CONNECTION_STRINGS$MEDIUM VARCHAR2(128)
CONNECTION_STRINGS$DEDICATED VARCHAR2(4)
CONNECTION_STRINGS$ALL_CONNECTION_STRINGS$TP VARCHAR2(128)
CONNECTION_STRINGS$ALL_CONNECTION_STRINGS$LOW VARCHAR2(128)
CONNECTION_STRINGS$ALL_CONNECTION_STRINGS$HIGH VARCHAR2(128)
CONNECTION_STRINGS$ALL_CONNECTION_STRINGS$MEDIUM VARCHAR2(128)
CONNECTION_STRINGS$ALL_CONNECTION_STRINGS$TPURGENT VARCHAR2(128)
SERVICE_CONSOLE_URL VARCHAR2(256)
TIME_MAINTENANCE_END VARCHAR2(32)
PRIVATE_ENDPOINT_LABEL VARCHAR2(4)
TIME_MAINTENANCE_BEGIN VARCHAR2(32)
IS_AUTO_SCALING_ENABLED VARCHAR2(8)
DATA_STORAGE_SIZE_IN_TBS NUMBER
AVAILABLE_UPGRADE_VERSIONS VARCHAR2(4000)
USED_DATA_STORAGE_SIZE_IN_TBS NUMBER
AUTONOMOUS_CONTAINER_DATABASE_ID VARCHAR2(4)
TIME_DELETION_OF_FREE_AUTONOMOUS_DATABASE VARCHAR2(4)
TIME_RECLAMATION_OF_FREE_AUTONOMOUS_DATABASE VARCHAR2(32)
WHITELISTED_IPS VARCHAR2(16)
SELECT t1.*
FROM OCI360_AUTONOMOUS_DB t1;
1 rows selected.