steampipe plugin install oci

Table: oci_database_cloud_vm_cluster - Query OCI Database Cloud VM cluster using SQL

Oracle Cloud Database services, which can be deployed on virtual machines (VMs). A Database Cloud VM Cluster in OCI refers to a specific configuration or deployment option for hosting Oracle databases within a virtualized environment.

Table Usage Guide

The oci_database_cloud_vm_cluster table provides insights into Database Cloud VM cluster within Oracle Cloud Infrastructure Database service. As a database administrator or developer, explore specific details about these VM clusters, including their configurations, statuses, and associated metadata. Utilize this table to manage and monitor your databases, ensuring they are optimized, secure, and functioning as expected.

Examples

Basic info

Gain insights into the lifecycle state and creation time of your database cloud VM cluster to better understand their status and duration of existence. This is particularly useful for database management and auditing purposes.

select
cluster_name,
display_name,
lifecycle_state,
time_created,
shape
from
oci_database_cloud_vm_cluster;
select
cluster_name,
display_name,
lifecycle_state,
time_created,
shape
from
oci_database_cloud_vm_cluster;

List clusters that are not available

Discover the clusters that are currently not available. This can be useful to identify potential issues or disruptions in your cloud database services.

select
cluster_name,
display_name,
lifecycle_state,
time_created,
availability_domain
from
oci_database_cloud_vm_cluster
where
lifecycle_state <> 'AVAILABLE';
select
cluster_name,
display_name,
lifecycle_state,
time_created,
availability_domain
from
oci_database_cloud_vm_cluster
where
lifecycle_state <> 'AVAILABLE';

List VM clusters with core CPUs greater than 4

Identify databases with more than 4 core CPUs. This query is valuable because the number of core CPUs in a computer or server system depends on the specific tasks and processes it executes.

select
cluster_name,
display_name,
lifecycle_state,
time_created,
availability_domain,
subnet_id,
shape,
cpu_core_count
from
oci_database_cloud_vm_cluster
where
cpu_core_count > 4;
select
cluster_name,
display_name,
lifecycle_state,
time_created,
availability_domain,
subnet_id,
shape,
cpu_core_count
from
oci_database_cloud_vm_cluster
where
cpu_core_count > 4;

Get node details of clusters for cloud exadata infrastructures

Queries can assist in making scaling decisions. By analyzing the data from queries, you can determine whether you need to add more nodes to the cluster or remove underutilized nodes to optimize costs and performance.

select
c.cluster_name,
c.lifecycle_state as cluster_lifecycle_state,
c.subnet_id,
i.shape as infra_shape,
i.cpus_enabled,
i.storage_count
from
oci_database_cloud_vm_cluster as c,
oci_database_exadata_infrastructure as i
where
c.cloud_exadata_infrastructure_id = i.id;
select
c.cluster_name,
c.lifecycle_state as cluster_lifecycle_state,
c.subnet_id,
i.shape as infra_shape,
i.cpus_enabled,
i.storage_count
from
oci_database_cloud_vm_cluster as c,
oci_database_exadata_infrastructure as i
where
c.cloud_exadata_infrastructure_id = i.id;

Schema for oci_database_cloud_vm_cluster

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
availability_domaintextThe name of the availability domain that the cloud Exadata infrastructure resource is located in.
backup_network_nsg_idsjsonbA list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to.
backup_subnet_idtextThe OCID of the backup network subnet associated with the cloud VM cluster.
cloud_exadata_infrastructure_idtext=The OCID of the cloud Exadata infrastructure.
cluster_nametextThe cluster name for cloud VM cluster.
compartment_idtext=The OCID of the compartment in Tenant in which the resource is located.
cpu_core_countbigintThe number of CPU cores enabled on the cloud VM cluster.
data_collection_optionsjsonbThe data collection options of the cloud VM cluster.
data_storage_percentagebigintThe percentage assigned to DATA storage.
data_storage_size_in_tbsdouble precisionThe data disk group size to be allocated in TBs.
db_node_storage_size_in_gbsbigintThe local node storage to be allocated in GBs.
db_serversjsonbThe list of Db servers.
defined_tagsjsonbDefined tags for this resource.
disk_redundancytextThe type of redundancy configured for the cloud Vm cluster.
display_nametext=The user-friendly name for the cloud VM cluster.
domaintextThe domain name for the cloud VM cluster.
freeform_tagsjsonbFree-form tags for this resource.
gi_versiontextA valid Oracle Grid Infrastructure (GI) software version.
hostnametextThe hostname for the cloud VM cluster.
idtext=The OCID of the cloud VM cluster.
iorm_config_cachejsonbThe config cache details of the cloud VM cluster.
is_local_backup_enabledbooleanIf true, database backup on local Exadata storage is configured for the cloud VM cluster.
is_sparse_diskgroup_enabledbooleanIf true, sparse disk group is configured for the cloud VM cluster. If false, sparse disk group is not created.
last_update_history_entry_idtextThe OCID of the last maintenance update history entry. This value is updated when a maintenance update starts.
license_modeltextThe Oracle license model that applies to the cloud VM cluster. The default is LICENSE_INCLUDED.
lifecycle_detailstextAdditional information about the current lifecycle state.
lifecycle_statetext=The current state of the cloud VM cluster.
listener_portbigintThe port number configured for the listener on the cloud VM cluster.
memory_size_in_gbsbigintThe memory to be allocated in GBs.
node_countbigintThe number of nodes in the cloud VM cluster.
nsg_idsjsonbThe list of OCIDs for the network security groups (NSGs) to which this resource belongs.
ocpu_countdouble precisionThe number of OCPU cores to enable on the cloud VM cluster.
regiontextThe OCI region in which the resource is located.
scan_dns_nametextThe FQDN of the DNS record for the SCAN IP addresses associated with the cloud VM cluster.
scan_dns_record_idtextThe OCID of the DNS record for the SCAN IP addresses associated with the cloud VM cluster.
scan_ip_idsjsonbThe OCID of the Single Client Access Name (SCAN) IP addresses associated with the cloud VM cluster.
scan_listener_port_tcpbigintThe TCP Single Client Access Name (SCAN) port. The default port is 1521.
scan_listener_port_tcp_sslbigintThe TCPS Single Client Access Name (SCAN) port. The default port is 2484.
shapetextThe model name of the Exadata hardware running the cloud VM cluster.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
ssh_public_keysjsonbThe public key portion of one or more key pairs used for SSH access to the cloud VM cluster.
storage_size_in_gbsbigintThe storage allocation for the disk group, in gigabytes (GB).
subnet_idtextThe OCID of the subnet associated with the cloud VM cluster.
system_versiontextOperating system version of the image.
tagsjsonbA map of tags for the resource.
tenant_idtext=, !=, ~~, ~~*, !~~, !~~*The 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 that the cloud VM cluster was created.
time_zonetextThe time zone of the cloud VM cluster.
titletextTitle of the resource.
vip_idsjsonbThe OCID of the virtual IP (VIP) addresses associated with the cloud VM cluster.
zone_idtextThe OCID of the zone the cloud VM cluster is associated with.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- oci

You can pass the configuration to the command with the --config argument:

steampipe_export_oci --config '<your_config>' oci_database_cloud_vm_cluster