Back to plugin list
Official
Oracle
The CloudQuery Oracle plugin extracts Oracle Cloud Infrastructure data and loads it into any supported CloudQuery destination
Price
Free
Oracle Database Autonomous Databases
The oracle_database_autonomous_databases table shows data for Oracle Database Autonomous Databases.
The composite primary key for this table is compartment_id, id, region.
Columns
Name | Type |
---|---|
actual_used_data_storage_size_in_t_bs | float64 |
allocated_storage_size_in_t_bs | float64 |
apex_details | json |
are_primary_whitelisted_ips_used | bool |
autonomous_container_database_id | utf8 |
autonomous_maintenance_schedule_type | utf8 |
available_upgrade_versions | list<item: utf8, nullable> |
backup_config | json |
character_set | utf8 |
compartment_id | utf8 |
compute_count | float64 |
compute_model | utf8 |
connection_strings | json |
connection_urls | json |
cpu_core_count | int64 |
_cq_id | uuid |
_cq_parent_id | uuid |
customer_contacts | json |
database_edition | utf8 |
database_management_status | utf8 |
dataguard_region_type | utf8 |
data_safe_status | utf8 |
data_storage_size_in_g_bs | int64 |
data_storage_size_in_t_bs | int64 |
db_name | utf8 |
db_tools_details | json |
db_version | utf8 |
db_workload | utf8 |
defined_tags | json |
display_name | utf8 |
failed_data_recovery_in_seconds | int64 |
freeform_tags | json |
id | utf8 |
infrastructure_type | utf8 |
is_access_control_enabled | bool |
is_auto_scaling_enabled | bool |
is_auto_scaling_for_storage_enabled | bool |
is_data_guard_enabled | bool |
is_dedicated | bool |
is_free_tier | bool |
is_local_data_guard_enabled | bool |
is_mtls_connection_required | bool |
is_preview | bool |
is_reconnect_clone_enabled | bool |
is_refreshable_clone | bool |
is_remote_data_guard_enabled | bool |
key_history_entry | json |
key_store_id | utf8 |
key_store_wallet_name | utf8 |
kms_key_id | utf8 |
kms_key_lifecycle_details | utf8 |
kms_key_version_id | utf8 |
license_model | utf8 |
lifecycle_details | utf8 |
lifecycle_state | utf8 |
local_standby_db | json |
max_cpu_core_count | int64 |
memory_per_oracle_compute_unit_in_g_bs | int64 |
ncharacter_set | utf8 |
nsg_ids | list<item: utf8, nullable> |
ocpu_count | float64 |
open_mode | utf8 |
operations_insights_status | utf8 |
peer_db_ids | list<item: utf8, nullable> |
permission_level | utf8 |
private_endpoint | utf8 |
private_endpoint_ip | utf8 |
private_endpoint_label | utf8 |
provisionable_cpus | list<item: float64, nullable> |
refreshable_mode | utf8 |
refreshable_status | utf8 |
region | utf8 |
role | utf8 |
scheduled_operations | json |
service_console_url | utf8 |
source_id | utf8 |
standby_db | json |
standby_whitelisted_ips | list<item: utf8, nullable> |
subnet_id | utf8 |
supported_regions_to_clone_to | list<item: utf8, nullable> |
system_tags | json |
time_created | timestamp[us, tz=UTC] |
time_data_guard_role_changed | timestamp[us, tz=UTC] |
time_deletion_of_free_autonomous_database | timestamp[us, tz=UTC] |
time_local_data_guard_enabled | timestamp[us, tz=UTC] |
time_maintenance_begin | timestamp[us, tz=UTC] |
time_maintenance_end | timestamp[us, tz=UTC] |
time_of_last_failover | timestamp[us, tz=UTC] |
time_of_last_refresh | timestamp[us, tz=UTC] |
time_of_last_refresh_point | timestamp[us, tz=UTC] |
time_of_last_switchover | timestamp[us, tz=UTC] |
time_of_next_refresh | timestamp[us, tz=UTC] |
time_reclamation_of_free_autonomous_database | timestamp[us, tz=UTC] |
time_until_reconnect_clone_enabled | timestamp[us, tz=UTC] |
used_data_storage_size_in_t_bs | int64 |
vault_id | utf8 |
whitelisted_ips | list<item: utf8, nullable> |