db_servers

Creates, updates, deletes, gets or lists a db_servers resource.

Overview

Name	db_servers
Type	Resource
Id	azure_isv.oracle.db_servers

Fields

vw_db_servers

Name	Datatype	Description
autonomous_virtual_machine_ids	text	field from the properties object
autonomous_vm_cluster_ids	text	field from the properties object
cloudexadatainfrastructurename	text	field from the properties object
compartment_id	text	field from the properties object
cpu_core_count	text	field from the properties object
db_node_ids	text	field from the properties object
db_node_storage_size_in_gbs	text	field from the properties object
db_server_patching_details	text	field from the properties object
dbserverocid	text	field from the properties object
display_name	text	field from the properties object
exadata_infrastructure_id	text	field from the properties object
lifecycle_details	text	field from the properties object
lifecycle_state	text	field from the properties object
max_cpu_count	text	field from the properties object
max_db_node_storage_in_gbs	text	field from the properties object
max_memory_in_gbs	text	field from the properties object
memory_size_in_gbs	text	field from the properties object
ocid	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
shape	text	field from the properties object
subscriptionId	text	field from the properties object
time_created	text	field from the properties object
vm_cluster_ids	text	field from the properties object

db_servers

Name	Datatype	Description
properties	object	DbServer resource properties

Methods

Name	Accessible by	Required Params	Description
get	SELECT	cloudexadatainfrastructurename, dbserverocid, resourceGroupName, subscriptionId	Get a DbServer

SELECT examples

Get a DbServer

vw_db_servers

SELECT
autonomous_virtual_machine_ids,
autonomous_vm_cluster_ids,
cloudexadatainfrastructurename,
compartment_id,
cpu_core_count,
db_node_ids,
db_node_storage_size_in_gbs,
db_server_patching_details,
dbserverocid,
display_name,
exadata_infrastructure_id,
lifecycle_details,
lifecycle_state,
max_cpu_count,
max_db_node_storage_in_gbs,
max_memory_in_gbs,
memory_size_in_gbs,
ocid,
provisioning_state,
resourceGroupName,
shape,
subscriptionId,
time_created,
vm_cluster_ids
FROM azure_isv.oracle.vw_db_servers
WHERE cloudexadatainfrastructurename = '{{ cloudexadatainfrastructurename }}'
AND dbserverocid = '{{ dbserverocid }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

db_servers

SELECT
properties
FROM azure_isv.oracle.db_servers
WHERE cloudexadatainfrastructurename = '{{ cloudexadatainfrastructurename }}'
AND dbserverocid = '{{ dbserverocid }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';