Skip to main content

db_servers

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

Overview​

Namedb_servers
TypeResource
Idgoogle.oracledatabase.db_servers

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringIdentifier. The name of the database server resource with the format: projects/{project}/locations/{location}/cloudExadataInfrastructures/{cloud_exadata_infrastructure}/dbServers/{db_server}
displayNamestringOptional. User friendly name for this resource.
propertiesobjectOptional. Various properties of the database server. (id: DbServerProperties)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectprojectsId, locationsId, cloudExadataInfrastructuresIdpageSize, pageTokenLists the database servers of an Exadata Infrastructure instance.

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
cloudExadataInfrastructuresIdstring
locationsIdstring
projectsIdstring
pageSizeinteger (int32)
pageTokenstring

SELECT examples​

Lists the database servers of an Exadata Infrastructure instance.

SELECT
name,
displayName,
properties
FROM google.oracledatabase.db_servers
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND cloudExadataInfrastructuresId = '{{ cloudExadataInfrastructuresId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;