---
title: "GET /subscriptions/{subscriptionId}/providers/Oracle.Database/locations/{location}/dbSystemShapes"
method: GET
path: "/subscriptions/{subscriptionId}/providers/Oracle.Database/locations/{location}/dbSystemShapes"
tags: ["DbSystemShapes"]
---

# GET /subscriptions/{subscriptionId}/providers/Oracle.Database/locations/{location}/dbSystemShapes

`GET /subscriptions/{subscriptionId}/providers/Oracle.Database/locations/{location}/dbSystemShapes`

List DbSystemShape resources by SubscriptionLocationResource

## Query parameters

- `zone` string
- `shapeAttribute` string

## Parameters

- `../../../../../common-types/resource-management/v5/types.json#/components/parameters/ApiVersionParameter` — unresolved $ref
- `../../../../../common-types/resource-management/v5/types.json#/components/parameters/SubscriptionIdParameter` — unresolved $ref
- `../../../../../common-types/resource-management/v5/types.json#/components/parameters/LocationParameter` — unresolved $ref

## Response `200`

Azure operation completed successfully.

- DbSystemShapeListResult — The response of a DbSystemShape list operation.
  - `value` DbSystemShape[], required — The DbSystemShape items on this page — unresolved $ref
  - `nextLink` string, uri — The link to the next page of items

## Other responses

- `default` — An unexpected error response.

## Changes

- **2026-07-13** (2023-09-01) `d55f77cf317d` — 1 info
  - added the new optional `query` request parameter `zone`
- **2024-06-20** (2023-09-01) `00c54443cc4c` — 2 warning
  - deleted the `query` request parameter `shapeAttribute`
  - deleted the `query` request parameter `zone`

[Change history](https://skmtc.dev/azure/apis/oracle-oracle-database/changes/subscriptions/:subscriptionId/providers/Oracle.Database/locations/:location/dbSystemShapes/get.md)

---

[API](https://skmtc.dev/azure/apis/oracle-oracle-database.md) · [All operations](https://skmtc.dev/azure/apis/oracle-oracle-database/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/azure/oracle-oracle-database/revisions/58d191295c2f/schema)