turbot/oci

GitHub
steampipe plugin install ocisteampipe plugin install oci
oci_adm_knowledge_baseoci_adm_vulnerability_auditoci_ai_anomaly_detection_ai_private_endpointoci_ai_anomaly_detection_data_assetoci_ai_anomaly_detection_modeloci_ai_anomaly_detection_projectoci_analytics_instanceoci_apigateway_apioci_application_migration_migrationoci_application_migration_sourceoci_artifacts_container_imageoci_artifacts_container_image_signatureoci_artifacts_container_repositoryoci_artifacts_generic_artifactoci_artifacts_repositoryoci_autoscaling_auto_scaling_configurationoci_autoscaling_auto_scaling_policyoci_bastion_bastionoci_bastion_sessionoci_bds_bds_instanceoci_budget_alert_ruleoci_budget_budgetoci_certificates_authority_bundleoci_certificates_management_associationoci_certificates_management_ca_bundleoci_certificates_management_certificateoci_certificates_management_certificate_authorityoci_certificates_management_certificate_authority_versionoci_certificates_management_certificate_versionoci_cloud_guard_configurationoci_cloud_guard_detector_recipeoci_cloud_guard_managed_listoci_cloud_guard_responder_recipeoci_cloud_guard_targetoci_container_instances_containeroci_container_instances_container_instanceoci_containerengine_clusteroci_core_block_volume_replicaoci_core_boot_volumeoci_core_boot_volume_attachmentoci_core_boot_volume_backupoci_core_boot_volume_metric_read_opsoci_core_boot_volume_metric_read_ops_dailyoci_core_boot_volume_metric_read_ops_hourlyoci_core_boot_volume_metric_write_opsoci_core_boot_volume_metric_write_ops_dailyoci_core_boot_volume_metric_write_ops_hourlyoci_core_boot_volume_replicaoci_core_cluster_networkoci_core_dhcp_optionsoci_core_drgoci_core_imageoci_core_image_customoci_core_instanceoci_core_instance_configurationoci_core_instance_metric_cpu_utilizationoci_core_instance_metric_cpu_utilization_dailyoci_core_instance_metric_cpu_utilization_hourlyoci_core_internet_gatewayoci_core_load_balanceroci_core_local_peering_gatewayoci_core_nat_gatewayoci_core_network_load_balanceroci_core_network_security_groupoci_core_public_ipoci_core_public_ip_pooloci_core_route_tableoci_core_security_listoci_core_service_gatewayoci_core_subnetoci_core_vcnoci_core_vnic_attachmentoci_core_volumeoci_core_volume_attachmentoci_core_volume_backupoci_core_volume_backup_policyoci_core_volume_default_backup_policyoci_core_volume_groupoci_database_autonomous_databaseoci_database_autonomous_db_metric_cpu_utilizationoci_database_autonomous_db_metric_cpu_utilization_dailyoci_database_autonomous_db_metric_cpu_utilization_hourlyoci_database_autonomous_db_metric_storage_utilizationoci_database_autonomous_db_metric_storage_utilization_dailyoci_database_autonomous_db_metric_storage_utilization_hourlyoci_database_dboci_database_db_homeoci_database_db_systemoci_database_pluggable_databaseoci_database_software_imageoci_devops_projectoci_devops_repositoryoci_dns_rrsetoci_dns_tsig_keyoci_dns_zoneoci_events_ruleoci_file_storage_file_systemoci_file_storage_mount_targetoci_file_storage_snapshotoci_functions_applicationoci_functions_functionoci_identity_api_keyoci_identity_auth_tokenoci_identity_authentication_policyoci_identity_availability_domainoci_identity_compartmentoci_identity_customer_secret_keyoci_identity_dynamic_groupoci_identity_groupoci_identity_network_sourceoci_identity_policyoci_identity_tag_defaultoci_identity_tag_namespaceoci_identity_tenancyoci_identity_useroci_kms_keyoci_kms_key_versionoci_kms_vaultoci_logging_logoci_logging_log_groupoci_logging_searchoci_mysql_backupoci_mysql_channeloci_mysql_configurationoci_mysql_configuration_customoci_mysql_db_systemoci_mysql_db_system_metric_connectionsoci_mysql_db_system_metric_connections_dailyoci_mysql_db_system_metric_connections_hourlyoci_mysql_db_system_metric_cpu_utilizationoci_mysql_db_system_metric_cpu_utilization_dailyoci_mysql_db_system_metric_cpu_utilization_hourlyoci_mysql_db_system_metric_memory_utilizationoci_mysql_db_system_metric_memory_utilization_dailyoci_mysql_heat_wave_clusteroci_network_firewall_firewalloci_network_firewall_policyoci_nosql_tableoci_nosql_table_metric_read_throttle_countoci_nosql_table_metric_read_throttle_count_dailyoci_nosql_table_metric_read_throttle_count_hourlyoci_nosql_table_metric_storage_utilizationoci_nosql_table_metric_storage_utilization_dailyoci_nosql_table_metric_storage_utilization_hourlyoci_nosql_table_metric_write_throttle_countoci_nosql_table_metric_write_throttle_count_dailyoci_nosql_table_metric_write_throttle_count_hourlyoci_objectstorage_bucketoci_objectstorage_objectoci_ons_notification_topicoci_ons_subscriptionoci_queue_queueoci_regionoci_resource_searchoci_resourcemanager_stackoci_streaming_streamoci_vault_secret

Table: oci_database_autonomous_database

Oracle Cloud Infrastructure's Autonomous Database is a fully managed, preconfigured database environment with four workload types available:

  • Autonomous Transaction Processing
  • Autonomous Data Warehouse
  • Oracle APEX Application Development
  • Autonomous JSON Database

Examples

Basic info

select
db_name,
display_name,
lifecycle_state,
time_created
from
oci_database_autonomous_database;

List databases that are not available

select
db_name,
display_name,
lifecycle_state,
time_created
from
oci_database_autonomous_database
where
lifecycle_state <> 'AVAILABLE';

List databases with a data storage size greater than 1024 GB

select
db_name,
display_name,
lifecycle_state,
time_created
from
oci_database_autonomous_database
where
data_storage_size_in_gbs > 1024;

Get KMS key details for the databases

select
d.db_name,
d.display_name,
d.kms_key_id,
k.name as key_name,
k.algorithm as key_algorithm,
k.current_key_version,
k.protection_mode
from
oci_database_autonomous_database as d,
oci_kms_key as k
where
k.id = d.kms_key_id;

Get KMS vault details for the databases

select
d.db_name,
d.display_name,
d.vault_id,
v.display_name as vault_display_name,
v.crypto_endpoint,
v.vault_type,
v.management_endpoint
from
oci_database_autonomous_database as d,
oci_kms_vault as v
where
v.id = d.vault_id;

Query examples

Control examples

.inspect oci_database_autonomous_database

OCI Database Autonomous Database

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
apex_detailsjsonbInformation about Oracle APEX Application Development.
are_primary_whitelisted_ips_usedbooleanThis field will be null if the Autonomous Database is not Data Guard enabled or Access Control is disabled.
autonomous_container_database_idtextThe Autonomous Container Database OCID.
available_upgrade_versionsjsonbList of Oracle Database versions available for a database upgrade. If there are no version upgrades available, this list is empty.
backup_configjsonbAutonomous Database configuration details for storing manual backups in the Object Storage service.
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
connection_stringsjsonbThe connection string used to connect to the Autonomous Database. The username for the Service Console is ADMIN. Use the password you entered when creating the Autonomous Database for the password value.
connection_urlsjsonbThe URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance within your VCN or that has a direct connection to your VCN. Note that these URLs are provided by the console only for databases on dedicated Exadata infrastructure.
cpu_core_countbigintThe number of OCPU cores to be made available to the database.
data_safe_statustextStatus of the Data Safe registration for this Autonomous Database.
data_storage_size_in_gbsbigintThe quantity of data in the database, in gigabytes.
data_storage_size_in_tbsbigintThe quantity of data in the database, in terabytes.
db_nametextThe database name.
db_versiontextA valid Oracle Database version for Autonomous Database.
db_workloadtextThe Autonomous Database workload type.
defined_tagsjsonbDefined tags for resource. Defined tags are set up in your tenancy by an administrator. Only users granted permission to work with the defined tags can apply them to resources.
display_nametextThe user-friendly name for the Autonomous Database. The name does not have to be unique.
failed_data_recovery_in_secondsbigintIndicates the number of seconds of data loss for a Data Guard failover.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the Autonomous Database.
infrastructure_typetextThe infrastructure type this resource belongs to.
is_access_control_enabledbooleanIndicates if the database-level access control is enabled.
is_auto_scaling_enabledbooleanIndicates if auto scaling is enabled for the Autonomous Database CPU core count.
is_data_guard_enabledbooleanIndicates whether the Autonomous Database has Data Guard enabled.
is_dedicatedbooleanTrue if the database uses dedicated Exadata infrastructure.
is_free_tierbooleanIndicates if this is an Always Free resource. The default value is false.
is_previewbooleanIndicates if the Autonomous Database version is a preview version.
is_refreshable_clonebooleanIndicates whether the Autonomous Database is a refreshable clone.
key_store_idtextThe OCID of the key store.
key_store_wallet_nametextThe wallet name for Oracle Key Vault.
kms_key_idtextThe OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.
kms_key_version_idtextThe OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions.
license_modeltextThe Oracle license model that applies to the Oracle Autonomous Database.
lifecycle_detailstextInformation about the current lifecycle state.
lifecycle_statetextThe current state of the Autonomous Database.
nsg_idsjsonbA list of the OCIDs of the network security groups (NSGs) that this resource belongs to.
open_modetextThe `DATABASE OPEN` mode. You can open the database in `READ_ONLY` or `READ_WRITE` mode.
operations_insights_statustextStatus of Operations Insights for this Autonomous Database.
permission_leveltextThe Autonomous Database permission level.
private_endpointtextThe private endpoint for the resource.
private_endpoint_iptextThe private endpoint Ip address for the resource.
private_endpoint_labeltextThe private endpoint label for the resource.
refreshable_modetextThe refresh mode of the clone. AUTOMATIC indicates that the clone is automatically being refreshed with data from the source Autonomous Database.
refreshable_statustextThe refresh status of the clone. REFRESHING indicates that the clone is currently being refreshed with data from the source Autonomous Database.
regiontextThe OCI region in which the resource is located.
roletextThe role of the Autonomous Data Guard-enabled Autonomous Container Database.
service_console_urltextThe URL of the Service Console for the Autonomous Database.
source_idtextThe OCID of the source Autonomous Database that was cloned to create the current Autonomous Database.
standby_dbjsonbAutonomous Data Guard standby database details.
standby_whitelisted_ipsjsonbThe client IP access control list (ACL). This feature is available for autonomous databases on shared Exadata infrastructure and on Exadata Cloud@Customer. Only clients connecting from an IP address included in the ACL may access the Autonomous Database instance. For shared Exadata infrastructure, this is an array of CIDR (Classless Inter-Domain Routing) notations for a subnet or VCN OCID.
subnet_idtextThe OCID of the subnet the resource is associated with.
system_tagsjsonbSystem tags for resource. System tags can be viewed by users, but can only be created by the system.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
tenant_nametextThe name of the Tenant in which the resource is located.
time_createdtimestamp with time zoneThe date and time the Autonomous Database was created.
time_deletion_of_free_autonomous_databasetimestamp with time zoneThe date and time the Always Free database will be automatically deleted because of inactivity. If the database is in the STOPPED state and without activity until this time, it will be deleted.
time_maintenance_begintimestamp with time zoneThe date and time when maintenance will begin.
time_maintenance_endtimestamp with time zoneThe date and time when maintenance will end.
time_of_last_failovertimestamp with time zoneThe timestamp of the last failover operation.
time_of_last_refreshtimestamp with time zoneThe date and time when last refresh happened.
time_of_last_refresh_pointtimestamp with time zoneThe refresh point timestamp (UTC). The refresh point is the time to which the database was most recently refreshed. Data created after the refresh point is not included in the refresh.
time_of_last_switchovertimestamp with time zoneThe timestamp of the last switchover operation for the Autonomous Database.
time_of_next_refreshtimestamp with time zoneThe date and time of next refresh.
time_reclamation_of_free_autonomous_databasetimestamp with time zoneThe date and time the Always Free database will be stopped because of inactivity. If this time is reached without any database activity, the database will automatically be put into the STOPPED state.
titletextTitle of the resource.
used_data_storage_size_in_tbsbigintThe amount of storage that has been used, in terabytes.
vault_idtextThe OCID of the Oracle Cloud Infrastructure vault.
whitelisted_ipsjsonbThe client IP access control list (ACL).