Back to plugin list
oracle
Official
Premium

Oracle

The CloudQuery Oracle plugin extracts Oracle Cloud Infrastructure data and loads it into any supported CloudQuery destination

Publisher

cloudquery

Repositorygithub.com
Latest version

v6.2.1

Type

Source

Platforms
Date Published

Price per 1M rows

Starting from $15

monthly free quota

1M rows

  • oracle_blockstorage_boot_volume_attachments
  • oracle_blockstorage_boot_volume_backups
  • oracle_blockstorage_boot_volume_replicas
  • oracle_blockstorage_boot_volumes
  • oracle_blockstorage_volume_backup_policies
  • oracle_blockstorage_volume_backups
  • oracle_blockstorage_volume_group_backups
  • oracle_blockstorage_volume_groups
  • oracle_blockstorage_volumes
  • oracle_compute_compute_capacity_reservations
  • oracle_compute_console_histories
  • oracle_compute_dedicated_vm_hosts
  • oracle_compute_images
  • oracle_compute_instance_console_connections
  • oracle_compute_instances
  • oracle_compute_vnic_attachments
  • oracle_compute_volume_attachments
  • oracle_database_autonomous_container_databases
  • oracle_database_autonomous_databases
  • oracle_database_autonomous_exadata_infrastructures
  • oracle_database_autonomous_vm_clusters
  • oracle_database_backup_destination
  • oracle_database_cloud_autonomous_vm_clusters
  • oracle_database_cloud_exadata_infrastructures
  • oracle_database_cloud_vm_clusters
  • oracle_database_exadata_infrastructures
  • oracle_database_external_container_databases
  • oracle_database_external_non_container_databases
  • oracle_database_external_pluggable_databases
  • oracle_database_key_stores
  • oracle_database_vm_clusters
  • oracle_filestorage_exports
  • oracle_filestorage_export_sets
  • oracle_filestorage_file_systems
  • oracle_filestorage_mount_targets
  • oracle_filestorage_replications
  • oracle_filestorage_replication_targets
  • oracle_identity_compartments
  • oracle_identity_cost_tracking_tags
  • oracle_identity_domains
  • oracle_identity_dynamic_groups
  • oracle_identity_groups
  • oracle_identity_iam_work_requests
  • oracle_identity_network_sources
  • oracle_identity_policies
  • oracle_identity_tagging_work_requests
  • oracle_identity_tag_namespaces
  • oracle_identity_users
  • oracle_identity_work_requests
  • oracle_loadbalancer_load_balancers
  • oracle_networkfirewall_network_firewall_policies
  • oracle_networkfirewall_network_firewalls
  • oracle_networkfirewall_work_requests
  • oracle_networkloadbalancer_network_load_balancers
  • oracle_networkloadbalancer_work_requests
  • oracle_objectstorage_buckets
  • oracle_objectstorage_work_requests
  • oracle_virtualnetwork_assigned_public_ips
  • oracle_virtualnetwork_byoip_ranges
  • oracle_virtualnetwork_capture_filters
  • oracle_virtualnetwork_cpes
  • oracle_virtualnetwork_cross_connect_groups
  • oracle_virtualnetwork_cross_connects
  • oracle_virtualnetwork_dhcp_options
  • oracle_virtualnetwork_drg_attachments
  • oracle_virtualnetwork_drgs
  • oracle_virtualnetwork_ephemeral_public_ips
  • oracle_virtualnetwork_fast_connect_provider_services
  • oracle_virtualnetwork_internet_gateways
  • oracle_virtualnetwork_ip_sec_connections
  • oracle_virtualnetwork_local_peering_gateways
  • oracle_virtualnetwork_nat_gateways
  • oracle_virtualnetwork_private_ips
  • oracle_virtualnetwork_public_ip_pools
  • oracle_virtualnetwork_remote_peering_connections
  • oracle_virtualnetwork_reserved_public_ips
  • oracle_virtualnetwork_route_tables
  • oracle_virtualnetwork_security_lists
  • oracle_virtualnetwork_service_gateways
  • oracle_virtualnetwork_subnets
  • oracle_virtualnetwork_vcns
  • oracle_virtualnetwork_virtual_circuits
  • oracle_virtualnetwork_vlans
  • oracle_virtualnetwork_vtaps

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
NameType
actual_used_data_storage_size_in_t_bsfloat64
allocated_storage_size_in_t_bsfloat64
apex_detailsjson
are_primary_whitelisted_ips_usedbool
autonomous_container_database_idutf8
autonomous_maintenance_schedule_typeutf8
auto_refresh_frequency_in_secondsint64
auto_refresh_point_lag_in_secondsint64
available_upgrade_versionslist<item: utf8, nullable>
backup_configjson
backup_retention_period_in_daysint64
character_setutf8
compartment_idutf8
compute_countfloat64
compute_modelutf8
connection_stringsjson
connection_urlsjson
cpu_core_countint64
_cq_iduuid
_cq_parent_iduuid
customer_contactsjson
database_editionutf8
database_management_statusutf8
dataguard_region_typeutf8
data_safe_statusutf8
data_storage_size_in_g_bsint64
data_storage_size_in_t_bsint64
db_nameutf8
db_tools_detailsjson
db_versionutf8
db_workloadutf8
defined_tagsjson
disaster_recovery_region_typeutf8
display_nameutf8
failed_data_recovery_in_secondsint64
freeform_tagsjson
idutf8
infrastructure_typeutf8
in_memory_area_in_g_bsint64
in_memory_percentageint64
is_access_control_enabledbool
is_auto_scaling_enabledbool
is_auto_scaling_for_storage_enabledbool
is_data_guard_enabledbool
is_dedicatedbool
is_dev_tierbool
is_free_tierbool
is_local_data_guard_enabledbool
is_mtls_connection_requiredbool
is_previewbool
is_reconnect_clone_enabledbool
is_refreshable_clonebool
is_remote_data_guard_enabledbool
key_history_entryjson
key_store_idutf8
key_store_wallet_nameutf8
kms_key_idutf8
kms_key_lifecycle_detailsutf8
kms_key_version_idutf8
license_modelutf8
lifecycle_detailsutf8
lifecycle_stateutf8
local_adg_auto_failover_max_data_loss_limitint64
local_disaster_recovery_typeutf8
local_standby_dbjson
long_term_backup_schedulejson
memory_per_oracle_compute_unit_in_g_bsint64
ncharacter_setutf8
net_services_architectureutf8
next_long_term_backup_time_stamptimestamp[us, tz=UTC]
nsg_idslist<item: utf8, nullable>
ocpu_countfloat64
open_modeutf8
operations_insights_statusutf8
peer_db_idslist<item: utf8, nullable>
permission_levelutf8
private_endpointutf8
private_endpoint_iputf8
private_endpoint_labelutf8
provisionable_cpuslist<item: float64, nullable>
refreshable_modeutf8
refreshable_statusutf8
regionutf8
remote_disaster_recovery_configurationjson
resource_pool_leader_idutf8
resource_pool_summaryjson
roleutf8
scheduled_operationsjson
service_console_urlutf8
source_idutf8
standby_dbjson
standby_whitelisted_ipslist<item: utf8, nullable>
subnet_idutf8
supported_regions_to_clone_tolist<item: utf8, nullable>
system_tagsjson
time_createdtimestamp[us, tz=UTC]
time_data_guard_role_changedtimestamp[us, tz=UTC]
time_deletion_of_free_autonomous_databasetimestamp[us, tz=UTC]
time_disaster_recovery_role_changedtimestamp[us, tz=UTC]
time_local_data_guard_enabledtimestamp[us, tz=UTC]
time_maintenance_begintimestamp[us, tz=UTC]
time_maintenance_endtimestamp[us, tz=UTC]
time_of_auto_refresh_starttimestamp[us, tz=UTC]
time_of_joining_resource_pooltimestamp[us, tz=UTC]
time_of_last_failovertimestamp[us, tz=UTC]
time_of_last_refreshtimestamp[us, tz=UTC]
time_of_last_refresh_pointtimestamp[us, tz=UTC]
time_of_last_switchovertimestamp[us, tz=UTC]
time_of_next_refreshtimestamp[us, tz=UTC]
time_reclamation_of_free_autonomous_databasetimestamp[us, tz=UTC]
time_until_reconnect_clone_enabledtimestamp[us, tz=UTC]
total_backup_storage_size_in_g_bsfloat64
used_data_storage_size_in_g_bsint64
used_data_storage_size_in_t_bsint64
vault_idutf8
whitelisted_ipslist<item: utf8, nullable>
Subscribe to product updates

Be the first to know about new features.