Oracle Cloud Infrastructure Documentation

List of Executions

Use this API to fetch list the Exadata Scale Up or Scale Down executions.

API

/exadata/v1/customers/{customerId}/instances/executions

Scope and AuthZ

  • You must have mcs:oci:api:User scope to access this API.
  • You can get list of Exadata Scale Up and Scale Down execution only for the customer.
  • You can use Exadata Scale Up and Scale Down API only if customer has opts-in for Exadata Scale Up or Scale Down functionality.

Headers

  • Authorization: Bearer <Token>

    Where <Token> is the OAUTH token returned by the Authorization Server (JWT Token).

  • Identifier: <JWKS Identifier>

    Where <JWKS Identifier> is the GUID generated when JWKS URI is set by customer admin in self-service platform.

Base Path

/exadata/v1/

Functionality

  • Fetches the list of Exadata executions.
  • id is execution ID.
  • name is name of the patch.
  • ticketingDetails.rfcNumber is rfc Number for given execution
  • createdBy is email ID of the person who created the patch.
  • createdOn is timestamp at which the patch was created.

Verb

GET

Parameters

Name Type Description Mandatory Comments
cutomerId Path parameter Customer ID Yes
includeDetails Query parameter This flag denotes if DB details to be retrieved as part of response No
q Query parameter No
Currently supported fields:

  • db System name

  • db System shape

  • db system tenancy name

  • db system tenancy region

  • db name

  • RFC Number

  • Environment Name
Note

Pagination is supported. For more information, see Pagination section.

Sample response

[
    {
        "createdBy": "<email ID>",
        "createdOn": "2021-10-11T09:52:52Z",
        "id": 779,
        "ticketingDetails": {
            "rfcNumber": "3-BLEH3J5"
        },
        "dbSystem": {
            "databases": [
                {
                    "name": "DWHPRD",
                    "ocpuCountNew": 15
                }
            ],
            "name": "avvaexa01pr",
            "ocpuCountNew": 14,
            "ocpuCountOld": 84,
            "shape": "Exadata.Half2.184",
            "tenancy": {
                "name": "avva01",
                "region": "uk-london-1"
            }
        },
        "instance": "OMCEBSOR3"
    },
    {
        "createdBy": "<email ID>",
        "createdOn": "2021-10-11T07:20:20Z",
        "id": 777,
        "ticketingDetails": {
            "rfcNumber": "3-BLEH3IT"
        },
        "dbSystem": {
            "databases": [
                {
                    "name": "DWHPRD",
                    "ocpuCountNew": 18
                }
            ],
            "name": "avvaexa01pr",
            "ocpuCountNew": 17,
            "ocpuCountOld": 84,
            "shape": "Exadata.Half2.184",
            "tenancy": {
                "name": "avva01",
                "region": "uk-london-1"
            }
        },
        "instance": "OMCEBSOR3"
    }
]