Skip to content

oracleDatabases

Paginated list of Oracle Databases.

Arguments

Argument Type Description
first Int Returns the first n elements from the list.
after String An opaque cursor returned from a previous query's endCursor field. Pass this value verbatim to retrieve the next page of results.
last Int Returns the last n elements from the list.
before String An opaque cursor returned from a previous query's startCursor field. Pass this value verbatim to retrieve the previous page of results.
sortBy HierarchySortByField Sort hierarchy objects according to the hierarchy field.
sortOrder SortOrder Sorts the order of results.
filter [Filter!] Hierarchy object filter.

Returns

OracleDatabaseConnection!

Sample

query {
  oracleDatabases(first: 10) {
    nodes {
      archiveLogMode
      authorizedOperations
      cdmId
      cdmLink
      cdmPendingObjectPauseAssignment
      dataGuardType
      dbRole
      dbUniqueName
      hostLogRetentionHours
      id
      isLiveMount
      isRelic
      isReplica
      isZeroRpoEnabled
      legallyHeldSnapshotCount
      logBackupFrequency
      logRatePerRmanChannelInMb
      logRetentionHours
      name
      numChannels
      numInstances
      numLogSnapshots
      numTablespaces
      numWorkloadDescendants
      objectType
      onDemandSnapshotCount
      osNames
      osType
      ratePerRmanChannelInMb
      rbaRole
      replicatedObjectCount
      sectionSizeInGigabytes
      slaAssignment
      slaPauseStatus
      tablespaces
      useSecureThrift
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}

{}

{
  "data": {
    "oracleDatabases": {
      "nodes": [
        [
          {
            "archiveLogMode": "example-string",
            "authorizedOperations": [
              "ACCESS_CDM_CLUSTER"
            ],
            "cdmId": "example-string",
            "cdmLink": "example-string",
            "cdmPendingObjectPauseAssignment": "NO_PENDING_PAUSE_ASSIGNMENT",
            "dataGuardType": "DATA_GUARD_GROUP"
          }
        ]
      ],
      "pageInfo": {
        "endCursor": "example-string",
        "hasNextPage": true,
        "hasPreviousPage": true,
        "startCursor": "example-string"
      }
    }
  }
}